Database error in vBulletin 3.0.3:

[Daniel.C]

Database error in vBulletin 3.0.3:
Invalid SQL: SELECT title, usergroupid FROM vb3_usergroup WHERE usergroupid IN (6,,) ORDER BY title
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 ') ORDER BY title' at line 1
mysql error number: 1064
Date: Saturday 20th of November 2004 07:06:30 AM
Script: (site url)
Referer:
Username: Sparky

Any Ideas how to correct this error ? I have been having problems with it for a little while now.

[Dean C]

Which file are you getting this error in. Also what modifications have you installed recently? I can see your error.

[Daniel.C]

well i get this error whenever i try to edit an admin profile, buti havn't installed anything recently, the onlys mods i have used are the arcade and the IRC chat thingy.

I also get this error everytime i try and very the "whos one line page" logged in as an admin.


Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.ca lendarid,calendar.title, displayorder
FROM vb3_calendar AS calendar
LEFT JOIN vb3_calendarpermission AS calendarpermission ON (calendarpermission.calendarid=calendar.calendarid AND usergroupid IN(, 6))
ORDER BY displayorder ASC

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 ' 6))
ORDER BY displayorder ASC' at line 3
mysql error number: 1064
Date: Saturday 20th of November 2004 07:21:12 AM
Script: http://www.infinitiveintentions.com/forums/online.php?
Referer:
Username: Sparky

[Logikos]

Seems you installed a hack incorrecly, upload a fresh copy of the vB files in which you get the errors, then if any hacks you installed need to be changed on those files, then go ahead and change them again.

[Daniel.C]

ummm to be honest im not sure what files to reload, which ones do i need to re upload ?

[Zachery]

Originally Posted by Daniel.C

ummm to be honest im not sure what files to reload, which ones do i need to re upload ?

well all of them would be a very good starting point

[Daniel.C]

Ok well i re uploaded all the files but it hasn't solved the problem i'm affraid. Any other suggestions ?

[Zachery]

Originally Posted by Daniel.C

Ok well i re uploaded all the files but it hasn't solved the problem i'm affraid. Any other suggestions ?

You reuploaded all the default files from the vB Zip?

[Daniel.C]

Yeah i downloaded a the file again uploaded all the files and i still have the error. i don't know what to next.

[Daniel.C]

Ok i re uploaded all the files and i still get the error anyone have any ideas ?