eggz
06-28-2003, 08:51 AM
Hiya all,
After upgrading to vB 2.3.0, I have been going through adding in all the hacks over agin. Most of them were successful, however the Country Flag Hack is giving me SQL errors now when anyone tries to update their profile.
The error it gives is this:
Database error in vBulletin 2.3.0:
Invalid SQL: UPDATE user SET birthday='1987-12-5',signature='Pyrix The Big Design Company (http://www.thebigdesigncompany.net)',customtitle='1',user title='Dreaming In Digital',email='censored@nospamhere.org',parentema il='',coppauser='0',homepage='http://www.thebigdesigncompany.net',icq='165393545',aim=' ',yahoo='',usergroupid='6,country='' WHERE userid='3'
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 '3'' at line 1
mysql error number: 1064
I have read the thread in Support regarding error 1064, but to be honest don't quite get it. I would ask in the hack thread, but I'm guessing that it's a change in vB's database structure as it worked in 2.2.9?
Anyway, thanks in advance
Ollie
After upgrading to vB 2.3.0, I have been going through adding in all the hacks over agin. Most of them were successful, however the Country Flag Hack is giving me SQL errors now when anyone tries to update their profile.
The error it gives is this:
Database error in vBulletin 2.3.0:
Invalid SQL: UPDATE user SET birthday='1987-12-5',signature='Pyrix The Big Design Company (http://www.thebigdesigncompany.net)',customtitle='1',user title='Dreaming In Digital',email='censored@nospamhere.org',parentema il='',coppauser='0',homepage='http://www.thebigdesigncompany.net',icq='165393545',aim=' ',yahoo='',usergroupid='6,country='' WHERE userid='3'
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 '3'' at line 1
mysql error number: 1064
I have read the thread in Support regarding error 1064, but to be honest don't quite get it. I would ask in the hack thread, but I'm guessing that it's a change in vB's database structure as it worked in 2.2.9?
Anyway, thanks in advance
Ollie