[DragonByte Tech]

Originally Posted by Montecristo

Thanks....

and now...:

Database error in vBulletin 4.0.8:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `dbtech_downloads_filegroup` (
`groupid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`userid` INT(20) UNSIGNED NOT NULL DEFAULT '0',
`groupname` VARCHAR(1000) NOT NULL,
`groupdesc` MEDIUMTEXT NULL,
`downloads` INT(15) UNSIGNED NOT NULL DEFAULT '0',
`files` MEDIUMTEXT NULL,
`filecount` INT(5) UNSIGNED NOT NULL DEFAULT '0',
`image` SMALLINT(10) NULL DEFAULT '0',
`rating` INT(11) NOT NULL DEFAULT '0',
`updated` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`categoryid` INT(20) NOT NULL,
`moderation` ENUM('0','1') NOT NULL DEFAULT '0',
`password` CHAR(250) NULL DEFAULT NULL,
`private` MEDIUMTEXT NULL,
`favourites` INT(10) NULL DEFAULT '0',
`mirrors` MEDIUMTEXT NULL DEFAULT NULL,
PRIMARY KEY (`groupid`),
INDEX `groupname` (`groupname`),
INDEX `userid` (`userid`)
);

MySQL Error : BLOB/TEXT column 'groupname' used in key specification without a key length
Error Number : 1170
Request Date : Sunday, October 24th 2010 @ 07:12:38 PM
Error Date : Sunday, October 24th 2010 @ 07:12:38 PM
Script : http://www.actors-studio.org/Foros/a...=productimport
Referrer : http://www.actors-studio.org/Foros/a...?do=productadd
IP Address : 190.177.225.98
Username : Actors
Classname : vB_Database
MySQL Version : 4.1.13a-log

I'll have a fix up soon.

- David