MySQL Errors

[pgowder]

Not sure if this is the right thread--moderators please move if needed!

Several times a week I see my load spike for a few minutes and I get a flood of vBulletin error messages in my email. And by a flood, I mean 100-200 at a time. vBulletin generates 1 for everytime someone sees the error page, so I'm not sure if all of my users are seeing this, or if a bot is crawling a bad page???

Here is what they look like:

Database error in vBulletin 2.2.8:

Invalid SQL: Select styleid, styleoverride from usergroup where usergroupid=
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

mysql error number: 1064

Date: Tuesday 24th of February 2004 03:08:11 PM
Script: http://www.powwows.com/gathering/gathering/forumdisplay.php?s=&forumid=34
Referer: http://www.powwows.com/gathering/showthread.php?s=&postid=363631


Database error in vBulletin 2.2.8:

Invalid SQL: Select styleid, styleoverride from usergroup where usergroupid=
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

mysql error number: 1064

Date: Tuesday 24th of February 2004 03:07:45 PM
Script: http://www.powwows.com/gathering/gathering/attachment.php?postid=88010
Referer: http://www.powwows.com/gathering/showthread.php?threadid=6442&perpage=20&pagenumber=2


What could be causing these?? Anyone ever seen this??

Help!!!

[Xenon]

where usergroupid=

there is an ID missing.

you may have installed a hack incorrectly.

[pgowder]

What files should I start looking in?

[pgowder]

I did a search through my vBulletin files and here are the results I found where there is code for usergroupid=.

Do any of these look wrong?

[pgowder]

Here are two other shots of where I found the code.

[Xenon]

well it's a hack which seems to produce this, so upload unhacked files to avoid the error

[pgowder]

Ok, that sounds easy, but what file? I have multiple hacks installed. I can't just upload all new files--that would cause tones of errors in my templates.

So can anyone help me figure out which file it could be?

[Xenon]

as it shows up very often, it seems to be a glitch in global.php, also the fact, that different caller files are mentioned.

try to upload an unchanged global.php :)

btw. you should really upgrade to the newest vb2 version, as 228 has some problems

[pgowder]

Thanks, I'll try that.

[pgowder]

I just noticed something strange about these errors.

They point to files at /gathering/gathering/showthre....

My forum is /gathering/showthread.php

Where and why would it be getting the /gathering/gathering

[pgowder]

as it shows up very often, it seems to be a glitch in global.php, also the fact, that different caller files are mentioned.

try to upload an unchanged global.php :)

btw. you should really upgrade to the newest vb2 version, as 228 has some problems

I did a comparison of a clean global and my global. The only difference is a hack to force style by usergroup. Which is something I really need.

Here's the hack:

https://vborg.vbsupport.ru/showthread.php?t=32857&page=1&pp=15

Can anyone help me figure this out?

[pgowder]

Anyone have any ideas?

[Xenon]

you may ask in the hack thread for support

[pgowder]

I did, no response.