By xzero on

I install drupal 4.6 with no problem but on the creation on content page or story
i recived the following message

Field 'revisions' doesn't have a default value query: INSERT INTO node (status, moderate, promote, sticky, comment, title, body, format, uid, created, type, teaser, changed, nid) VALUES('1', '0', '1', '0', '2', 'Pagina de prueba', '', '1', '1', '1133890093', 'story', '', '1133890106', '4') in C:\Apache2\htdocs\drupal\includes\database.mysql.inc on line 66.

testing drupal with MySQL 5.0.16 + PHP 5.1.1 + Apache 2.0.54 on Win2K

⋅ Categories: Drupal 4.6.x

Comments

JKomorek’s picture

JKomorek commented

I received the same error and resolved it by dropping the NODE table and recreating it after adding a default value of '' (empty string) to the revisions column.

xzero’s picture

xzero commented

thanks, problem resolved, i check the sql on database drupal
version on sqldump is for mysql 3.23, work with 4.01 or older version no with mysql 5.0.16

mjshirley79’s picture

mjshirley79 commented

As noted above:

I dropped table 'node' and ran the following...

--
-- Table structure for table 'node'
--

CREATE TABLE node (
  nid int(10) unsigned NOT NULL auto_increment,
  type varchar(16) NOT NULL default '',
  title varchar(128) NOT NULL default '',
  uid int(10) NOT NULL default '0',
  status int(4) NOT NULL default '1',
  created int(11) NOT NULL default '0',
  changed int(11) NOT NULL default '0',
  comment int(2) NOT NULL default '0',
  promote int(2) NOT NULL default '0',
  moderate int(2) NOT NULL default '0',
  teaser longtext NOT NULL,
  body longtext NOT NULL,
  revisions longtext NOT NULL default '',
  sticky int(2) NOT NULL default '0',
  format int(4) NOT NULL default '0',
  PRIMARY KEY (nid),
  KEY node_type (type(4)),
  KEY node_title_type (title,type(4)),
  KEY status (status),
  KEY uid (uid),
  KEY node_moderate (moderate),
  KEY node_promote_status (promote, status),
  KEY node_created (created),
  KEY node_changed (changed),
  KEY node_status_type (status, type, nid)
) TYPE=MyISAM;

Tried creating content/page again with the same error after submitting. Page Not Found...

Did I miss something?

mySql 5.x