#619 initializing doesn't work with provided schema

Database
closed
Reini Urban
MySQL (31)
5
2012-10-11
2009-04-14
Anonymous
No

iMac:schemas tristan$ /usr/local/mysql/bin/mysql -uroot -ppassword phpwiki < mysql-initialize.sql
ERROR 1064 (42000) at line 110: 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 '(14) NOT NULL,
PRIMARY KEY (dimension, raterpage, rateepage)
)' at line 7

this is the output from attempting to use schema. phpwiki is half broken after this.

Discussion

  • Reini Urban
    Reini Urban
    2009-09-15

    You seem to have a newer mysql => 5.1

    Change
    tstamp TIMESTAMP(14) NOT NULL,
    to
    tstamp TIMESTAMP DEFAULT 0,

     
  • Reini Urban
    Reini Urban
    2010-06-07

    Fixed with r7117 2009-09-15 08:02:20Z rurban

     
  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).