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)
)
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)
)
Comment