View Single Post
  #7  
Old 01-09-2008, 09:47 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

The error you are getting is:

1064: You have an error in your SQL syntax .... near 'range,damage,color, ...

I'm going to to take a guess you are using MySQL version 5.1 ?

I did a search for MySQL reserved words, and it would appear that 'range' became
a reserved word in version 5.1.

If you look at the 5.0 list, RANGE is not listed:

http://dev.mysql.com/doc/mysqld-vers...words-5-0.html

But it is in the 5.1 list:

http://dev.mysql.com/doc/mysqld-vers...words-5-1.html

If possible, you could try downgrading to MySQL 5.0 and see if that makes your problem disappear.
Reply With Quote