SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Syntax error/Fatal error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

anotrax
Starting Member

Netherlands
2 Posts

Posted - 08/16/2010 :  13:42:15  Show Profile  Reply with Quote
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

Netherlands
2 Posts

Posted - 08/16/2010 :  13:51:58  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 08/16/2010 :  14:14:06  Show Profile  Visit russell's Homepage  Reply with Quote
This is an MS SQL Server forum.

Might try a mySQL forum -- http://forums.mysql.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000