Solved [Solved] sql error for usermanager on MySQL 6.0

[johnblue]

Something got jacked with my last post .. so here it is again.



I followed the install instructions for the pureFTP usermanager port from here:

http://machiel.generaal.net/index.php?subject=pureftpd&language=eng#subject_2

This step:

mysql -u root -psecret < script.mysql

generates this error message:

ERROR 1064 (42000) at line 39: 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 ') TYPE=MyISAM' at line 5

The offending line of code in script.mysql is:

) TYPE=MyISAM;

Asking google about the error returned:

http://bugs.mysql.com/bug.php?id=17501

Asking google about solutions returned, amongst other things:

http://dev.mysql.com/doc/refman/6.0/en/example-auto-increment.html

Not really knowing if that is a solution, my question is, does anyone know a hack that work?

Thanks!

 

[SirDice]

Show the full table create line please, the problem may be elsewhere.

 

[Morty]

I'm use this two files
ftp://ftp.lissyara.su/users/morty/pftpcfg/db.sql
ftp://ftp.lissyara.su/users/morty/pftpcfg/script.mysql
instead original

 

[SirDice]

Those scripts have ENGINE=MyISAM instead of TYPE=MyISAM. ENGINE= is correct, TYPE= isn't.

 

[johnblue]

Those scripts have ENGINE=MyISAM instead of TYPE=MyISAM. ENGINE= is correct, TYPE= isn't.

I was working both ends to the center on this one and Machiel Mastenbroek suggested the same change from TYPE to ENGINE.



I made the change to the script and it generated one last error when I reran it:

ERROR 1064 (42000) at line 15: 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 '-------------------------------------------------------

I placed a space between the second and third dash and after that it completed without errors.