{"id":2117,"date":"2020-06-09T02:35:21","date_gmt":"2020-06-08T18:35:21","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=2117"},"modified":"2026-03-17T15:38:05","modified_gmt":"2026-03-17T07:38:05","slug":"mysql-syntax-error-fix","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/mysql-syntax-error-fix","title":{"rendered":"Quick Fix: MySQL Syntax Error When Installing Older Applications"},"content":{"rendered":"<p dir=\"ltr\"><a href=\"https:\/\/www.mysql.com\/\" rel=\"nofollow noopener\" target=\"_blank\">MySQL<\/a>\u00a0syntax error when installing older application.<\/p>\n<p dir=\"ltr\">If you receive below error when you install older application, Example:<\/p>\n<p dir=\"ltr\"><b>\u201cFailed to create faq table: 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 \u201cType=MyISAM\u201d at line 9\u2033<\/b><\/p>\n<p dir=\"ltr\">Kindly open the file, example: install.php and change the syntax from \u201c<b>Type<\/b>=MyISAM to\u00a0<b>Engine<\/b>=MyISAM\u201d.<\/p>\n<p dir=\"ltr\">If you need to know how to backup Mysql Database using PHPMyAdmin, please<a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/backup-mysql-database-using-phpmyadmin\"> refer this article<\/a>.<\/p>\n<h1 class=\"mkb-page-title\"><\/h1>\n<p dir=\"ltr\">\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u00a0syntax error when installing older application. If you receive below error when you install older application, Example: \u201cFailed to create faq table: 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 \u201cType=MyISAM\u201d at line 9\u2033 Kindly open the file, example: install.php and change the&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[51],"kbtag":[1215],"class_list":["post-2117","kb","type-kb","status-publish","hentry","kbtopic-mysql","kbtag-mysql"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=2117"}],"version-history":[{"count":6,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2117\/revisions"}],"predecessor-version":[{"id":6378,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2117\/revisions\/6378"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=2117"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2117"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}