Uploaded image for project: 'Website'
  1. Website
  2. WEBSITE-704

mysql_upgrader.php script broken (uses wrong version schema)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Knowledge base
    • None

      http://www.phpbb.com/kb/article/doesnt-have-a-default-value-errors/

      The mysql_upgrader.php script listed for 3.0.2 on that page under the "Fit It" section appears to actually be for 3.0.3RC1 and thus doesn't work for 3.0.2 installs and throws an error about the group_max_recipients column.

      Link to the script (listed as "For 3.0.2 mysql_upgrader.php"):
      http://code.phpbb.com/repositories/entry/5/branches/phpBB-3_0_0/phpBB/develop/mysql_upgrader.php?format=raw

      Code from SVN that leads me to that conclusion:

         // Changes from 3.0.2 to 3.0.3-RC1
         '3.0.2'         => array(
            // Add the following columns
            'add_columns'      => array(
               STYLES_TEMPLATE_TABLE         => array(
                  'template_inherits_id'      => array('UINT:4', 0),
                  'template_inherit_path'      => array('VCHAR', ''),
               ),
               GROUPS_TABLE               => array(
                  'group_max_recipients'      => array('UINT', 0),

            karlsemple karlsemple [X] (Inactive)
            phreadom Justin Stressman [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: