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

 
 

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

Submitter:  None
Submitted:  Tue 16 May 2006 09:52:35 PM UTC
   
 
Category:  None Severity:  3 - Normal
Item Group:  None Status:  None
Privacy:  Public Assigned to:  None
Open/Closed:  Open
* Mandatory Fields

Add a New Comment Rich Markup
   

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



Anonymous

 

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

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

Only logged-in users can vote.

 

No changes have been made to this item

Back to the top

Powered by Savane 3.13-d3ae.
Corresponding source code