[Fixed] MySQL syntax error for version before 4.0

jtp10181 · **Author**

I noticed today when putting SH mysql on for someone using mysql-3.23.58 that I got this error

Code:

L 08/27/2005 - 10:58:13: [superheromodmysql.amxx] DEBUG: Couldn't Clean XP: 'You have an error in your SQL syntax near 'sh_saveskills` FROM `sh_saveskills`, `sh_savexp` WHERE sh_savexp.`SH_KEY` = sh_s' at' - 'DELETE `sh_saveskills` FROM `sh_saveskills`, `sh_savexp` WHERE sh_savexp.`SH_KEY` = sh_saveskill

did some looking and found out I cant do that in mysql 3.x

This mysql version is commonly used on redhat distributions because they trust it works good and dont like to do massive upgrades.

I will make a define switch that uses proper syntax for the old mysql and I guess we will have 1.18e

jtp10181 · 08-27-2005 , 22:28

OK I fixed it and decided to just keep it 1.18d since it was just a minor include change. If you are getting that error at all you NEED 1.18d and you need to recompile it with the define commented out (see the sh mysql include)