vb.org Archive - Chat Modifications

I have read almost all thread to find a fix for my problem. I have posted before and hopefully the coder will help me out...

I installed first time the ChatBox and worked fine (damn me, I should of leave it like that!) but added CMPS module that did not worked for me. I have uninstalled it (both the module and ChatBox) and completly removing absolutely all files. I started fresh, fixed the permissions in the Usergroups, settings, etc. and when I try to post something I get a page with:
"Your submission could not be processed because a security token was missing.
If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error."

- I have uninstalled it, removed all files, made sure there is nothing in templates.
- I have reloaded all files, installed the product, fixed the permissions (all other settings as default) and still the same message.
- I have optimized/fixed the db, ran the maintenance with most activities there, clean the browser cache (I've tried it on two different computers and three browsers.
- I have re-uploaded the ChatBox files, installed it as an upgrade, fixed the permissions, and i still get this message:
"Your submission could not be processed because a security token was missing.
If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error."

Also, when I click on smilies link, the page moves down to the ChatBox limit and the link in the browser is: http://www.myforum.com/forum/index.php#mgc_cb_evo_top

I ma struggling with this from more than two days and don't know what else I should do. Please help me out.

Exact the same problem here

Quote:

Originally Posted by VBDev (Post 1740645)

You refreshed your cache after install ?

Otherwise if using 2.2.1 you shouldn't encounter that issue.
Have you a vB 3.6 version ?

MGC Chatbox Evo version ist 2.2.1, vBulletin version is 3.8.1
Which cache do i have to refresh after install?

SnapOff Racing

02-18-2009 11:12 AM

Quote:

Originally Posted by VBDev (Post 1746580)

So chats doesn't get aligned in other browser than firefox when the order of the shouts is set to be newest at the top ?

No mine works just fine. I have tried using the "Chats display order" set as Newest First and Oldest First and they both work fine. I tested in IE, FF 3.0.6, and Safari... I'm running vb 3.8.1

Also I notice that two tables are missing from the new 2.2.1 version
isthreadwarning
ispostwarning

Have these tables been removed from the coding altogether or are they for an option that I just don't have enabled yet? Can I just go ahead and remove these tables from my db?

Adromir

02-18-2009 11:50 AM

I think i have the same problem as d0nbiz and OblivionMage:
I am trying to use the ChatBox 2.2.1 on a 3.8.1 vbulletin with default style and the chatbox simply doesnt show anywhere..

VBDev

02-18-2009 03:54 PM

Quote:

Originally Posted by DangerousDale (Post 1746841)

Hello,

I am wondering if you can help me, I have installed this mod and I am trying to intergrate it into the ibproarcade.

I have followed the instruction in the readme and added in the arcade template but nothing shows at all.

I am using VB 3.8.0, just cant figure out why its doing nothing at all.

Any help will be much appreciated.

It's showing everywhere except in the arcade ?

You have configured both options and change the arcade file ?

Quote:

Originally Posted by OblivionMage (Post 1747193)

Thanks for the help!

But I just tried a clean install (Deleted files / edits, product, then reinstalled) and the issue seems to persist (doesn't show). (2.2.1. was used)

Any ideas?

Does it appear or does it only just not load chats ?

Can you check in Firefox error console and tell me if anything's wrong.

Quote:

Originally Posted by d0nbiz (Post 1747234)

No, it doesn't appear at all. I've set usergroups for it aswell and still nothing.

Yeah I've set them. It was working before the update just not anymore'

Before update to vB3.8 ? or chatbox update ?

VBDev

02-18-2009 03:57 PM

Quote:

Originally Posted by brun0 (Post 1747752)

Exact the same problem here

MGC Chatbox Evo version ist 2.2.1, vBulletin version is 3.8.1
Which cache do i have to refresh after install?

You can't have token errors with vBulletin version 3.8.1 unless you have chatbox templates not reverted.

Is it the case ?

Quote:

Originally Posted by SnapOff Racing (Post 1747790)

Yes they have been removed and the install script should have removed them.

Quote:

Originally Posted by Adromir (Post 1747831)

I think i have the same problem as d0nbiz and OblivionMage:
I am trying to use the ChatBox 2.2.1 on a 3.8.1 vbulletin with default style and the chatbox simply doesnt show anywhere..

If your chatbox doesn't display it might be a style issue or usergroup permissions not set.

I don't see any other reason.

VBDev

02-18-2009 04:03 PM

Quote:

Originally Posted by kronnos (Post 1747198)

There seems to be an error when trying to import from Dream Chat. It always stops at the same chat 12000~ish and gives the following sql error:

Database error in vBulletin 3.8.1:

Invalid SQL:

INSERT INTO bl_mgc_cb_evo_chat
SET
dateline='1203541396',
fromuid='738',
touid='0',
name='96'Blaster240',
ctext='my blaster just got spark! :)',
chanid='0',
userip='95.272.104.81',
coidentifier='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 'Blaster240',
ctext='my blaster just got spark! :)',
chanid='0',
' at line 6
Error Number : 1064
Request Date : Tuesday, February 17th 2009 @ 04:26:17 PM
Error Date : Tuesday, February 17th 2009 @ 04:26:18 PM
Script : http://mystite/admincp/mgc_cb_evo.ph...=10500&teamid=
Referrer : http://mysite/admincp/mgc_cb_evo.php...=10400&teamid=
IP Address : 95.132.221.101
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-community

Well yeah my fault, here is a fix for all the imports :

Search for :

Code:

name='" . $cchatbox_chats['username'] . "',

Replace it by :

Code:

name='" . $vbulletin->db->escape_string($cchatbox_chats['username']) . "',

Search for :

Code:

name='" . $dream_chats['username'] . "',

Replace it by :

Code:

name='" . $vbulletin->db->escape_string($dream_chats['username']) . "',

Search for :

Code:

name='" . $diondev_chats['username'] . "',

Replace it by :

Code:

name='" . $vbulletin->db->escape_string($diondev_chats['username']) . "',

kronnos

02-18-2009 04:28 PM

Cool, thanks. Will this all be updated in the next mod update release? BTW, any plans for the next update with some error fixes?

Skyrider

02-18-2009 05:16 PM

Sorry VBDev, I "approved" once another moderated thread, and got the database error again:

Quote:

Database error in vBulletin 3.8.0:

Invalid SQL:

INSERT INTO mgc_cb_evo_chat
(dateline,fromuid,ctext,sticky,chanid,coidentifier ,iswarning,warningtype,tpforumid)
VALUES
(1234984512,,'73301,Adding bots to dedicated server',0,0,0,1,'thread',63);

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 ''73301,Adding bots to dedicated server',0,0,0,1,'thread',63)' at line 4
Error Number : 1064
Request Date : Wednesday, February 18th 2009 @ 08:15:12 PM
Error Date : Wednesday, February 18th 2009 @ 08:15:12 PM
Script : http://forum.esforces.com/inlinemod....eadid=73301&p=
Referrer : http://forum.esforces.com/showthread.php?t=73301
IP Address : xxxxxxxxx
Username : FF|Skyrider
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log

Michael.A

02-18-2009 09:43 PM

when i try to view any user chat i get this

Code:

Database error in vBulletin 3.7.5:



Invalid SQL:



        SELECT COUNT(chatid) AS nbchats

        FROM mgc_cb_evo_chat AS c

        LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)

        LEFT JOIN user AS tou ON (c.touid=tou.userid)

        WHERE coidentifier IN ('0','me','announcement','ban','del','ignore','pm','slap') AND fromuid='3' AND isthreadwarning='0' AND ispostwarning='0'

        ORDER BY c.dateline DESC;



MySQL Error   : Unknown column 'isthreadwarning' in 'where clause'

Error Number  : 1054

Request Date  : Wednesday, February 18th 2009 @ 11:35:04 PM

Error Date    : Wednesday, February 18th 2009 @ 11:35:04 PM

Script        : http://my site.com/forum/mgc_cb_evo.php?do=search&what=userchats&u=3

Referrer      : http://my site.com/forum/forum.php

IP Address    : xxxxxxxxxxxxxxxx

Username      : xxxxxxxxxxxxxxx

Classname     : vB_Database

MySQL Version : 5.0.67-community

how can i fix this?
thank you..

VBDev

02-19-2009 04:30 AM

Quote:

Originally Posted by kronnos (Post 1748150)

Cool, thanks. Will this all be updated in the next mod update release? BTW, any plans for the next update with some error fixes?

Yes sure this will be updated.

Well I am currently updating one of my other non-free mod currently and next is the chatbox update.

I think I'll be releasing a new chatbox version in one or two weeks.

Sorry for this delay but you know I am doing vBulletin during my free time so it takes a bit more time than if I was developping during the whole day.

Quote:

Originally Posted by FF|Skyrider (Post 1748209)

Sorry VBDev, I "approved" once another moderated thread, and got the database error again:

Yeah, I have added this to the bug list already.

Quote:

Originally Posted by MAD--DOG (Post 1748484)

when i try to view any user chat i get this

Code:

Database error in vBulletin 3.7.5:



Invalid SQL:



        SELECT COUNT(chatid) AS nbchats

        FROM mgc_cb_evo_chat AS c

        LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)

        LEFT JOIN user AS tou ON (c.touid=tou.userid)

        WHERE coidentifier IN ('0','me','announcement','ban','del','ignore','pm','slap') AND fromuid='3' AND isthreadwarning='0' AND ispostwarning='0'

        ORDER BY c.dateline DESC;



MySQL Error   : Unknown column 'isthreadwarning' in 'where clause'

Error Number  : 1054

Request Date  : Wednesday, February 18th 2009 @ 11:35:04 PM

Error Date    : Wednesday, February 18th 2009 @ 11:35:04 PM

Script        : http://my site.com/forum/mgc_cb_evo.php?do=search&what=userchats&u=3

Referrer      : http://my site.com/forum/forum.php

IP Address    : xxxxxxxxxxxxxxxx

Username      : xxxxxxxxxxxxxxx

Classname     : vB_Database

MySQL Version : 5.0.67-community

how can i fix this?
thank you..

To fix this, open mgc_cb_evo.php file.

Search for the multiple occurences of :

Code:

$where_clause .= " AND isthreadwarning='0' AND ispostwarning='0'";

Replace it by :

Code:

$where_clause .= " AND iswarning='0'";

All times are GMT. The time now is 11:35 AM.

Page 432 of 880

432

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09581 seconds Memory Usage 1,795KB 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_code_printable (14)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: