Question DragonByte SEO Installation Problem

[pratul11]

Hi I am trying to install the DBtech SEO mod for my vBulletin v4 site but I am getting the following error message:

Database error in vBulletin 4.2.3:

Invalid SQL:

CREATE TABLE IF NOT EXISTS dbtech_dbseo_urlhistory (
setting VARCHAR(100) NOT NULL DEFAULT '',
regexpformat VARCHAR(100) NOT NULL DEFAULT '',
rawformat VARCHAR(100) NOT NULL DEFAULT '',
PRIMARY KEY (setting, regexpformat, rawformat)
) ENGINE=MyISAM;

MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Monday, August 10th 2020 @ 09:10:51 PM
Error Date : Monday, August 10th 2020 @ 09:10:55 PM
Script : http://www.occultforums.net/admincp/plugin.php?do=productimport
Referrer : https://www.occultforums.net/admincp/plugin.php?do=productadd
IP Address : 103.251.80.98
Username : DarkAdverts
Classname : vB_Database_MySQLi
MySQL Version : 10.4.13-MariaDB


I tried installing several times but the problem still persists. I did everything as per Readme file. Please help me. Thanks

 

[pratul11]

any help please?

 

[Fillip H.]

Try manually running this query:

CREATE TABLE IF NOT EXISTS dbtech_dbseo_urlhistory (
    setting VARCHAR(100) NOT NULL DEFAULT '',
    regexpformat VARCHAR(100) NOT NULL DEFAULT '',
    rawformat VARCHAR(100) NOT NULL DEFAULT '',
    PRIMARY KEY (setting(75), regexpformat(75), rawformat(75))
) ENGINE=MyISAM;

Then running the installer again.

 

[DragonByte Technologies]

Hello @pratul11,

We hope your ticket regarding DragonByte SEO has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @pratul11,

As we have not heard back from you, your ticket regarding DragonByte SEO has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

Thank you.


- DragonByte Technologies, Ltd.