vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Chat Modifications - MGC Chatbox Evo (https://vborg.vbsupport.ru/showthread.php?t=168992)

goxy63 02-13-2010 08:03 AM

Quote:

Originally Posted by Ranger187 (Post 1981098)
Yes, it works on VBa. Stagger supports that.

I know that but 'Stangger5' module is not working with latest MGC Chatbox .... Iam not using his module.... using way around as you can see through that link above, what I was asking is would it work as it should in that way without any problems (dont have enoguh time to test it)...!?

Thanks

yoyoman 02-13-2010 12:51 PM

Hi! I bought the license. Waiting for activation ;)

In the meanwhile, can you give me hint where do I modify the "rules page", the "help page" and other stuff that the users can see? I need to translate them to Russian.

Ranger187 02-13-2010 11:21 PM

Quote:

Originally Posted by goxy63 (Post 1981243)
I know that but 'Stangger5' module is not working with latest MGC Chatbox .... Iam not using his module.... using way around as you can see through that link above, what I was asking is would it work as it should in that way without any problems (dont have enoguh time to test it)...!?

Thanks

It does work with 2.4.2. I had it on all my sites.

Quote:

Originally Posted by yoyoman (Post 1981359)
Hi! I bought the license. Waiting for activation ;)

In the meanwhile, can you give me hint where do I modify the "rules page", the "help page" and other stuff that the users can see? I need to translate them to Russian.

In the options. ;)

TheLastSuperman 02-13-2010 11:36 PM

Quote:

Originally Posted by Twisted Shifter (Post 1979652)
Well I have followed the uninstall, everything appears to be gone, yet I still get the error messages ...... HELP, please make it stop.......

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT * FROM chatbox ORDER BY dateline ASC LIMIT 0,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Request Date : Wednesday, February 10th 2010 @ 06:49:52 PM
Error Date : Wednesday, February 10th 2010 @ 06:49:52 PM
Script :
Referrer :
IP Address : 208.80.193.27
Username : Unregistered
Classname : vB_Database
MySQL Version :

Quote:

Originally Posted by Ranger187 (Post 1980148)
This is not the chat.

Quote:

Originally Posted by Twisted Shifter (Post 1980791)
Invalid SQL:
SELECT * FROM chatbox ORDER BY dateline ASC LIMIT 0,;

Why is it saying chatbox then? & the script that its trying to hit is chatbox.php

I have been looking up the IPs of the offending parties and they seem to be google & MS bots. Do they search from cached pages.

Another modification can be causing the Chat to act up, again it does not mean it's the chat specifically although that does lead you to believe such... do you have vBOptimise installed?? If so disable it to see it that helps otherwise I had a similar issue with the chatbox AND users not being able to switch styles when I had done 4 styles for a new client and after tracking it down to vB Optimise I had to uninstall it completely before the Chatbox and the style changer would work properly. I like vB Optimise but some forums and other modifications do not get along with it.

Ranger187 02-13-2010 11:57 PM

Quote:

Originally Posted by TheLastSuperman (Post 1981751)
Another modification can be causing the Chat to act up, again it does not mean it's the chat specifically although that does lead you to believe such... do you have vBOptimise installed?? If so disable it to see it that helps otherwise I had a similar issue with the chatbox AND users not being able to switch styles when I had done 4 styles for a new client and after tracking it down to vB Optimise I had to uninstall it completely before the Chatbox and the style changer would work properly. I like vB Optimise but some forums and other modifications do not get along with it.

This is already resolved. Thanks.

kronnos 02-14-2010 01:29 PM

Ok Ive been having many database errors and noticed that the chatbox has been eating up most of the resources. Obviously the chatbox does not show to unregistered visitors and the auto refresh in about 60 sec and its still a huge problem. BTW, im still running v2.3.2.

Anyway, I noticed that my mgc_cb_evo_chat database is about 40MG which is only half as small as the post database with over 200k posts. Im thinking could that be the problem? Do you guys delete old chats?

BTW, displaying avatars in posts, adds a few extra sql queries right?

gmerin 02-14-2010 04:56 PM

Quote:

Originally Posted by Twisted Shifter (Post 1979652)
Well I have followed the uninstall, everything appears to be gone, yet I still get the error messages ...... HELP, please make it stop.......

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT * FROM chatbox ORDER BY dateline ASC LIMIT 0,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Request Date : Wednesday, February 10th 2010 @ 06:49:52 PM
Error Date : Wednesday, February 10th 2010 @ 06:49:52 PM
Script :
Referrer :
IP Address : 208.80.193.27
Username : Unregistered
Classname : vB_Database
MySQL Version :

fyi, "select * from chatbox" translates to "get every row from the table chatbox..etc", but there is no table in mgc chatbox evo called "chatbox" (it's tables are all prefixed by mgc_cb_evo_) which suggests the error is referring to another mod.

gmerin 02-14-2010 05:00 PM

Quote:

Originally Posted by kronnos (Post 1982122)
Ok Ive been having many database errors and noticed that the chatbox has been eating up most of the resources. Obviously the chatbox does not show to unregistered visitors and the auto refresh in about 60 sec and its still a huge problem. BTW, im still running v2.3.2.

Anyway, I noticed that my mgc_cb_evo_chat database is about 40MG which is only half as small as the post database with over 200k posts. Im thinking could that be the problem? Do you guys delete old chats?

BTW, displaying avatars in posts, adds a few extra sql queries right?

a suggestion: disable ajax (problematic ajax should be enough to disable) in vbulletin options and see if the utilization remains high. mgc_cb_evo_ajax.php always drives my load avg thru the roof by making a lot of database queries and disabling the problematic ajax seems to limit it.

Ranger187 02-14-2010 05:39 PM

Quote:

Originally Posted by kronnos (Post 1982122)
Ok Ive been having many database errors and noticed that the chatbox has been eating up most of the resources. Obviously the chatbox does not show to unregistered visitors and the auto refresh in about 60 sec and its still a huge problem. BTW, im still running v2.3.2.

Anyway, I noticed that my mgc_cb_evo_chat database is about 40MG which is only half as small as the post database with over 200k posts. Im thinking could that be the problem? Do you guys delete old chats?

BTW, displaying avatars in posts, adds a few extra sql queries right?

It's 40 megs because you are not pruning your chat at ALL. So, when someone comes to the site, it loads a huge file keeping cpu usage high. ;)

kronnos 02-14-2010 06:03 PM

Im prunning just at a 30 day interval. Now changed it to 7 days and removed the avatars. Will see what happens....


All times are GMT. The time now is 02:13 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06805 seconds
  • Memory Usage 1,757KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (7)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete