I keep getting...

[Daniel.C]

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

[Colin F]

Originally Posted by Daniel.C

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

[Daniel.C]

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

[Modin]

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

$membergroupids = trim($membergroupids);

[Daniel.C]

Add it where exactly ?

[Modin]

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.

[Daniel.C]

Ok i tried it and it didn't work

[Dean C]

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

[Daniel.C]

I have already tried that aswell, thanks for trying though

[Daniel.C]

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.