Forums

I get the following error from RC 5.5:

Error while creating 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 ') ENGINE = MYISAM' at line 1 SQL=CREATE TABLE `jos_chronoforms_PreviousStudents` () ENGINE = MYISAM ;

RC 5.0 on the exact same system created tables without a problem.

Please let me know if you need any other information.

Thanks,
D.

Had to change the new form parameter MYSQL Statement Engine or Type? from "ENGINE" to "TYPE"

Would be cool if the original error message (in this thread) had that suggestion embedded in it!

Thanks,
D.

Hi aef03,

I just posted a reply to this - seems to have got lost in transmission.

The error message is from MySQL and you probably have on old version if you are seeing the message.

Bob

OK. For reference my MySQL Version is: 5.0.22

Thanks,
D.

Hi D,
It looks like you did not select any fields at all for your table (the UI in 5.5 can be somewhat confusing, but basically, a red bar means it's disabled and a green one enabled - despite the icons suggesting the other way round).

/Fredrik

Yes it is confusing. See the attached screenshot for how to enable all. It's confusing because the x makes it look like it's disabled, but what it really means is if you click the x it will disable it and if you click the check mark it will enable it. I would recommend changing it to the opposite on the next upgrade.