Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-8944

Error on database update (must specify size of index on MySQL4)

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.6
    • Fix Version/s: 3.0.8-RC1
    • Component/s: Update system
    • Labels:
      None
    • Environment:
      PHP Environment: 4.4.9
      Database: MySQL 4.0.27-log

      Description

      At database updating (database_update.php) the the phpbb 3.0.4 -> 3.0.6, get the follow error:

      Error :: BLOB column 'post_username' used in key specification without a key length
      SQL :: CREATE INDEX post_username ON phpbb_posts(post_username)

      For MySQL 4.0 the SQL query must be like this:

      CREATE INDEX post_username ON phpbb_posts(post_username(255))

      i.e. with key length.

        Activity

        Hide
        igorw Igor Wiedler [X] (Inactive) added a comment -

        I've not yet been able to test this.

        Show
        igorw Igor Wiedler [X] (Inactive) added a comment - I've not yet been able to test this.
        Hide
        igorw Igor Wiedler [X] (Inactive) added a comment -

        If somebody has a MySQL4 install I could test this patch on (or is willing to test it himself), that would be great.

        Show
        igorw Igor Wiedler [X] (Inactive) added a comment - If somebody has a MySQL4 install I could test this patch on (or is willing to test it himself), that would be great.
        Hide
        nissin nissin added a comment -

        Checked. All ok.

        Show
        nissin nissin added a comment - Checked. All ok.
        Hide
        igorw Igor Wiedler [X] (Inactive) added a comment -

        Thanks a bunch!

        Show
        igorw Igor Wiedler [X] (Inactive) added a comment - Thanks a bunch!

          People

          • Assignee:
            igorw Igor Wiedler [X] (Inactive)
            Reporter:
            nissin nissin
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development