Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-8944

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.0.8-RC1
    • 3.0.6
    • Update system
    • None
    • PHP Environment: 4.4.9
      Database: MySQL 4.0.27-log

      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.

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

              Created:
              Updated:
              Resolved: