Bug DragonByte SEO Installation Issue

[Aashi]

Hi , when i try to install XML file this error shows up ...

Database error in vBulletin 4.2.5:

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 : Saturday, November 10th 2018 @ 10:34:27 PM
Error Date : Saturday, November 10th 2018 @ 10:34:31 PM
Script : http://urdustorylove.com/admincp/plugin.php?do=productimport
Referrer : http://urdustorylove.com/admincp/plugin.php?do=productadd
IP Address : 185.244.215.241
Username : Ayesha
Classname : vB_Database_MySQLi
MySQL Version : 10.2.18-MariaDB-cll-lve
Server : 68.66.224.22
User Agent :

Please Help ... Thanks

 

[Fillip H.]

What's the character set of your database?

 

[Fillip H.]

You might be able to bypass this issue by 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`(80), `regexpformat`(80), `rawformat`(80))
) ENGINE=MyISAM;

 

[Aashi]

You might be able to bypass this issue by 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`(80), `regexpformat`(80), `rawformat`(80))
) ENGINE=MyISAM;

Thank you very much Filip H. It solved the issue

 

[DragonByte Technologies]

Hello @Aashi,

We hope your ticket regarding DragonByte SEO has been addressed to your satisfaction. This ticket has now been 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.