Quote:
Originally Posted by Derision
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. |
Thanksn Derision!!
Ok now with the 5.xx version of MySQL the items are showing up, also server is not "Locked" and it seems to be running much more smoothly.
Would a Linux server run with less problems, and allow people to zone faster etc?