I'm using 1.7 and still getting an error creating contemplate_files. I uninstalled and reinstalled and still getting the column length to long for site. Here is the error on update:

user warning: Too big column length for column 'site' (max = 255). Use BLOB instead query: CREATE TABLE contemplate_files ( site varchar(256) NOT NULL, data longblob NOT NULL, UNIQUE KEY site (site(256)) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /var/home/soul/wwwroot/soultracks.com/test/includes/database.mysql.inc on line 172.

Am I missing something?

Comments

enxox’s picture

enxox commented

same for me

enxox’s picture

enxox commented

oops
my error

user warning: Incorrect sub part key. The used key part isn't a string, the used length is longer than the key part or the table handler doesn't support unique sub keys query: CREATE TABLE contemplate_files ( site varchar(255) NOT NULL, `data` longblob NOT NULL, UNIQUE KEY site (site(256)) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in e:\programmi\easyphp1-7\www\drupalmikele\includes\database.mysql.inc on line 172.

enxox’s picture

enxox commented

error found!!!

site varchar(255) is less than UNIQUE KEY site (site(256))

is 255 or 256 the right value?

in module install

db_query("CREATE TABLE {contemplate_files} (
site varchar(255) NOT NULL,
`data` longblob NOT NULL,
UNIQUE KEY site (site(256))
) /*!40100 DEFAULT CHARACTER SET utf8 */;");

rinvelt’s picture

rinvelt commented
Status: Active » Fixed

Looks like this is corrected in 1.8-beta2

jjeff’s picture

jjeff commented

Yes. This is corrected in 1.8-beta2. Please download and try again.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)