Announcement

Collapse
No announcement yet.

Index column size too large

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Index column size too large

    Hello
    You can help me with this problem
    Thank you



    An error has occurred with your database. Please contact vBulletin Support for assistance. Module: install, Step 3 Database Error:1709
    Index column size too large. The maximum column size is 767 bytes.
    Query:

    CREATE TABLE adminmessage ( adminmessageid INT UNSIGNED NOT NULL AUTO_INCREMENT, varname varchar(250) NOT NULL DEFAULT '', dismissable SMALLINT UNSIGNED NOT NULL DEFAULT '0', script varchar(50) NOT NULL DEFAULT '', action varchar(20) NOT NULL DEFAULT '', execurl MEDIUMTEXT, method enum('get','post') NOT NULL DEFAULT 'post', dateline INT UNSIGNED NOT NULL DEFAULT '0', status enum('undone','done','dismissed') NOT NULL default 'undone', statususerid INT UNSIGNED NOT NULL DEFAULT '0', args MEDIUMTEXT, PRIMARY KEY (adminmessageid), KEY script_action (script, action), KEY varname (varname) ) ENGINE = InnoDB

    Script: install
    Step: 3



  • #2
    You will need to set innodb_large_prefix in your MySQL Configuration. Please see the documentation on this variable here: https://dev.mysql.com/doc/refman/5.5...b_large_prefix.

    Upgrading to MySQL 5.7 or higher and not explicitly turning this value off will also resolve the issue.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment


    • #3
      I do not know much about MySQL
      how can i update

      Comment


      • #4
        Originally posted by tzan1970 View Post
        I do not know much about MySQL
        how can i update
        This is something you would ask your host for assistance with.
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.4.2 Demo - FEATURING "ROUTE BY NODE"!
        AdminAmmo - My Cloud Demo

        Comment


        • #5
          you describe me as a picture or video
          how can i do this update

          Comment


          • #6
            The link I provided above tells you have to make changes to the MySQL Configuration. If you don't know how to use the server software, you should be using managed hosting plan where the provider will handle these changes.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud customization and demonstration site.
            vBulletin 5 Documentation - Updated every Friday. Report issues here.
            vBulletin 5 API - Full / Mobile
            I am not currently available for vB Messenger Chats.

            Comment


            • #7
              Unfortunately the problem was not solved

              Click image for larger version

Name:	6xobgupw.png
Views:	1
Size:	25.9 KB
ID:	4394978
              Last edited by tzan1970; Wed 18th Jul '18, 10:56am.

              Comment


              • #8
                This is the same error. The value above has not been set on your database. Until your server administrator sets the value and restarts the database server, the error will continue.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud customization and demonstration site.
                vBulletin 5 Documentation - Updated every Friday. Report issues here.
                vBulletin 5 API - Full / Mobile
                I am not currently available for vB Messenger Chats.

                Comment

                Related Topics

                Collapse

                Working...
                X