vB5 database installation error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mellnik
    Member
    • Jan 2012
    • 32

    vB5 database installation error

    Hi there.

    vBulletin 5 installation fails on my server with following error:
    Specified key was too long; max key length is 767 bytes


    Click image for larger version

Name:	vb.png
Views:	98
Size:	13.0 KB
ID:	4344804

    Server with default distribution packages:
    Ubuntu 16.04 x64
    NGINX 1.10.0 using https://www.vbulletin.com/docs/html/preparefiles_nginx
    PHP 7.0.4-7
    MariaDB 10.0.24 with mysqli

    I think it's due to MariaDB 10. It would be nice if you support MariaDB 10 in the next release
    because it is the default MariaDB version on Ubuntu 16 and other people are probably going to get
    the same error.
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74123

    #2
    We support MariaDB now. The error is caused by a limitation in the configuration of the server. This issue is fixed in 5.2.3. In the meantime replace /core/install/mysql-schema.php with the attached file.

    See Post #4.
    Last edited by Wayne Luke; Fri 10 Jun '16, 10:21am.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • Mellnik
      Member
      • Jan 2012
      • 32

      #3
      First error is fixed, now it's complaining about another table. Please fix them all in 5.2.3 .

      Click image for larger version

Name:	vb2.png
Views:	82
Size:	17.1 KB
ID:	4344853

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 74123

        #4
        The mysql-schema.php is from a 5.2.3 nightly build. It should have all the required changes.
        Attached Files
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        Related Topics

        Collapse

        Working...