user warning: Column length too big for column 'title' (max = 255); use BLOB or TEXT instead query: CREATE TABLE newsticker_item ( `ntid` INT unsigned NOT NULL auto_increment, `title` VARCHAR(256) NOT NULL DEFAULT '', `link` VARCHAR(512) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, PRIMARY KEY (ntid), INDEX ntid (ntid) )

Comments

matslats’s picture

matslats commented
Title: install error on mySQL 4 » nother install error on mySQL 4

user warning: Column length too big for column 'link' (max = 255); use BLOB or TEXT instead query: CREATE TABLE newsticker_item ( `ntid` INT unsigned NOT NULL auto_increment, `title` VARCHAR(255) NOT NULL DEFAULT '', `link` VARCHAR(512) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, PRIMARY KEY (ntid), INDEX ntid (ntid) )

jlea9378’s picture

jlea9378 commented
Title: nother install error on mySQL 4 » another install error on mySQL 4

I'm also getting this error.
MySQL 4.1.22
PHP 5.2.12

Changing the schema to this:
'title' => array(
'type' => 'varchar',
'length' => 255,
'not null' => TRUE,
'default' => '',
'description' => t('Title')
),
'link' => array(
'type' => 'varchar',
'length' => 255,
'not null' => TRUE,
'default' => '',
'description' => t('Link')

Allows me to install the module without errors.

jlea9378’s picture

jlea9378 commented
Status: Active » Needs review

Can this be closed?