Announcement

Collapse
No announcement yet.

Trouble Installing VBulletin 4.2.5 on PHP 5.6 and MariaDB

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

  • Trouble Installing VBulletin 4.2.5 on PHP 5.6 and MariaDB

    Good day,
    I intend to run VBulletin 4 on a VPS running debian 9 and which is also running PHP 5.6, with MariaDB 10. However, when I run the install, it gets to the database step and reports errors like a key is to long, etc. The installer upon clicking on ok aborts and does not continue.
    Is this because VBulletin does not support MariaDB (hents, MYSQL) must be used, or is it do to the PHP version being used.
    As well, I tried installing on a test server running MariaDB 10 and PHP 7, but PHP code was rendered and not an actual web page showed up.
    When I went to download VBulletin 4.2.5, the page states that that version does work with MariaDB and (at least) PHP version 5.6.0 plus.
    However, when I go to install the software (in particular the forum part only,) I get errors in regards to database queries.
    The server that this is on is running PHP version 5.6.32, and MariaDB -- mysql Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2.
    The install error I get is below:
    An error has occurred with your database. Please contact vBulletin Support for assistance.
    Module: install, Step 2 Database Error:1071
    Specified key was too long; max key length is 767 bytes
    Query
    CREATE TABLE adcriteria (
    adid 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 (adid,criteriaid)
    )

  • #2
    The following changes are not supported and this is not tested at all!

    Find the table creation query in install/mysql-schema.php. Search for adcriteria.

    Add ENGINE = MyISAM after the closing bracket ).

    It looks like this
    Code:
    CREATE TABLE " . TABLE_PREFIX . "adcriteria (
        adid 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 (adid,criteriaid)
    ) ENGINE = MyISAM
    ";
    Search for noticecriteria and make the same change.


    If this doesn't help you can instead try to change criteriaid VARCHAR(250) to criteriaid VARCHAR(50) in both CREATE TABLE queries since there is no criteriaid with more than 50 characters.


    --------------------------------
    Now I found that this was mentioned here, too:
    https://www.vbulletin.com/forum/foru...h-installation

    I am not sure though if this is working with 190 if your MariaDB is useing utf8mb4 as the character set.
    this is my sig

    Comment


    • #3
      Hello,
      I figured it out on my own, though support asked what character set and collate I was using and hasn't responded back to my reply. I ended up changing the character set to utf8 with the collation of utf8_general_ci , and it seems to have fixed the problem.
      I ended up having to drop the database, then ran:
      Code:
      CREATE DATABASE forum CHARACTER SET utf8 COLLATE utf8_general_ci;
      And that seemed to have fixed it. Thanks for the assistance and quick response.

      Comment

      Related Topics

      Collapse

      Working...
      X