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)

SnapOff Racing 02-14-2009 08:51 AM

Has the issue with the chats not being aligned in FF 3.0.6 been fixed? Just wondering because I just installed 2.2.1 and my chats are aligned just fine in FF 3.0.6 I'm using vb 3.7.3 so maybe only > 3.8.0 is affected or something???


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?

Other than that everything looks good Thanks VBDev :up:

entertain 02-14-2009 09:01 AM

Quote:

Originally Posted by Bugs
Align usernames and chats not working in latest Firefox version (3.0.6)

Seems to work, when the latest shouts will be displayed at the top of the chatbox.
Otherwise not..

SnapOff Racing 02-14-2009 09:55 AM

Quote:

Originally Posted by entertain (Post 1743683)
Seems to work, when the latest shouts will be displayed at the top of the chatbox.
Otherwise not..

Oh ok I suppose that's why mine is working fine then. Thanks for that input! :up:

kronnos 02-14-2009 10:31 AM

Quote:

Originally Posted by VBDev (Post 1742703)
You can do that by using the "style issue fix" explained in the readme.

Even if you don't have style issue this will let you add it wherever you want.

(

Thank you, I was able to make the changes but then I ran into another problem. Is there anyway to actually edit the chatbox template itself? I noticed where ever i insert the $chatbox_forumhome code, it automatically makes a space after even if there is no <br/> in the template I paste it into. Also, I wanted to add it into a table but it removes the table class for all the other items in that table. So I would want to remove table class close in the chatbox template itself.

So basically, where can I find the full code for what this equalls to = $chatbox_forumhome ?

table class

DigitALL 02-14-2009 04:07 PM

Hello VBDev,

Thank you for looking into this issue. The ChatBox appears to work fine but I would estimate only in about 60% of cases. So here it goes:
- Tested in IE, FF and Safari on Windows and OSX platforms. It seems that it is not related to browsers. I use FF most but in my opinion, the ChatBox should be made to work best in IE. Over 70% of worldwide internet users are using IE.

- I open the forum home in ten pages and in about six of these pages, the ChatBox content will appear fine. In the rest of them (about 40%) the ChatBox would stay at "Loading..." state.

- In some cases when the ChatBox appears correct, when you type something in the ChatBox, the chat would not be displayed.

- I have also noticed that if one browser display I would post a chat, in some cases, on the other pages, that chat would not appear, like it does not refreshes automatically. If I do a browser refresh, it will either display the chat, or it will stay on "Loading...".

- As I wrote before, it seems that it is not stable. From the many tests I've done, it appears that in about 60% cases it will work, and 40% not.
Since I have few skins installed, I have tried this multiple times under different skins.
In one point, I've disabled most of the plugins, leaving the ChatBox to see if there is some kind of conflict with any of the plugins. Unfortunately, it was the same (random display of "Loading").

- Again, when I used to have VB 3.7.3 with ChatBox v.1, everything was working just fine, I was very happy about it. Before upgrading to 3.8.1, I have removed completely the ChatBox and its files and then I've started fresh with v.2.2 and then 2.2.1 and have this problem of "Loading..." being displayed randomly.

- Would be this issue because of the new VB version or due to the new version in ChatBox? I have no clue what to do next and honestly, I would return to version 1, if I would be sure that it will work fine under 3.8.1. Would that be feasible?
You have all the site info, so you are welcome to pop-in anytime. Thank you very much :)

deta 02-14-2009 04:20 PM

Quote:

Originally Posted by deta View Post

Please fix the bug with ibproarcade!!!!

cu Deta

Hey man calm down !!!
I am not a little dog that obey orders.
I have nothing to say some days, perhaps my Users ar very :down: :mad:

cu Deta

Gamempire 02-14-2009 09:17 PM

Quote:

Originally Posted by VBDev (Post 1742099)
Which mod are you using that add mootools ?

a personal mod that add some function to my forum related to my portal of videogames :)

KillerStefan 02-15-2009 11:39 AM

I want to type in bold and with FF9900 as color always on the chatbox but the color isn't avaiable as custom parameter.
Any idea how to do this?

michi123 02-15-2009 01:08 PM

hey

i got a problem @ installing the box! im not able to import the product :(!
Code:

it always says: Die bei der Anfrage ?bermittelten Daten sind f?r die -Methode nicht erlaubt oder die Datenmenge hat das Maximum ?berschritten.
The request for the data transmitted for the method is not allowed or the amount of data has exceeded the maximum.

can sumone help me to solve this problem pls?

DigitALL 02-15-2009 01:12 PM

Hi,

I noticed that on the product page there is a link to the CMPS module. But when you got there, on the module page, it is stated to work only with version 1. Will that module be updated? If not, I see no point to be linked to it.

Skyrider 02-15-2009 03:26 PM

VBDEV, I just updated and wanted to approve a thread that was put in to moderation. When I attempted to do so, I got this error:

Quote:

Invalid SQL:

INSERT INTO mgc_cb_evo_chat
(dateline,fromuid,ctext,sticky,chanid,coidentifier ,iswarning,warningtype,tpforumid)
VALUES
(1234718690,,'73265,Disable vac',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 ''73265,Disable vac',0,0,0,1,'thread',63)' at line 4
Any idea?

Doctor Death 02-15-2009 08:51 PM

1. Is there any simple way to replace the Yahoo CSS so that you can read the error messages?

2. I am having a hard time understanding how to slap or use other "/" enabled keys. can you please provide a text example?

3. Is there an easy way to replace the "Boing" sound with something a little less irritating?

4. I love this mod... it is by far one of the best I have seen. Thanks a million, I will donate soon.

Ranger187 02-15-2009 09:09 PM

DD,

#3 is easy. put the sound you want in place of the boing, and simple rename it to the default sound. ;)

#2, Make sure you enabled the commands. It's like the 1st or 2nd option for MGC in the admin cp

#1, Use Firefox and open the error console.

Doctor Death 02-15-2009 09:28 PM

I have enabled... trying to slap.....

so it would be

/slap Joesmith

or how?

Thanks for the note!

Ranger187 02-15-2009 09:56 PM

Quote:

Command /slapThis command lets you slap another user. To slap another user, you just have to use either the menu available on the left of the message or by using one of the following syntaxes:
  • /slap uid userid : Slap the user whom userid is passed as command parameter.
  • /slap uname username : Slap the user whom username is passed as command parameter.

If you don't see that in the help icon it's not enabled. It should also be available in the drop down list next to each name. And if not, again, it's not enabled, or you didn't set permissions for usergroup. ;)

FRANKTHETANK 2 02-16-2009 12:15 AM

I have two problems. In my chat box, were you type in what you want to say. It's all in a different language. I can't figure out how to change that. Any ideas? And when I slap someone it says The user you are trying to slap doesn't exist

EDIT: I GOT THE SLAP TO WORK BUT AFTER I PUT THE COMMAND IN IT SHOWS EVERYTHING IN A DIFFERENT LANGUAGE

Ranger187 02-16-2009 12:30 AM

Quote:

Originally Posted by FRANKTHETANK 2 (Post 1745445)
I have two problems. In my chat box, were you type in what you want to say. It's all in a different language. I can't figure out how to change that. Any ideas? And when I slap someone it says The user you are trying to slap doesn't exist

EDIT: I GOT THE SLAP TO WORK BUT AFTER I PUT THE COMMAND IN IT SHOWS EVERYTHING IN A DIFFERENT LANGUAGE

Read the install file again. You didn't change the default language, or you didn't change the default prompt. Default prompt is in french. YOU have to change it to whatever you want if you enable it. It's in the MGC settings.....one of those categories........ near bottom.

Same with slap. Search this thread for "translation" or "french" and it should show a post from VBDev and from me with the answers. I'm not searching 260 threads. ;)

FRANKTHETANK 2 02-16-2009 12:40 AM

ok i see what your talking about can you translate these

Displayed when user is limited in number of posts per day
<b>Vous ne pouvez pas envoyer de message car vous avez atteint la limite de chats en 24H de votre groupe d'utilisateurs</b>

/slap command : content of the message
{1} gifle avec violence {2}

Ranger187 02-16-2009 02:11 AM

Quote:

Originally Posted by FRANKTHETANK 2 (Post 1745461)
ok i see what your talking about can you translate these

Displayed when user is limited in number of posts per day
<b>Vous ne pouvez pas envoyer de message car vous avez atteint la limite de chats en 24H de votre groupe d'utilisateurs</b>

/slap command : content of the message
{1} gifle avec violence {2}

Hence my "search for".... I don't speak french. Search forthat gifle.... it shows a thread where vbdev translates all that.

FRANKTHETANK 2 02-16-2009 04:24 AM

na he only translates 3 of the 6 things but i figured it out myself thanks anyways

kronnos 02-16-2009 03:39 PM

Ok, I noticed 2 problems im having so far with the chat.

1. When I post a chat, it goes at the bottom of all the chats eventhough I said it to show newest first. I have to reload the entire page for it to show on top as it should.

2. When clicking the send button or just pressing enter with empty chatbox, it gives some error pop-up message, (Doesnt say anything, just a white pop-up).(Anyway to make it say something or remove it completely)

EDIT:

Ok problem 1 seems to be solved when I removed a sticky post(which didn't really sticky anyway)

Another problem I noticed that it sometimes just shows the refresh animation icon and doesnt refresh to anything.

OblivionMage 02-17-2009 02:01 AM

I changed a setting a while back to hide the chatbox, only now that I want to use it again I cannot seem to edit it back. This effects all of the styles I have (including default), and I have tried a reinstall. Any ideas? (What settings could be disabling the chatbox? I've looked at usergroup permissions, plugin hooks, mgc settings, the suggested template / plugin hook edits, etc...)

VBDev 02-17-2009 04:35 AM

Quote:

Originally Posted by danielbahl (Post 1742814)
Hi VBDev,

Safari-problem still exist:
I just reinstalled your mod. Replaced all files with the new ones. Reimported Language and Product and cleaned my cache (even tried another newly reinstalled Mac).

But the problem is still there. Safari shows ONE old chat-line, as the first line, screenshot:

Attachment 94811

Quote:

Originally Posted by danielbahl (Post 1742826)
After I load the notifications in a separate Query, Safari works again! Hope my tip can help others :)

Hum, that's odd. I'll give it a look then. I am adding this to the bug list.

Quote:

Originally Posted by TNI (Post 1742840)
I found my problem, it was the same as gamespire's, I am using TCattd - The Image Resizer it uses mootools.js and slimbox.js. Once I turned that mod off the chat started working in FF and Safari.

Quote:

Originally Posted by DL_Ashe (Post 1743308)
2 days ago, everything was perfect. Yesterday, the down arrow just vanished. The only singular change on the forums between now and then, was I turned on the "Who's Online" function (so it appears beneath the chatbox), and turned off the use of the "Who's Online" button... at the request of my forum members. Other than that, nothing.

A revert back to the Who's Online button, didn't bring the down arrow for the Actions menu back (tried already).

Well there is no reason why the down arrow wouldn't show or would dissapear magically.

Are you sure they haven't been any other change to your forum since then ?

Quote:

Originally Posted by d0nbiz (Post 1742937)
It was working when I was using the older version of the shoutbox on my 3.8.1 then I upgraded to the newer version for 3.8.x and it stopped working. I configured it all but it just won't show up on the forum now'

Does it appear but keep loading or is it just not shown at all ?

VBDev 02-17-2009 06:07 AM

Quote:

Originally Posted by entertain (Post 1743683)
Seems to work, when the latest shouts will be displayed at the top of the chatbox.
Otherwise not..

Quote:

Originally Posted by SnapOff Racing (Post 1743703)
Oh ok I suppose that's why mine is working fine then. Thanks for that input! :up:

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 ?

Quote:

Originally Posted by kronnos (Post 1743718)
Thank you, I was able to make the changes but then I ran into another problem. Is there anyway to actually edit the chatbox template itself? I noticed where ever i insert the $chatbox_forumhome code, it automatically makes a space after even if there is no <br/> in the template I paste it into. Also, I wanted to add it into a table but it removes the table class for all the other items in that table. So I would want to remove table class close in the chatbox template itself.

So basically, where can I find the full code for what this equalls to = $chatbox_forumhome ?

table class

Not sure as I don't the code behind my eyes but I think the <br /> is in the plugins.

What do you mean in the last part of the post ?

Quote:

Originally Posted by DigitALL (Post 1743969)
- Tested in IE, FF and Safari on Windows and OSX platforms. It seems that it is not related to browsers. I use FF most but in my opinion, the ChatBox should be made to work best in IE. Over 70% of worldwide internet users are using IE.

Well as I am not a PC user I make my best to make it works with IE but it's not handy to use a virtualizer to run windows on the Mac.

Quote:

Originally Posted by DigitALL (Post 1743969)
- I open the forum home in ten pages and in about six of these pages, the ChatBox content will appear fine. In the rest of them (about 40%) the ChatBox would stay at "Loading..." state.

Not sure what you meant by that ?

Quote:

Originally Posted by DigitALL (Post 1743969)
- In some cases when the ChatBox appears correct, when you type something in the ChatBox, the chat would not be displayed.

Well that's strange.

Quote:

Originally Posted by DigitALL (Post 1743969)
- I have also noticed that if one browser display I would post a chat, in some cases, on the other pages, that chat would not appear, like it does not refreshes automatically. If I do a browser refresh, it will either display the chat, or it will stay on "Loading...".

When so were you having issues reported in javascript console ?

Quote:

Originally Posted by DigitALL (Post 1743969)
- As I wrote before, it seems that it is not stable. From the many tests I've done, it appears that in about 60% cases it will work, and 40% not.
Since I have few skins installed, I have tried this multiple times under different skins.
In one point, I've disabled most of the plugins, leaving the ChatBox to see if there is some kind of conflict with any of the plugins. Unfortunately, it was the same (random display of "Loading").

- Again, when I used to have VB 3.7.3 with ChatBox v.1, everything was working just fine, I was very happy about it. Before upgrading to 3.8.1, I have removed completely the ChatBox and its files and then I've started fresh with v.2.2 and then 2.2.1 and have this problem of "Loading..." being displayed randomly.

Do you have zlib installed on your server ?

Because it seems that the 3.8.1 has some bad issues with zlib (we experienced it on forumcoding).

This issues were making the whole ajax functionnalities not working (like quick reply leading to a full post and page refresh instead of only loading of the new chat).

The chatbox is affected by this issue and I thus have to look into it.

Quote:

Originally Posted by DigitALL (Post 1743969)
- Would be this issue because of the new VB version or due to the new version in ChatBox? I have no clue what to do next and honestly, I would return to version 1, if I would be sure that it will work fine under 3.8.1. Would that be feasible?
You have all the site info, so you are welcome to pop-in anytime. Thank you very much :)

I think it might be related to vB version yep.

I will be investigating on it for the next release (release planned for middle of march).

Quote:

Originally Posted by Gamempire (Post 1744234)
a personal mod that add some function to my forum related to my portal of videogames :)

Oh ok. I think the issue is with mootols, which is stranged as yahoo is quite independent. I will look into that.

VBDev 02-17-2009 06:12 AM

Quote:

Originally Posted by KillerStefan (Post 1744761)
I want to type in bold and with FF9900 as color always on the chatbox but the color isn't avaiable as custom parameter.
Any idea how to do this?

You can do that by editing the color array in the functions_mgc_cb_evo.php file :)

Quote:

Originally Posted by michi123 (Post 1744823)
hey

i got a problem @ installing the box! im not able to import the product :(!
Code:

it always says: Die bei der Anfrage ?bermittelten Daten sind f?r die -Methode nicht erlaubt oder die Datenmenge hat das Maximum ?berschritten.
The request for the data transmitted for the method is not allowed or the amount of data has exceeded the maximum.

can sumone help me to solve this problem pls?

Have you try uploading it to your server and then doing a server load of the product instead of local one ?

Quote:

Originally Posted by DigitALL (Post 1744827)
Hi,

I noticed that on the product page there is a link to the CMPS module. But when you got there, on the module page, it is stated to work only with version 1. Will that module be updated? If not, I see no point to be linked to it.

Well I don't know, it's up to stangger5, he's the one that do the link and develop the mode.

You should ask him.

Quote:

Originally Posted by FF|Skyrider (Post 1744948)
VBDEV, I just updated and wanted to approve a thread that was put in to moderation. When I attempted to do so, I got this error:

Any idea?

When approving a thread ??

You should encounter that issue with the counters update of the chatbox but I don't think so for the moderation.

Quote:

Originally Posted by Doctor Death (Post 1745290)
1. Is there any simple way to replace the Yahoo CSS so that you can read the error messages?

You have to redefine yahoo's css parameters. Do you want me to give a link to you on which parameters to redefine ?

VBDev 02-17-2009 06:14 AM

Quote:

Originally Posted by OblivionMage (Post 1746468)
I changed a setting a while back to hide the chatbox, only now that I want to use it again I cannot seem to edit it back. This effects all of the styles I have (including default), and I have tried a reinstall. Any ideas? (What settings could be disabling the chatbox? I've looked at usergroup permissions, plugin hooks, mgc settings, the suggested template / plugin hook edits, etc...)

This bug was present in versions earlier than 2.2.1.

DangerousDale 02-17-2009 01:05 PM

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

$mgc_cb_evo_var
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.

OblivionMage 02-17-2009 07:22 PM

Quote:

Originally Posted by VBDev (Post 1746590)
This bug was present in versions earlier than 2.2.1.

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?

kronnos 02-17-2009 07:28 PM

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

d0nbiz 02-17-2009 08:11 PM

Quote:

Originally Posted by VBDev (Post 1746527)
Does it appear but keep loading or is it just not shown at all ?

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

Quote:

Originally Posted by Ranger187 (Post 1743582)
Usergroup options set?

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

brun0 02-18-2009 10:23 AM

Quote:

Originally Posted by DigitALL (Post 1740415)
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)
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?

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 03:10 PM.

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.08664 seconds
  • Memory Usage 1,950KB
  • 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
  • (12)bbcode_code_printable
  • (48)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
  • (40)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