https://bugzilla.wikimedia.org/show_bug.cgi?id=71022
--- Comment #3 from Bill Traynor <[email protected]> --- (In reply to Bill Traynor from comment #2) > (In reply to Andre Klapper from comment #1) > > Thanks for taking the time to report this! > > > > Is this a fresh installation, or on an existing database / upgrade? > > Which Oracle version is this? I assume this is MediaWiki git master? > > Hi Andre, > > Yes, this is a fresh installation of MediaWiki git master. I will find out > the Oracle version tomorrow for you. > > In my investigation, it would appear that in > ../maintenance/oracle/tables.sql the there are 14 columns defined in the > Page table, but immediately following the definition the insert statement > only contains 13 values. I think one of the timestamp values is missing. Here's the code I was referring to: CREATE SEQUENCE page_page_id_seq; CREATE TABLE &mw_prefix.page ( page_id NUMBER NOT NULL, page_namespace NUMBER DEFAULT 0 NOT NULL, page_title VARCHAR2(255) NOT NULL, page_restrictions VARCHAR2(255), page_counter NUMBER DEFAULT 0 NOT NULL, page_is_redirect CHAR(1) DEFAULT '0' NOT NULL, page_is_new CHAR(1) DEFAULT '0' NOT NULL, page_random NUMBER(15,14) NOT NULL, page_touched TIMESTAMP(6) WITH TIME ZONE, page_links_updated TIMESTAMP(6) WITH TIME ZONE, page_latest NUMBER DEFAULT 0 NOT NULL, -- FK? page_len NUMBER DEFAULT 0 NOT NULL, page_content_model VARCHAR2(32), page_lang VARCHAR2(35) DEFAULT NULL ); ALTER TABLE &mw_prefix.page ADD CONSTRAINT &mw_prefix.page_pk PRIMARY KEY (page_id); CREATE UNIQUE INDEX &mw_prefix.page_u01 ON &mw_prefix.page (page_namespace,page_title); CREATE INDEX &mw_prefix.page_i01 ON &mw_prefix.page (page_random); CREATE INDEX &mw_prefix.page_i02 ON &mw_prefix.page (page_len); CREATE INDEX &mw_prefix.page_i03 ON &mw_prefix.page (page_is_redirect, page_namespace, page_len); -- Create a dummy page to satisfy fk contraints especially with revisions INSERT INTO &mw_prefix.page VALUES (0, 0, ' ', NULL, 0, 0, 0, 0, current_timestamp, NULL, 0, 0, NULL); I see 14 columns defined, but only 13 values being passed. How can this ever work? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
