Quote:
Originally Posted by gyankow
After install I recived the below error trying to use and update teams!
Invalid SQL:
UPDATE league_stats SET teamid = WHERE userid='4';
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 'WHERE userid='4'' at line 1
Error Number : 1064
Date : Wednesday, October 12th 2005 @ 10:34:43 AM
Script : http://www.vbli.com/forums/league.ph...msignupconfirm
Referrer : http://www.vbli.com/forums/league.php?do=teamsignup
IP Address : xxxxxxxxxxxxxxxxxx
Username : VBLIStaff
Classname : vb_database
and a phrase was missing!
See attached, I love the idea but no good here!
|
If you had looked at some other posts you would know that the phrases are not working as i have said so many times.
As to this UPDATE league_stats SET teamid = WHERE userid='4';
it looks like you have not put a team id number in as set teamid = ??
if you dont put a number in it will not update.
There is alot of sites that have installed this now with out a problem so you must have downloaded one of the older versions or you have installed it wrong some how