PDA

View Full Version : Quick fix coding error


eNtitY~
07-26-2006, 02:07 PM
Well since my primary coder is out of town on vacation I'm wondering if you guys could fix this? I run a League on my site and when I try to end the season I get this error? Any way to fix this? What does it mean?

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO league_season_standings
(position, seasonid, teamid, teamname, rating, wins, losses,
bw_position, bw_rating, bw_wins, bw_losses)
VALUES (
30,
2,
,
'Team Usa-',
1065,
19,
34,
159,
990,
0,
1
);

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 '
'Team Usa-',
1065,
19,
34,
159,
990,
0,
' at line 7
Error Number : 1064
Date : Wednesday, July 26th 2006 @ 09:03:49 AM
Script : http://clanlare.com/vBulletin/upload/league.php
Referrer : http://clanlare.com/vBulletin/upload/league.php?do=endseason
IP Address : 65.31.72.119
Username : eNtitY~
Classname : vb_database

Princeton
07-26-2006, 08:09 PM
there's no value set for the field 'teamid'