I get an error message when trying to create the table using phpmyadmin....

MySQL said: Documentation
#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12

Comments

Anonymous’s picture

(not verified) commented

According to http://dev.mysql.com/doc/mysql/en/create-table.html that line should read "ENGINE=MyISAM DEFAULT CHARACTER SET latin1" instead of "... DEFAULT CHARSET=latin1" (MySQL4)

Patrick

freyquency’s picture

freyquency commented

I'm using 4.5.2.

I receive the same error, though it states it is on line 11. I tried altering it as recommended to no avail. After doing a google search for that line of mysql code I found a few different variations of the line. The only thing I got to work was trimming it to ) type=myisam; . This didn't give an error message but the module didn't work.

The module did not have any configuration settings, yet did have the checkboxes in the workflow settings.

Patrick,
You didn't mention if you got the module working correctly with the code you supplied. If you did could you post it within the code brackets?

pbull’s picture

pbull commented
Assigned: Unassigned » pbull

Fixed the SQL in 4.5.x and CVS to use TYPE=MyISAM.

Anonymous’s picture

(not verified) commented