Thread: Chat Modifications - MGC Chatbox Evo
View Single Post
  #4214  
Old 02-09-2009, 05:24 AM
VBDev's Avatar
VBDev VBDev is offline
 
Join Date: Jan 2004
Location: France
Posts: 2,570
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MDK-Indy View Post
If i move more than one Thread from a sub-forum to another sub-forum i have a Database error.

Code:
Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:

            INSERT INTO vbmgc_cb_evo_chat
                (dateline,fromuid,ctext,sticky,chanid,coidentifier,iswarning,warningtype,tpforumid)
            VALUES
                (1234098648,,'7293,Spionagenetzt',0,0,0,1,'thread',26);

MySQL Error   : Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei ''7293,Spionagenetzt',0,0,0,1,'thread',26)' in Zeile 4
Error Number  : 1064
Request Date  : Sunday, February 8th 2009 @ 02:10:48 PM
Error Date    : Sunday, February 8th 2009 @ 02:10:48 PM
Script        : http://forum......de/inlinemod.php?do=domovethreads&threadids=4731,7252,4730
Referrer      : http://forum.......de/inlinemod.php?forumid=26
IP Address    : 217.84.243.65
Username      : Indy
Classname     : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log
Was this with the very latest files from here ?

Coz there had been problems with the earlier version 2.2.0.

Quote:
Originally Posted by exyuteam View Post
OK. I will explain with PrnScr Just to say again, option Align usernames and chats are ON, and it's NOT WORKING on Firefox 3.0.6. (chat ver. 2.2.1), and WORKING OK in Chrome, IE 6, IE 7, Safari, and Firefox 2.0.0.20 (not try with other versions).... PrnScr from Chrome, Firefox 2.0.0.20 and Firefox 3.0.6 are attahed.....

Thanks m8
Wow my damn very odd, I am marking this in the bug list to be checked.

Quote:
Originally Posted by entertain View Post
Hey, is this correct to fix it like this?

/admincp/mgc_cb_evo.php
PHP Code:
$vbulletin->db->query_first("SELECT MIN(dateline) AS start FROM " TABLE_PREFIX "mgc_cb_evo_chat WHERE isthreadwarning='0' AND ispostwarning='0'"); 
Replace by
PHP Code:
$vbulletin->db->query_first("SELECT MIN(dateline) AS start FROM " TABLE_PREFIX "mgc_cb_evo_chat WHERE iswarning='0'"); 
Or is there more that have to be changed?
Yes that is

Quote:
Originally Posted by ibeteck View Post
I would like to know if there is a way to make the chatbox faster I already changed the refresh intervals but didn't seem to make a difference. Also I want to clear out my archives I don't know if that might help out to make it faster. How can I clear my archive for the chat?
Well what is not fast for you ? Retrieving of chats data do takes time as it loads all data from ajax but that will be the case with any chatbox.

I might be implementing a kinda cache system in a release of the chatbox later this year to speed things up.

Quote:
Originally Posted by Gamempire View Post
well, i study the error that firebug gives me:

Code:
uncaught exception: [Exception... "Component returned failure code: 0x80004003 (NS_ERROR_INVALID_POINTER) [nsIDOMHTMLTableSectionElement.appendChild]" nsresult: "0x80004003 (NS_ERROR_INVALID_POINTER)" location: "JS frame :: http://yui.yahooapis.com/combo?2.6.0...ntainer-min.js :: anonymous :: line 50" data: no]
the error: NS_ERROR_INVALID_POINTER mean that there is something( "nsIDOMHTMLTableSectionElement") that the script can't append (the comand is: nsIDOMHTMLTableSectionElement.appendChild)

this create an infinite loop when the chatbox try to connect with ajax to the mysql database

(i have this problem with firefox and chrome, not with internet explorer)

i tried to empty cache and other things..nothing



can you fix it?


i would be very gratefully


EDIT: i also tried disabling all the other products, and it doesn't work
Hum very strange. It seems like your using yui files for chatbox from Yahoo server.

Had you try with local files ? (you can select that in chatbox options)
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01244 seconds
  • Memory Usage 1,800KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (2)bbcode_php
  • (5)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete