Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Syntax error/Fatal error

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;
Go to Top of Page

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/
Go to Top of Page
   

- Advertisement -