| Author |
Topic |
|
anotrax
Starting Member
2 Posts |
 Posted - 2010-08-16 : 13:42:15
|
| Hello , iv got a problem with a game making,If i start the final server it gives this fatal error: Coult not execute query: you have an error in your SQL syntax: check the manual that corresponds to your MySQL serer version for the right suntax to use near `range,target,power,duration,mp,success, weapon,class,rskills,lskills,buff1,buffv`at line 1...I dont really get the problem here i have reinterd the SQL document en i edited some but still getting the same problem.. hope you can maybe help me here. |
|
|
anotrax
Starting Member
2 Posts |
Posted - 2010-08-16 : 13:51:58
|
| This is the problem peace i think maybe iv done something wrong take a look>CREATE TABLE `skills_data` ( `id` int(11) NOT NULL default '0', `level` int(11) NOT NULL, `sp` int(11) NOT NULL, `type` int(11) NOT NULL, `range` int(11) NOT NULL, `target` int(11) NOT NULL, `power` int(11) NOT NULL, `duration` int(11) NOT NULL, `mp` int(11) NOT NULL, `success` int(11) NOT NULL, `weapon` varchar(200) NOT NULL, `class` varchar(200) NOT NULL, `rskills` varchar(200) NOT NULL, `lskills` varchar(200) NOT NULL, `buff1` int(11) NOT NULL, `buffv11` int(11) NOT NULL, `buffv12` int(11) NOT NULL, `buff2` int(11) NOT NULL, `buffv21` int(11) NOT NULL, `buffv22` int(11) NOT NULL, `buff3` int(11) NOT NULL, `buffv31` int(11) NOT NULL, `buffv32` int(11) NOT NULL, `clevel` int(11) NOT NULL, `aoe` tinyint(1) NOT NULL, `aoeradius` int(11) NOT NULL, `script` int(11) NOT NULL default '0', `value1` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-16 : 14:14:06
|
| This is an MS SQL Server forum.Might try a mySQL forum -- http://forums.mysql.com/ |
|
|
|
|
|
|
Syntax error/Fatal error