Had a few problems with my database and was very bloated after couple of years of hacks, so for the 3.5 upgrade imported the data into a fresh 3.9 install using impex then upgraded to 3.5. Everything went nice and smooth apart from usergroups. People can apply ok, but when a usergroup leader goes to authorise them gets this error
The user who applied gets added to the usergroup but still shows up in view requests, any ideas?
Database error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
DELETE FROM usergrouprequest
WHERE usergrouprequestid IN();
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 2
Error Number : 1064
Date : Sunday, September 18th 2005 @ 11:10:49 AM
Script : http://www.f4g.net/vb/joinrequests.php
Referrer : http://www.f4g.net/vb/joinrequests.php?usergroupid=65
IP Address : ***.***.***.***
Username : Marty
Classname : vb_database
Invalid SQL:
DELETE FROM usergrouprequest
WHERE usergrouprequestid IN();
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 2
Error Number : 1064
Date : Sunday, September 18th 2005 @ 11:10:49 AM
Script : http://www.f4g.net/vb/joinrequests.php
Referrer : http://www.f4g.net/vb/joinrequests.php?usergroupid=65
IP Address : ***.***.***.***
Username : Marty
Classname : vb_database
Comment