Log in

View Full Version : MySQL error 1064 for calendar and usergroups.


GinjiAmano
09-28-2004, 08:55 AM
Ok, when i try to see the forum home page i get this error:
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: Tuesday 28th of September 2004 11:36:12 AM
Script: http://www.otakuforum.it/index.php?
Referer:
Username: Dante
IP Address: XX.XXX.XXX.XXX
This after i edited my amount of cash from the admin cp with the mod ucash-ushop.
Also, when i try to edit my profile from the admin cp the page loads only for half, leaving this message:
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: Tuesday 28th of September 2004 11:51:19 AM
Script: http://www.otakuforum.it/admincp/user.php?do=edit&userid=1
Referer:
Username: Dante
IP Address: XX.XXX.XXX.XXX
I've found a similar thread ont he forum ( https://vborg.vbsupport.ru/showthread.php?p=530289#post530289 ) but i cannot get what is the file that run.exe has edited for making it work.
Please help...

GinjiAmano
09-28-2004, 05:11 PM
Any help?

Modin
09-28-2004, 11:33 PM
looks like you've corrupted something in your usergroups.

What hacks have you installed?

GinjiAmano
09-29-2004, 04:47 AM
ucash-ushop, the error begun after i've edited my points count from the admin cp.