The database schema is broken

Bug #1421356 reported by Fabio Buda
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
postfix-cluebringer (Ubuntu)
New
Undecided
Unassigned

Bug Description

When you try to import the database schema located at /usr/share/doc/postfix-cluebringer/database/policyd-db.mysql the mysql client returns:

ERROR 1064 (42000) at line 13: 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

The issue is documented in http://permalink.gmane.org/gmane.mail.postfix.policyd/2140 and the solution is to replace the TYPE keyword with ENGINE.

Tags: patch
Revision history for this message
SBroker (hostmaster-l) wrote :

TYPE= was replaced by ENGINE= in MySQL 5.5+

Revision history for this message
Ubuntu Foundations Team Bug Bot (crichton) wrote :

The attachment "cluebringer.schema.patch.bz2" seems to be a patch. If it isn't, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are a member of the ~ubuntu-reviewers, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issues please contact him.]

tags: added: patch
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.