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/gat...?s=&forumid=34
Referer: http://www.powwows.com/gathering/sho...&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/gat...p?postid=88010
Referer: http://www.powwows.com/gathering/sho...0&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