Posts: 1
Threads: 1
Joined: Jan 2011
Reputation:
0
I am getting this error while installation
3) Create Database Tables
The following error occurred:
• 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 DEFAULT CHARSET=utf8' at line 6
Posts: 1
Threads: 0
Joined: May 2011
Reputation:
0
Same problem.
Fedora Core 14
MySQL 5.5.11
PHP 5.3.6
Here are some quick fixes from the Unix command line:
From formtools top directory
1) Determine if you have the problem:
find . -type f -exec grep -Hi type=myisam {} \;
(no results == no problem)
2) Fix the problem:
find . -type f -name '*.php' -exec perl -pi.bak -e 's/TYPE=MyISAM/ENGINE=MyISAM/gi;' {} \;
3) Delete the backup files after fixing:
find . -type f -name '*.bak' -exec /bin/rm {} \;
(then run 1 again)
--Dave
Posts: 2,456
Threads: 39
Joined: Dec 2008
Reputation:
6
Hey Dave,
Thanks for posting this. Huh! Originally, I had it set as ENGINE=MyISAM but that threw errors on some system, so I changed it to TYPE=MyISAM. Reading up on it now, however, I gather that ENGINE is newer and TYPE is deprecated. I'll keep looking around, but I would imagine there's a way I can detect to see which one's supported on each system. If so, I'll get this fix into 2.1.0.
Thanks!
- Ben