View Single Post
  #1 (permalink)  
Old Nov 24th, 2007, 10:04
Andrew1986 Andrew1986 is offline
Up'n'Coming Member
Join Date: Jul 2007
Location: Barry
Age: 22
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
[SOLVED] error in SQL syntax but where it all looks fine to me

insert into skills (Account, Name, Alchemy, Blacksmithing, Bowcraft, Carpentry, Cooking, Fishing, Healing, Herding, Lockpicking, Lumberjacking, Magery, Meditation, Mining, Musicianship, Removetrap, MagicResistance, Snooping, Stealing, Stealth, Tailoring, Tinkering, Veterinary, Str, Dex, Int, Level, Exp) VALUES ('<account>', '<NAME>', '<Alchemy>', '<Blacksmithing>', '<Bowcraft>', '<Carpentry>', '<Cooking>', '<Fishing>', '<Healing>', '<Herding>', '<Lockpicking>', '<Lumberjacking>', '<Magery>', '<Meditation>', '<Mining>', '<Musicianship>', '<Removetrap>', '<MagicResistance>', '<Snooping>', '<Stealing>', '<Stealth>', '<Tailoring>', '<Tinkering>', '<Veterinary>', '<str>', '<dex>', '<int>', '<eval <tag0.Level>>', '<eval <tag0.tix>>');"


ERROR:MySQL query "insert into skills (Account, Name, Alchemy, Blacksmithing, Bowcraft, Carpentry, Cooking, Fishing, Healing, Herding, Lockpicking, Lumberjacking, Magery, Meditation, Mining, Musicianship, Removetrap, MagicResistance, Snooping, Stealing, Stealth, Tailoring, Tinkering, Veterinary, Str, Dex, Int, Level, Exp) VALUES ('drewwales', 'Anderson', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.7', '30.0', '30.0', '0.0', '400.0', '400.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '400', '200', '100', '89', '9');" failed due to "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 'Int, Level, Exp) VALUES ('drewwales', 'Anderson', '30.0', '30.0', '30.0', '30.0'' at line 1"

where is the error it all looks fine to me
Reply With Quote