Movable Type Knowledge Base: Syntax Error with Database Conversion Script

Question

When trying to use the 3.2 mt-db2sql.cgi script, I get an 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 '1' at line 1 at mt-db2sql.cgi line 62.

Answer

Download this replacement file and save it with a .cgi extension. Upload to your server in ASCII mode and then load it in your browser to try the conversion again.

NOTE: You will probably need to drop any tables created in your SQL database from prior conversion attempts before trying to run the new script.

Submit Feedback on This Article

Your comments on how we can improve this article are appreciated; but please do not use the feedback form to submit support requests or questions. We will not respond to or publish such queries submitted through this form. If you have a technical question or problem, visit Movable Type Support.

Name:

Email Address:

URL:

Remember personal info?

Comments: (you may use HTML tags for style)

Comments will be moderated and may appear on this page or be incorporated into future versions of this document. For full details, see our Terms of Service.