On 07/06/11 07:44, Robby Pedrica wrote: > I'm setting up a new v2 box and decided to use mysql 5.5 but once the > convert script is run to generate policyd.mysql ( in ~/database ), I > get an error when creating the db tables: > > mysql -p policydv2 < ./policyd.mysql > Enter password: > ERROR 1064 (42000) at line 30: 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=InnoDB CHARACTER SET latin1 COLLATE > latin1_bin' at line 12 > > I assumed it was something to do with the table creation so had a > check in the mysql 5.5 docs and it appears that TYPE= has been > replaced with ENGINE= > > I'm not great at generating diffs but it should be straightforward to > patch this fix into convert-tsql ... I've done convert-tsql manually > and policyd.mysql is now generated correctly for mysql 5.5.
fixed in git, thanks
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
