Tue 16 May 2006 09:52:35 PM UTC, original submission:
+Error Reported:
ERROR 1136 (21S01) at line 459: Column count doesn't match value count at row 1
-----------------------
Relevent Code:
--
-- Table structure for table `staffprefs`
--
CREATE TABLE staffprefs (
username varchar(15) NOT NULL default '',
signature text,
display_overview tinyint(1) default '1',
refresh smallint(6) default NULL,
show_html_in_comments tinyint(1) default '0',
PRIMARY KEY (username)
) TYPE=InnoDB;
--
-- Dumping data for table `staffprefs`
--
INSERT INTO staffprefs VALUES ('root','',1,600);
-----------------------------
Diff:
Depending on the prefered default option I guess this would change. Choosing true for displaying html in comments this would be the diff.
diff ruqueuediff.sql ruqueue.sql
459c459
< INSERT INTO staffprefs VALUES ('root','',1,600);
---
> INSERT INTO staffprefs VALUES ('root','',1,600,'1');
|