bugruQueue - Bugs: bug #16607, Missing field in ruqueue.sql...


bug #16607: Missing field in ruqueue.sql prevents import

Submitted by:  None
Submitted on:  Tue 16 May 2006 09:52:35 PM UTC  
Category: NoneSeverity: 3 - Normal
Item Group: NoneStatus: None
Privacy: PublicAssigned to: None
Open/Closed: Open

Add a New Comment(Rich Markup)

You are not logged in

Please log in, so followups can be emailed to you.


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


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
< INSERT INTO staffprefs VALUES ('root','',1,600);

> INSERT INTO staffprefs VALUES ('root','',1,600,'1');



(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.


Please enter the title of George Orwell's famous dystopian book (it's a date):



No Changes Have Been Made to This Item

Back to the top

Powered by Savane 3.1-cleanup1