user warning: Table 'drupal.flexinode_type' doesn't exist query: SELECT * FROM flexinode_type in C:\servers\apache-2.2\drupal\includes\database.mysql.inc on line 121.
user warning: Table 'drupal.flexinode_type' doesn't exist query: SELECT * FROM flexinode_type in C:\servers\apache-2.2\drupal\includes\database.mysql.inc on line 121.

Comments

ccanning’s picture

ccanning commented

The mysql scripts are not compatible with 5.0.27. This script works

CREATE TABLE flexinode_type (
ctype_id int(10) unsigned NOT NULL default '0',
name varchar(255) NOT NULL default '',
description varchar(255) NOT NULL default '',
help text NOT NULL,
PRIMARY KEY ctype_id (ctype_id)
) ENGINE=MyISAM

You can't have a default value for columns of type TEXT and it complains that TYPE is deprecated, but it still works.

Bèr Kessels’s picture

Bèr Kessels commented
Title: I get these errors after installing flexinode » Remove 'default' from columns of type TEXT
Version: 4.7.x-1.x-dev » master
Bèr Kessels’s picture

Bèr Kessels commented
Status: Active » Fixed

Repaired, and committed to HEAD on 4.7 branch.

Tested on mysql 4.1 and seems to work without problems there too, so no backwards compatibility issues.

Anonymous’s picture

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