GOSatisfy
07-03-2002, 07:53 PM
I moved my vB installation from one server to another. Everything is working fine except, a few dozen of the newer users are on everyone's ignore list. I checked the database and they are not listed in the individual user table... any ideas on how to correct this? (They are not listed in the user cp either)
also, some users get the error:
Database error in vBulletin 2.2.5:
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Wednesday 03rd of July 2002 04:56:42 PM
Script: http://dev.campkr.com/boards/
Referer: http://dev.campkr.com/campkr.php?content=main.htm
If i upgrade to 2.2.6 will it alter the mysql database in such a way that it will fix it or will the errors carry over?
-bryan :bandit:
also, some users get the error:
Database error in vBulletin 2.2.5:
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Wednesday 03rd of July 2002 04:56:42 PM
Script: http://dev.campkr.com/boards/
Referer: http://dev.campkr.com/campkr.php?content=main.htm
If i upgrade to 2.2.6 will it alter the mysql database in such a way that it will fix it or will the errors carry over?
-bryan :bandit: