vb.org Archive - Chat Modifications

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

exyuteam

02-08-2009 11:24 AM

1 Attachment(s)

Quote:

Originally Posted by VBDev (Post 1737327)

I don't have that problem, please explain

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 :cool:

entertain

02-08-2009 12:18 PM

Quote:

Originally Posted by MDK-Indy (Post 1737673)

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

That should fix it temporary:

Plug-in: Newthread notification handling (moderation)

Search for:

PHP Code:


		
			
(" . TIMENOW . "," . $this->existing['postuserid'] . ",'" . $this->dbobject->escape_string($tinfo['threadid'] . "," . $tinfo['title']) . "',0,0,0,1,'thread'," . $tinfo['forumid'] . ")

Replace by

PHP Code:


		
			
(" . TIMENOW . "," . $tinfo['firstpostid'] . ",'" . $this->dbobject->escape_string($tinfo['threadid'] . "," . $tinfo['title']) . "',0,0,0,1,'thread'," . $tinfo['forumid'] . ")

The only problem will be, that when somebody moves a thread, it will be posted as an anonymous shout. But it fixes the database error and this is more important. :)

entertain

02-08-2009 03:10 PM

Quote:

Originally Posted by VBDev (Post 1737055)

Ho ! Yes I changed that in 2.1.0 and didn't remember there was an impact on the counters update.

Marked as bug for the next version.

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? :o

ibeteck

02-08-2009 04:50 PM

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?

DotSauce

02-08-2009 05:30 PM

Quote:

Originally Posted by ibeteck (Post 1737880)

Go to Chat Commands in administration and enable the /del command.

Then in chat type /del all or something like that.

Gamempire

02-08-2009 05:33 PM

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

Falon

02-08-2009 06:30 PM

I have got ready installed this mod. But in my AdminCP when i going to Manage commands, Manage channels, View logs, Import scripts, Counters update i see only white page on my right side of AdminCP.

Mod is working. I can see on forum and using. But without Import scripts, Manage channels is not good for me.
?????

nath89

02-08-2009 06:43 PM

when i enable the chatbox nothing comes up on my homepage at all. just a blank screen?

acegames

02-08-2009 07:12 PM

Quote:

Originally Posted by MDK-Indy (Post 1737673)

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

I had this , so I switched off new post/thread notification until its fixed

All times are GMT. The time now is 05:51 AM.

Page 421 of 880

421

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10219 seconds Memory Usage 1,768KB 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 (4)bbcode_code_printable (4)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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
Messages: