Bug cant install vb credits or vbseo

Status
Not open for further replies.
#1
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 :
 
#3
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 :
 

DragonByte Technologies

Company Information
Staff member
Company Info
#6
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!
 
Status
Not open for further replies.

vBCredits II Deluxe

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
816
Customer rating
0.00 star(s) 0 ratings
Top