Bug cant install vb credits or vbseo

Whyen attempting to install credits I get the following database error:

Database error in vBulletin 4.2.5:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `co_credits_action` (
`actionid` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`multiplier` varchar(255) NOT NULL,
`parent` varchar(255) NOT NULL,
`category` varchar(255) NOT NULL,
`global` tinyint(1) unsigned NOT NULL,
`revert` tinyint(1) unsigned NOT NULL,
`cancel` tinyint(1) unsigned NOT NULL,
`rebuild` tinyint(1) unsigned NOT NULL,
`currency` tinyint(1) unsigned NOT NULL,
`referformat` varchar(255) NOT NULL,
PRIMARY KEY (`actionid`)
) ENGINE=MyISAM;

MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Friday, March 16th 2018 @ 11:37:06 PM
Error Date : Friday, March 16th 2018 @ 11:37:06 PM
Script : Log in - Calamity Zero - vBulletin Admin Control Panel
Referrer : Log in - Calamity Zero - vBulletin Admin Control Panel
IP Address : site IP
Username : Ryuzaki
Classname : vB_Database_MySQLi
MySQL Version : 5.7.21-0ubuntu0.17.10.1
Server : site IP
User Agent :

I've applied a hotfix that should resolve this

I downloaded a new copy of credits lite and uploaded it. I still get the error while trying to install.

Database error in vBulletin 4.2.5:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `co_credits_action` (
`actionid` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`multiplier` varchar(255) NOT NULL,
`parent` varchar(255) NOT NULL,
`category` varchar(255) NOT NULL,
`global` tinyint(1) unsigned NOT NULL,
`revert` tinyint(1) unsigned NOT NULL,
`cancel` tinyint(1) unsigned NOT NULL,
`rebuild` tinyint(1) unsigned NOT NULL,
`currency` tinyint(1) unsigned NOT NULL,
`referformat` varchar(255) NOT NULL,
PRIMARY KEY (`actionid`)
) ENGINE=MyISAM;

MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Saturday, March 17th 2018 @ 10:46:29 AM
Error Date : Saturday, March 17th 2018 @ 10:46:29 AM
Script : Log in - Calamity Zero - vBulletin Admin Control Panel
Referrer : Log in - Calamity Zero - vBulletin Admin Control Panel
IP Address : my ip
Username : Ryuzaki
Classname : vB_Database_MySQLi
MySQL Version : 5.7.21-0ubuntu0.17.10.1
Server : my IP
User Agent :

Try it now

It's working now, thanks!

Hello Drahnier,

This ticket has now been closed with the status Fixed.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!