By mbroome on

user error: Table 'webpage.profile_fields' doesn't exist
query: SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 1 in C:\publichtml\includes\database.mysql.inc on line 66.
user error: 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', '0', 'bla', 'test', '3', '1', '1135816561', 'story', 'test', '1135816639', '3') in C:\publichtml\includes\database.mysql.inc on line 66.
warning: Cannot modify header information - headers already sent by (output started at C:\publichtml\includes\common.inc:384) in C:\publichtml\includes\common.inc on line 192.

i receive the following :( any ideas?

Comments

dman’s picture

dman commented

Um, so make it?

Looks like your creation of the database tables failed somewhat. Better run the entire MySQL import again - and watch the errors this time.

Probably the same story with your "CREATE TABLE node".
It's a new install, so just delete the DB altogether, re-create it, and run the
database.mysql again.

http://www.coders.co.nz/

.dan. is the New Zealand Drupal Developer working on Government Web Standards

mbroome’s picture

mbroome commented

mysql> -- Table structure for table 'term_data'
mysql> --
mysql>
mysql> CREATE TABLE term_data (
-> tid int(10) unsigned NOT NULL auto_increment,
-> vid int(10) unsigned NOT NULL default '0',
-> name varchar(255) NOT NULL default '',
-> description longtext,
-> weight tinyint(4) NOT NULL default '0',
-> PRIMARY KEY (tid),
-> KEY vid (vid)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'term_hierarchy'
mysql> --
mysql>
mysql> CREATE TABLE term_hierarchy (
-> tid int(10) unsigned NOT NULL default '0',
-> parent int(10) unsigned NOT NULL default '0',
-> KEY tid (tid),
-> KEY parent (parent)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'term_node'
mysql> --
mysql>
mysql> CREATE TABLE term_node (
-> nid int(10) unsigned NOT NULL default '0',
-> tid int(10) unsigned NOT NULL default '0',
-> KEY nid (nid),
-> KEY tid (tid),
-> PRIMARY KEY (tid,nid)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'term_relation'
mysql> --
mysql>
mysql> CREATE TABLE term_relation (
-> tid1 int(10) unsigned NOT NULL default '0',
-> tid2 int(10) unsigned NOT NULL default '0',
-> KEY tid1 (tid1),
-> KEY tid2 (tid2)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.09 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'term_synonym'
mysql> --
mysql>
mysql> CREATE TABLE term_synonym (
-> tid int(10) unsigned NOT NULL default '0',
-> name varchar(255) NOT NULL default '',
-> KEY tid (tid),
-> KEY name (name(3))
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.09 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'users'
mysql> --
mysql>
mysql> CREATE TABLE users (
-> uid int(10) unsigned NOT NULL default '0',
-> name varchar(60) NOT NULL default '',
-> pass varchar(32) NOT NULL default '',
-> mail varchar(64) default '',
-> mode tinyint(1) NOT NULL default '0',
-> sort tinyint(1) default '0',
-> threshold tinyint(1) default '0',
-> theme varchar(255) NOT NULL default '',
-> signature varchar(255) NOT NULL default '',
-> created int(11) NOT NULL default '0',
-> changed int(11) NOT NULL default '0',
-> status tinyint(4) NOT NULL default '0',
-> timezone varchar(8) default NULL,
-> language varchar(12) NOT NULL default '',
-> picture varchar(255) NOT NULL DEFAULT '',
-> init varchar(64) default '',
-> data longtext,
-> PRIMARY KEY (uid),
-> UNIQUE KEY name (name),
-> KEY changed (changed)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'users_roles'
mysql> --
mysql>
mysql> CREATE TABLE users_roles (
-> uid int(10) unsigned NOT NULL default '0',
-> rid int(10) unsigned NOT NULL default '0',
-> PRIMARY KEY (uid, rid)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'variable'
mysql> --
mysql>
mysql> CREATE TABLE variable (
-> name varchar(48) NOT NULL default '',
-> value longtext NOT NULL,
-> PRIMARY KEY (name)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'vocabulary'
mysql> --
mysql>
mysql> CREATE TABLE vocabulary (
-> vid int(10) unsigned NOT NULL auto_increment,
-> name varchar(255) NOT NULL default '',
-> description longtext,
-> help varchar(255) NOT NULL default '',
-> relations tinyint(3) unsigned NOT NULL default '0',
-> hierarchy tinyint(3) unsigned NOT NULL default '0',
-> multiple tinyint(3) unsigned NOT NULL default '0',
-> required tinyint(3) unsigned NOT NULL default '0',
-> module varchar(255) NOT NULL default '',
-> weight tinyint(4) NOT NULL default '0',
-> PRIMARY KEY (vid)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'vocabulary_node_types'
mysql> --
mysql>
mysql> CREATE TABLE vocabulary_node_types (
-> vid int(10) unsigned NOT NULL DEFAULT '0',
-> type varchar(16) NOT NULL DEFAULT '',
-> PRIMARY KEY (vid, type)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.11 sec)

mysql>
mysql> --
mysql> -- Table structure for table 'watchdog'
mysql> --
mysql>
mysql>
CREATE TABLE watchdog (
-> wid int(5) NOT NULL auto_increment,
-> uid int(10) NOT NULL default '0',
-> type varchar(16) NOT NULL default '',
-> message longtext NOT NULL,
-> severity tinyint(3) unsigned NOT NULL default '0',
-> link varchar(255) NOT NULL default '',
-> location varchar(128) NOT NULL default '',
-> hostname varchar(128) NOT NULL default '',
-> timestamp int(11) NOT NULL default '0',
-> PRIMARY KEY (wid)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.14 sec)

mysql>
mysql> --
mysql> -- Insert some default values
mysql> --
mysql>
mysql> INSERT INTO system VALUES ('modules/block.module','block','module','',1,0
,0);
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO system VALUES ('modules/comment.module','comment','module',''
,1,0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/filter.module','filter','module','',1
,0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/help.module','help','module','',1,0,0
);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/node.module','node','module','',1,0,0
);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/page.module','page','module','',1,0,0
);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/story.module','story','module','',1,0
,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/system.module','system','module','',1
,0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module',
'',1,0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/user.module','user','module','',1,0,0
);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('modules/watchdog.module','watchdog','module',
'',1,0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('themes/bluemarine/xtemplate.xtmpl','bluemarin
e','theme','themes/engines/xtemplate/xtemplate.engine',1,0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO system VALUES ('themes/engines/xtemplate/xtemplate.engine','x
template','theme_engine','',1,0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO users_roles (uid, rid) VALUES (0, 1);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> INSERT INTO role (rid, name) VALUES (1, 'anonymous user');
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO permission VALUES (1,'access content',0);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> INSERT INTO role (rid, name) VALUES (2, 'authenticated user');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO permission VALUES (2,'access comments, access content, post c
omments, post comments without approval',0);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> REPLACE variable SET name='update_start', value='s:10:"2005-03-21";';
Query OK, 1 row affected (0.00 sec)

mysql> REPLACE variable SET name='theme_default', value='s:10:"bluemarine";';
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> REPLACE blocks SET module = 'user', delta = '0', status = '1';
ERROR 1364 (HY000): Field 'pages' doesn't have a default value
mysql> REPLACE blocks SET module = 'user', delta = '1', status = '1';
ERROR 1364 (HY000): Field 'pages' doesn't have a default value
mysql>
mysql> INSERT INTO sequences (name, id) VALUES ('menu_mid', 1);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);
Query OK, 1 row affected (0.02 sec)

mysql>
mysql> INSERT INTO filter_formats VALUES (1,'Filtered HTML',',1,2,',1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO filter_formats VALUES (2,'PHP code','',0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO filter_formats VALUES (3,'Full HTML','',1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO filters VALUES (1,'filter',0,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO filters VALUES (1,'filter',2,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO filters VALUES (2,'filter',1,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO filters VALUES (3,'filter',2,0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO variable (name,value) VALUES ('filter_html_1','i:1;');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> INSERT INTO locales_meta (locale, name, enabled, isdefault) VALUES ('en',
'English', '1', '1');
Query OK, 1 row affected (0.00 sec)

mysql>

getting errors using the stock tables included.........any suggestions?

mbroome’s picture

mbroome commented 
-- MySQL dump 8.22
--
-- Host: localhost    Database: drupal_devel
-- Server version  3.23.52-nt

--
-- Table structure for table 'access'
--

CREATE TABLE access (
  aid tinyint(10) NOT NULL auto_increment,
  mask varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  status tinyint(2) NOT NULL default '0',
  PRIMARY KEY (aid)
) TYPE=MyISAM;

--
-- Table structure for table 'accesslog'
--

CREATE TABLE accesslog (
  aid int(10) NOT NULL auto_increment,
  title varchar(255) default NULL,
  path varchar(255) default NULL,
  url varchar(255) default NULL,
  hostname varchar(128) default NULL,
  uid int(10) unsigned default '0',
  timestamp int(11) unsigned NOT NULL default '0',
  KEY accesslog_timestamp (timestamp),
  PRIMARY KEY (aid)
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_category'
--

CREATE TABLE aggregator_category (
  cid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  block tinyint(2) NOT NULL default '0',
  PRIMARY KEY (cid),
  UNIQUE KEY title (title)
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_category_feed'
--

CREATE TABLE aggregator_category_feed (
  fid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
  PRIMARY KEY (fid,cid)
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_category_item'
--

CREATE TABLE aggregator_category_item (
  iid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
  PRIMARY KEY (iid,cid)
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_feed'
--

CREATE TABLE aggregator_feed (
  fid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  refresh int(10) NOT NULL default '0',
  checked int(10) NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  image longtext NOT NULL,
  etag varchar(255) NOT NULL default '',
  modified int(10) NOT NULL default '0',
  block tinyint(2) NOT NULL default '0',
  PRIMARY KEY (fid),
  UNIQUE KEY link (url),
  UNIQUE KEY title (title)
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_item'
--

CREATE TABLE aggregator_item (
  iid int(10) NOT NULL auto_increment,
  fid int(10) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  author varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  timestamp int(11) default NULL,
  PRIMARY KEY (iid)
) TYPE=MyISAM;

--
-- Table structure for table 'authmap'
--

CREATE TABLE authmap (
  aid int(10) unsigned NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  authname varchar(128) NOT NULL default '',
  module varchar(128) NOT NULL default '',
  PRIMARY KEY (aid),
  UNIQUE KEY authname (authname)
) TYPE=MyISAM;

--
-- Table structure for table 'blocks'
--

CREATE TABLE blocks (
  module varchar(64) DEFAULT '' NOT NULL,
  delta varchar(32) NOT NULL default '0',
  status tinyint(2) DEFAULT '0' NOT NULL,
  weight tinyint(1) DEFAULT '0' NOT NULL,
  region tinyint(1) DEFAULT '0' NOT NULL,
  custom tinyint(2) DEFAULT '0' NOT NULL,
  throttle tinyint(1) DEFAULT '0' NOT NULL,
  visibility tinyint(1) DEFAULT '0' NOT NULL,
  pages text NOT NULL,
  types text NOT NULL
) TYPE=MyISAM;

--
-- Table structure for table 'book'
--

CREATE TABLE book (
  nid int(10) unsigned NOT NULL default '0',
  parent int(10) NOT NULL default '0',
  weight tinyint(3) NOT NULL default '0',
  log longtext,
  PRIMARY KEY (nid),
  KEY parent (parent)
) TYPE=MyISAM;

--
-- Table structure for table 'boxes'
--

CREATE TABLE boxes (
  bid tinyint(4) NOT NULL auto_increment,
  title varchar(64) NOT NULL default '',
  body longtext,
  info varchar(128) NOT NULL default '',
  format int(4) NOT NULL default '0',
  PRIMARY KEY (bid),
  UNIQUE KEY title (title),
  UNIQUE KEY info (info)
) TYPE=MyISAM;

--
-- Table structure for table 'cache'
--

CREATE TABLE cache (
  cid varchar(255) NOT NULL default '',
  data longtext,
  expire int(11) NOT NULL default '0',
  created int(11) NOT NULL default '0',
  headers text,
  PRIMARY KEY (cid),
  INDEX expire (expire)
) TYPE=MyISAM;

--
-- Table structure for table 'comments'
--

CREATE TABLE comments (
  cid int(10) NOT NULL auto_increment,
  pid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  subject varchar(64) NOT NULL default '',
  comment longtext NOT NULL,
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  score mediumint(9) NOT NULL default '0',
  status tinyint(3) unsigned NOT NULL default '0',
  format int(4) NOT NULL default '0',
  thread varchar(255) NOT NULL,
  users longtext,
  name varchar(60) default NULL,
  mail varchar(64) default NULL,
  homepage varchar(255) default NULL,
  PRIMARY KEY (cid),
  KEY lid (nid)
) TYPE=MyISAM;

--
-- Table structre for table 'node_last_comment'
--

CREATE TABLE node_comment_statistics (
  nid int(10) unsigned NOT NULL auto_increment,
  last_comment_timestamp int(11) NOT NULL default '0',
  last_comment_name varchar(60)  default NULL,
  last_comment_uid int(10) NOT NULL default '0',
  comment_count int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (nid),
  KEY node_comment_timestamp (last_comment_timestamp)
) TYPE=MyISAM;

--
-- Table structure for table 'directory'
--

CREATE TABLE directory (
  link varchar(255) NOT NULL default '',
  name varchar(128) NOT NULL default '',
  mail varchar(128) NOT NULL default '',
  slogan longtext NOT NULL,
  mission longtext NOT NULL,
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY (link)
) TYPE=MyISAM;

--
-- Table structure for table 'files'
--

CREATE TABLE files (
  fid int(10) unsigned NOT NULL default '0',
  nid int(10) unsigned NOT NULL default '0',
  filename varchar(255) NOT NULL default '',
  filepath varchar(255) NOT NULL default '',
  filemime varchar(255) NOT NULL default '',
  filesize int(10) unsigned NOT NULL default '0',
  list tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY (fid)
) TYPE=MyISAM;

--
-- Table structure for table 'filter_formats'
--

CREATE TABLE filter_formats (
  format int(4) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  roles varchar(255) NOT NULL default '',
  cache tinyint(2) NOT NULL default '0',
  PRIMARY KEY (format)
) TYPE=MyISAM;

--
-- Table structure for table 'filters'
--

CREATE TABLE filters (
  format int(4) NOT NULL default '0',
  module varchar(64) NOT NULL default '',
  delta tinyint(2) DEFAULT '0' NOT NULL,
  weight tinyint(2) DEFAULT '0' NOT NULL,
  INDEX (weight)
) TYPE=MyISAM;

--
-- Table structure for table 'flood'
--

CREATE TABLE flood (
  event varchar(64) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table 'forum'
--

CREATE TABLE forum (
  nid int(10) unsigned NOT NULL default '0',
  tid int(10) unsigned NOT NULL default  '0',
  PRIMARY KEY (nid),
  KEY tid (tid)
) TYPE=MyISAM;

--
-- Table structure for table 'history'
--

CREATE TABLE history (
  uid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY (uid,nid)
) TYPE=MyISAM;

--
-- Table structure for table 'locales_meta'
--

CREATE TABLE locales_meta (
  locale varchar(12) NOT NULL default '',
  name varchar(64) NOT NULL default '',
  enabled int(2) NOT NULL default '0',
  isdefault int(2) NOT NULL default '0',
  plurals int(1) NOT NULL default '0',
  formula varchar(128) NOT NULL default '',
  PRIMARY KEY (locale)
) TYPE=MyISAM;

--
-- Table structure for table 'locales_source'
--

CREATE TABLE locales_source (
  lid int(11) NOT NULL auto_increment,
  location varchar(255) NOT NULL default '',
  source blob NOT NULL,
  PRIMARY KEY (lid)
) TYPE=MyISAM;

--
-- Table structure for table 'locales_target'
--

CREATE TABLE locales_target (
  lid int(11) NOT NULL default '0',
  translation blob NOT NULL,
  locale varchar(12) NOT NULL default '',
  plid int(11) NOT NULL default '0',
  plural int(1) NOT NULL default '0',
  KEY lid (lid),
  KEY lang (locale),
  KEY plid (plid),
  KEY plural (plural)
) TYPE=MyISAM;

--
-- Table structure for table 'menu'
--

CREATE TABLE menu (
  mid int(10) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  weight tinyint(4) NOT NULL default '0',
  type int(2) unsigned NOT NULL default '0',
  PRIMARY KEY (mid)
) TYPE=MyISAM;

--
-- Table structure for table 'moderation_filters'
--

CREATE TABLE moderation_filters (
  fid int(10) unsigned NOT NULL auto_increment,
  filter varchar(255) NOT NULL default '',
  minimum smallint(6) NOT NULL default '0',
  PRIMARY KEY (fid)
) TYPE=MyISAM;

--
-- Table structure for table 'moderation_roles'
--

CREATE TABLE moderation_roles (
  rid int(10) unsigned NOT NULL default '0',
  mid int(10) unsigned NOT NULL default '0',
  value tinyint(4) NOT NULL default '0',
  KEY idx_rid (rid),
  KEY idx_mid (mid)
) TYPE=MyISAM;

--
-- Table structure for table 'moderation_votes'
--

CREATE TABLE moderation_votes (
  mid int(10) unsigned NOT NULL auto_increment,
  vote varchar(255) default NULL,
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY (mid)
) TYPE=MyISAM;

--
-- 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,
  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;

--
-- Table structure for table `node_access`
--

CREATE TABLE node_access (
  nid int(10) unsigned NOT NULL default '0',
  gid int(10) unsigned NOT NULL default '0',
  realm varchar(255) NOT NULL default '',
  grant_view tinyint(1) unsigned NOT NULL default '0',
  grant_update tinyint(1) unsigned NOT NULL default '0',
  grant_delete tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY (nid,gid,realm)
) TYPE=MyISAM;

--
-- Table structure for table 'profile_fields'
--

CREATE TABLE profile_fields (
  fid int(10) NOT NULL auto_increment,
  title varchar(255) default NULL,
  name varchar(128) default NULL,
  explanation TEXT default NULL,
  category varchar(255) default NULL,
  page varchar(255) default NULL,
  type varchar(128) default NULL,
  weight tinyint(1) DEFAULT '0' NOT NULL,
  required tinyint(1) DEFAULT '0' NOT NULL,
  register tinyint(1) DEFAULT '0' NOT NULL,
  visibility tinyint(1) DEFAULT '0' NOT NULL,
  options text,
  KEY category (category),
  UNIQUE KEY name (name),
  PRIMARY KEY (fid)
);

--
-- Table structure for table 'profile_values'
--

CREATE TABLE profile_values (
  fid int(10) unsigned default '0',
  uid int(10) unsigned default '0',
  value text,
  KEY uid (uid),
  KEY fid (fid)
);


--
-- Table structure for table 'url_alias'
--

CREATE TABLE url_alias (
  pid int(10) unsigned NOT NULL auto_increment,
  src varchar(128) NOT NULL default '',
  dst varchar(128) NOT NULL default '',
  PRIMARY KEY (pid),
  UNIQUE KEY dst (dst)
) TYPE=MyISAM;

--
-- Table structure for table 'permission'
--

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',
  perm longtext,
  tid int(10) unsigned NOT NULL default '0',
  KEY rid (rid)
) TYPE=MyISAM;

--
-- Table structure for table 'poll'
--

CREATE TABLE poll (
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
  polled longtext NOT NULL,
  active int(2) unsigned NOT NULL default '0',
  PRIMARY KEY (nid)
) TYPE=MyISAM;

--
-- Table structure for table 'poll_choices'
--

CREATE TABLE poll_choices (
  chid int(10) unsigned NOT NULL auto_increment,
  nid int(10) unsigned NOT NULL default '0',
  chtext varchar(128) NOT NULL default '',
  chvotes int(6) NOT NULL default '0',
  chorder int(2) NOT NULL default '0',
  PRIMARY KEY (chid),
  KEY nid (nid)
) TYPE=MyISAM;

--
-- Table structure for table 'queue'
--

CREATE TABLE queue (
  nid int(10) unsigned NOT NULL,
  uid int(10) unsigned NOT NULL,
  vote int(3) NOT NULL default '0',
  PRIMARY KEY (nid, uid)
) TYPE=MyISAM;

--
-- Table structure for table 'role'
--

CREATE TABLE role (
  rid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  PRIMARY KEY (rid),
  UNIQUE KEY name (name)
) TYPE=MyISAM;

--
-- Table structure for table 'search_index'
--

CREATE TABLE search_index (
  word varchar(50) NOT NULL default '',
  sid int(10) unsigned NOT NULL default '0',
  type varchar(16) default NULL,
  fromsid int(10) unsigned NOT NULL default '0',
  fromtype varchar(16) default NULL,
  score int(10) unsigned default NULL,
  KEY sid (sid),
  KEY fromsid (fromsid),
  KEY word (word)
) TYPE=MyISAM;

--
-- Table structure for table 'search_total'
--

CREATE TABLE search_total (
  word varchar(50) NOT NULL default '',
  count int(10) unsigned default NULL,
  PRIMARY KEY word (word)
) TYPE=MyISAM;

--
-- Table structure for table 'sessions'
--


CREATE TABLE sessions (
  uid int(10) unsigned NOT NULL,
  sid varchar(32) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  session longtext,
  KEY uid (uid),
  PRIMARY KEY (sid),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table 'sequences'
--

CREATE TABLE sequences (
  name varchar(255) NOT NULL default '',
  id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (name)
) TYPE=MyISAM;

--
-- Table structure for table 'node_counter'
--

CREATE TABLE node_counter (
  nid int(11) NOT NULL default '0',
  totalcount bigint(20) unsigned NOT NULL default '0',
  daycount mediumint(8) unsigned NOT NULL default '0',
  timestamp int(11) unsigned NOT NULL default '0',
  PRIMARY KEY (nid),
  KEY totalcount (totalcount),
  KEY daycount (daycount),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table 'system'
--

CREATE TABLE system (
  filename varchar(255) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  status int(2) NOT NULL default '0',
  throttle tinyint(1) DEFAULT '0' NOT NULL,
  bootstrap int(2) NOT NULL default '0',
  PRIMARY KEY (filename)
) TYPE=MyISAM;

--
-- Table structure for table 'term_data'
--

CREATE TABLE term_data (
  tid int(10) unsigned NOT NULL auto_increment,
  vid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description longtext,
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY (tid),
  KEY vid (vid)
) TYPE=MyISAM;

--
-- Table structure for table 'term_hierarchy'
--

CREATE TABLE term_hierarchy (
  tid int(10) unsigned NOT NULL default '0',
  parent int(10) unsigned NOT NULL default '0',
  KEY tid (tid),
  KEY parent (parent)
) TYPE=MyISAM;

--
-- Table structure for table 'term_node'
--

CREATE TABLE term_node (
  nid int(10) unsigned NOT NULL default '0',
  tid int(10) unsigned NOT NULL default '0',
  KEY nid (nid),
  KEY tid (tid),
  PRIMARY KEY (tid,nid)
) TYPE=MyISAM;

--
-- Table structure for table 'term_relation'
--

CREATE TABLE term_relation (
  tid1 int(10) unsigned NOT NULL default '0',
  tid2 int(10) unsigned NOT NULL default '0',
  KEY tid1 (tid1),
  KEY tid2 (tid2)
) TYPE=MyISAM;

--
-- Table structure for table 'term_synonym'
--

CREATE TABLE term_synonym (
  tid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  KEY tid (tid),
  KEY name (name(3))
) TYPE=MyISAM;

--
-- Table structure for table 'users'
--

CREATE TABLE users (
  uid int(10) unsigned NOT NULL default '0',
  name varchar(60) NOT NULL default '',
  pass varchar(32) NOT NULL default '',
  mail varchar(64) default '',
  mode tinyint(1) NOT NULL default '0',
  sort tinyint(1) default '0',
  threshold tinyint(1) default '0',
  theme varchar(255) NOT NULL default '',
  signature varchar(255) NOT NULL default '',
  created int(11) NOT NULL default '0',
  changed int(11) NOT NULL default '0',
  status tinyint(4) NOT NULL default '0',
  timezone varchar(8) default NULL,
  language varchar(12) NOT NULL default '',
  picture varchar(255) NOT NULL DEFAULT '',
  init varchar(64) default '',
  data longtext,
  PRIMARY KEY (uid),
  UNIQUE KEY name (name),
  KEY changed (changed)
) TYPE=MyISAM;

--
-- Table structure for table 'users_roles'
--

CREATE TABLE users_roles (
  uid int(10) unsigned NOT NULL default '0',
  rid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (uid, rid)
) TYPE=MyISAM;

--
-- Table structure for table 'variable'
--

CREATE TABLE variable (
  name varchar(48) NOT NULL default '',
  value longtext NOT NULL,
  PRIMARY KEY (name)
) TYPE=MyISAM;

--
-- Table structure for table 'vocabulary'
--

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  description longtext,
  help varchar(255) NOT NULL default '',
  relations tinyint(3) unsigned NOT NULL default '0',
  hierarchy tinyint(3) unsigned NOT NULL default '0',
  multiple tinyint(3) unsigned NOT NULL default '0',
  required tinyint(3) unsigned NOT NULL default '0',
  module varchar(255) NOT NULL default '',
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY (vid)
) TYPE=MyISAM;

--
-- Table structure for table 'vocabulary_node_types'
--

CREATE TABLE vocabulary_node_types (
  vid int(10) unsigned NOT NULL DEFAULT '0',
  type varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (vid, type)
) TYPE=MyISAM;

--
-- Table structure for table 'watchdog'
--

CREATE TABLE watchdog (
  wid int(5) NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  type varchar(16) NOT NULL default '',
  message longtext NOT NULL,
  severity tinyint(3) unsigned NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  location varchar(128) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY (wid)
) TYPE=MyISAM;

--
-- Insert some default values
--

INSERT INTO system VALUES ('modules/block.module','block','module','',1,0,0);
INSERT INTO system VALUES ('modules/comment.module','comment','module','',1,0,0);
INSERT INTO system VALUES ('modules/filter.module','filter','module','',1,0,0);
INSERT INTO system VALUES ('modules/help.module','help','module','',1,0,0);
INSERT INTO system VALUES ('modules/node.module','node','module','',1,0,0);
INSERT INTO system VALUES ('modules/page.module','page','module','',1,0,0);
INSERT INTO system VALUES ('modules/story.module','story','module','',1,0,0);
INSERT INTO system VALUES ('modules/system.module','system','module','',1,0,0);
INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1,0,0);
INSERT INTO system VALUES ('modules/user.module','user','module','',1,0,0);
INSERT INTO system VALUES ('modules/watchdog.module','watchdog','module','',1,0,0);
INSERT INTO system VALUES ('themes/bluemarine/xtemplate.xtmpl','bluemarine','theme','themes/engines/xtemplate/xtemplate.engine',1,0,0);
INSERT INTO system VALUES ('themes/engines/xtemplate/xtemplate.engine','xtemplate','theme_engine','',1,0,0);
INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
INSERT INTO users_roles (uid, rid) VALUES (0, 1);

INSERT INTO role (rid, name) VALUES (1, 'anonymous user');
INSERT INTO permission VALUES (1,'access content',0);

INSERT INTO role (rid, name) VALUES (2, 'authenticated user');
INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);

REPLACE variable SET name='update_start', value='s:10:"2005-03-21";';
REPLACE variable SET name='theme_default', value='s:10:"bluemarine";';

REPLACE blocks SET module = 'user', delta = '0', status = '1';
REPLACE blocks SET module = 'user', delta = '1', status = '1';

INSERT INTO sequences (name, id) VALUES ('menu_mid', 1);

INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);

INSERT INTO filter_formats VALUES (1,'Filtered HTML',',1,2,',1);
INSERT INTO filter_formats VALUES (2,'PHP code','',0);
INSERT INTO filter_formats VALUES (3,'Full HTML','',1);
INSERT INTO filters VALUES (1,'filter',0,0);
INSERT INTO filters VALUES (1,'filter',2,1);
INSERT INTO filters VALUES (2,'filter',1,0);
INSERT INTO filters VALUES (3,'filter',2,0);
INSERT INTO variable (name,value) VALUES ('filter_html_1','i:1;');

INSERT INTO locales_meta (locale, name, enabled, isdefault) VALUES ('en', 'English', '1', '1');

Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)

Message: Can't create table '%s' (errno: %d)

dman’s picture

dman commented

Oddly enough, that listing did tell me something.
I didn't see profile_fields get created then. did you? It should have been there. (and more)

Most likely the first 2/3 of that result was just truncated.

Are you still getting the original 'table does not exist' error now?

what does SHOW TABLES give us?

http://www.coders.co.nz/

.dan. is the New Zealand Drupal Developer working on Government Web Standards

joethong’s picture

joethong commented

seems like i'm having the same problem too when i'm creating a new content.

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', 'test', 'test 2', '1', '1', '1135721283', 'page', 'test 2', '1135721380', '5')

The revision field could not be null but does not have a default value and this insert sttement doesn't specify the value for the revision field. Thus contributing the error.

Is this a bug or what? Any help would be much appreciated

Thanks
Joe

mbroome’s picture

mbroome commented

I just went to the newest release from 4.6 and had it running within minutes. apparantly there is an error in the database setup files with 4.6

skystraem1’s picture

skystraem1 commented

hello
am facing the same problem but am novice in Mysql and drupal ; would you please tell me how to fix it???

megabit’s picture

megabit commented

Field 'revisions' doesn't have a default value query

I ran into several fields that had no default value. I just set them to 'null' and those went away.

obietheone@drupal.org’s picture

obietheone@drupal.org commented

user error: 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', '1', '2', 'adfad', 'adfadfadf', '', '1', '1138955604', 'page', 'adfadfadf', '1138956362', '11') in c:\program files\apache group\Apache\htdocs\drupal\includes\database.mysql.inc on line 66.
warning: Cannot modify header information - headers already sent by (output started at c:\program files\apache group\Apache\htd

I have freshly installed drupal and got through a bunch of bugs. But it is way past my bed time and I don't the answer is coming to me anytime soon.

This happens when I try to add content to my website. I don't even have one node up so I am a little disappointed.

I tried changing some of the database values but that did not seem to help at all.

Thanks for any help in advance.
The Newb

heine’s picture

heine commented

It's my guess that you run MySQL 5 in strict mode. See solving MySQL strict mode problems.

You probably got an error already when importing the database file.

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

mbroome’s picture

mbroome commented

im sorry! :)
problem was solved by adding MYISAM tages at the end of each table...

michaeltt’s picture

michaeltt commented

I got through this one by editing the table, and setting the default for the field 'revisions' to ''
which I presume, being a newbie, is null for a text type.

drewish’s picture

drewish commented

see #76743: Incompatibilities with MySQL 5.0