[Gizmo99]

Hi Guys

tried to install this and it fails on and traced error to

CREATE TABLE IF NOT EXISTS `dbtech_vbarcade_favorite` ( `gameid` varchar(255) NOT NULL, `userid` int(10) unsigned NOT NULL DEFAULT '0', `timestamp` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `gameid` (`gameid`,`userid`) ) ENGINE=MyISAM

Give the error

#1071 - Specified key was too long; max key length is 1000 bytes

The code in 100.php

self::$db->query_write("
	CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "dbtech_vbarcade_favorite`
	(
		`gameid` varchar(255) NOT NULL,
		`userid` int(10) unsigned NOT NULL DEFAULT '0',
		`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
		UNIQUE KEY `gameid` (`gameid`,`userid`)
	) ENGINE=MyISAM
");
self::report('Created Table', 'dbtech_vbarcade_favorite');

Trace

Exception trace:
## phar:///var/www/core/vb/vb.phar/database.php(1204) Exception Thrown 
#0 phar:///var/www/core/vb/vb.phar/database/mysqli.php(236): vB_Database->halt()
#1 phar:///var/www/core/vb/vb.phar/database.php(587): vB_Database_MySQLi->execute_query()
#2 /var/www/vhosts/core/packages/dbtechvbarcade/install/100.php(71): vB_Database->query_write()
#3 /var/www/vhosts/core/packages/dbtechvbarcade/class_install.php(120): require_once('/var/www/vhosts...')
#4 /var/www/vhosts/core/includes/adminfunctions_product.php(947) : eval()'d code(2): DBTech_Install::install()
#5 /var/www/vhosts/core/includes/adminfunctions_product.php(947): eval()
#6 /var/www/vhosts/core/admincp/product.php(1215): install_product()
#7 /var/www/vhosts/includes/api/interface/collapsed.php(147): require_once('/var/www/vhosts...')
#8 /var/www/vhosts/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay()
#9 /var/www/vhosts/index.php(69): vB5_Frontend_Controller_Relay->admincp()
#10 {main}

Any ideas