Announcement

Collapse
No announcement yet.

Error on fresh installation

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

  • Error on fresh installation

    Database error in vBulletin :

    Invalid SQL:

    CREATE TABLE vb_noticecriteria (
    noticeid INT UNSIGNED NOT NULL DEFAULT '0',
    criteriaid VARCHAR(250) NOT NULL DEFAULT '',
    condition1 VARCHAR(250) NOT NULL DEFAULT '',
    condition2 VARCHAR(250) NOT NULL DEFAULT '',
    condition3 VARCHAR(250) NOT NULL DEFAULT '',
    PRIMARY KEY (noticeid,criteriaid)
    );

    MySQL Error : Specified key was too long; max key length is 1000 bytes
    Error Number : 1071
    Request Date : Thursday, June 29th 2017 @ 11:48:52 PM
    Error Date : Thursday, June 29th 2017 @ 11:48:54 PM
    Script : http:///install/install.php?step=3
    Referrer : http:///install/install.php?step=2
    IP Address : IPADDRESS
    Username :
    Classname : vB_Database_MySQLi
    MySQL Version : 5.6.35
    Server : 107.161.186.90
    User Agent :

    Totally not sure what's going on with this... someone help, please.

  • #3
    Originally posted by Trevor Hannant View Post
    I assume this is 3.8.10/3.8.11?
    Yes. I'm not sure what is going on with it...I tried only once.

    Comment


    • #4
      You'll have to edit the mysql-schema.php in your /install folder and change the following criteriaid field to 200 characters. UTF-8 needs 4 times the space so your index is 1004 characters long with the 250 value.


      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


      • #5
        Originally posted by Wayne Luke View Post
        You'll have to edit the mysql-schema.php in your /install folder and change the following criteriaid field to 200 characters. UTF-8 needs 4 times the space so your index is 1004 characters long with the 250 value.

        Thank you, Wayne Luke


        After changing it all, it still doesn't wanna work.
        Last edited by Phillip; Fri 30th Jun '17, 12:33pm.

        Comment


        • #6
          The next breakpoint is 191 characters. Probably other indexes that will trigger this as well. You can switch your database to another collation that is not UTF-8. Like general_latin_ci. I'll try to do a clean install and see where it breaks along the way.
          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
            I was able to install vBulletin 3.8.11 using the utf8mb4_general_ci character collation and the attached mysql-schema.php file. You can use the attached file to replace the one you currently have.
            Attached Files
            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


            • #8
              Still not wanting to work at all. Same problem.

              Comment


              • #9
                Hmm.. I don't know what to say. With that file, I can't recreate the issue. You've replaced the file on your server?
                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

                Working...
                X