I keep getting...
 

I keep getting this error and it's not allowing us to see the site anymore.

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: Monday 26th of July 2004 09:41:22 AM
Script: http://www.infinitiveintentions.com/forums/index.php?
Referer:
Username: Sparky



Any help would be aprechiated

I don't get such an error when I visit your site.

The problem is the missing variables in the (, , 6)

Did you change anything in your functions.php? If so, try uploading the default functions.php again (unless you made tons of changes :)), that might help...

I have already tried that and it didn't work. :cry:

the variable is that has a part missing is $membergroupids, when it's imploded it's creating a blank field.

have you added yourself to a usergroup and then deleted it? or something similar?

try adding this just before that query in functions.php

Add it where exactly ?

open up functions.php and do a search for

"SELECT calendarpermission"

That should find that query that's give you an error, then add that code above it. Not 100% if it'll fix your problem or not, since it's difficult to say what's in that variable.

Ok i tried it and it didn't work

Well seems as one value is present i'd say somewhere along the line you've done something with a modification (or it could even be a bug) and the entry in the database has gone blank. Try rebuilding your statistics and all that other stuff in the maintenance area :)

I have already tried that aswell, thanks for trying though

Anyone else have any Ideas ? I have found out that it is only the admins that can't see the board but they can see the admin cp for some reason.

Ok well it only happens know when i try to see who is online. Any ideas how to stop this ?