Issue status update for http://drupal.org/node/17116 Project: Drupal Version: 4.5.0 Component: database system Category: bug reports Priority: normal -Assigned to: Anonymous +Assigned to: Morbus Iff Reported by: Anonymous Updated by: Morbus Iff -Status: active +Status: patch Attachment: http://drupal.org/files/issues/01_dbtweak.patch (14.83 KB) I could not replicate the error in HEAD with MySQL 4.0.15: the database.mysql imported just fine, and the primary key was set properly for the format column. With that said, this particular line does not follow the format of any of the other PRIMARY KEYs in the MySQL file, and thus, attached is a patch to standardize the format PRIMARY KEYs are defined, as well as whitespacing. Same goes for the pgsql file. Morbus Iff Previous comments: ------------------------------------------------------------------------ February 9, 2005 - 23:31 : Anonymous I just downloaded Drupal 4.5.2 and in the database.mysql file, there was an error in one of the SQL statements. In the CREATE TABLE filter_formats statement (lines 243-249), the error is on line 248. That line reads, PRIMARY KEY format (format) If should read, PRIMARY KEY (format) ------------------------------------------------------------------------ February 10, 2005 - 10:24 : Jiminator Attachment: http://drupal.org/files/issues/database.mysql (19.66 KB) I posted this, but didn't have a log in at the time. I'm attaching the corrected file. Jiminator. ------------------------------------------------------------------------ February 20, 2005 - 11:54 : Jeremy@kerneltrap.org This bug was mis-advertantly assigned to the dba module. It's regarding the core mysql database file. Reassigning.