[SnaKe |WiH|]

I've been working on this for several hours now trying to figure out why I get the following error. I've looked up the error code 1064 and there was some reference to 'order' as a reserved word in some versions of MySQL but I dont think 'rankorder' would cause that problem. Plus more ppl would be having the problem.
I've gone over my php code changes several times in ranks and functions_ranks to make sure it's right.

Can anyone see what the problem might be? I saw some reference to the CHARSET setting but I tried different settings with no help. It's not real intuitive considering my db tables appear to default to MyISAM DEFAULT latin1_swedish_ci. Not sure why it would be swedish. I'm in the US. I digress, I'm not trying to get a MySQL lesson, just sayin.
Thanks for any help.

The rankorder column shows up just fine in admincp. I get this error when I try to change the rankorder on a badge.
Here's the error:

Database error in vBulletin 3.7.6:

Invalid SQL:

UPDATE ranks
SET ranklevel = 1,
minposts = 10,
rankimg = 'images/ranks/moderator.png',
usergroupid = 7,
type = 0,
stack = 1,
display = 0
rankorder = 1
WHERE rankid = 7;

MySQL Error : 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 'rankorder = 1
WHERE rankid = 7' at line 9
Error Number : 1064
Request Date : Wednesday, July 15th 2009 @ 08:26:54 PM
Error Date : Wednesday, July 15th 2009 @ 08:26:54 PM
Script : http://www.warishellgaming.com/forum...hp?do=doupdate
Referrer : http://www.warishellgaming.com/forum...=edit&rankid=7
IP Address : 76.X.X.X
Username : SnaKe
Classname : vB_Database
MySQL Version : 5.1.30