server locked issue

[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.

[blackjack1]

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?