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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.6
    • 3.0.8-RC1
    • Update system
    • None
    • 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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: