[Bug 33689] Upgrade to 1.18 on Postgres fails due to incomplete query when trying to defer foreign key for externallinks
https://bugzilla.wikimedia.org/show_bug.cgi?id=33689 Mark A. Hershberger m...@everybody.org changed: What|Removed |Added Priority|Unprioritized |Low CC||m...@everybody.org Target Milestone|--- |1.19.0 release -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 33689] Upgrade to 1.18 on Postgres fails due to incomplete query when trying to defer foreign key for externallinks
https://bugzilla.wikimedia.org/show_bug.cgi?id=33689 --- Comment #1 from Reedy s...@reedyboy.net 2012-01-12 20:18:06 UTC --- ThomasLocke Hey guys. Trying to update to 1.18.1 from 1.15.5 but am getting stuck at the database error: A database query syntax error has occurred. The last attempted database query was: ALTER TABLE externallinks DROP CONSTRAINT . Reedy ThomasLocke, do you get a message the line before saying Altering column ... Reedy If so, can you paste the whole line? Reedy I can see where iit's seemingly happening ThomasLocke Altering column 'externallinks.el_from' to be DEFERRABLE INITIALLY DEFERRED ThomasLocke ALTER /* */ TABLE externallinks DROP CONSTRAINT Reedy the offending line is (in trunk at least) line 513 of includes/installer/PostgresUpdater.php Reedy it unconditionally used $fi-conname() no matter it's value -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 33689] Upgrade to 1.18 on Postgres fails due to incomplete query when trying to defer foreign key for externallinks
https://bugzilla.wikimedia.org/show_bug.cgi?id=33689 --- Comment #2 from Reedy s...@reedyboy.net 2012-01-12 20:53:43 UTC --- Getting the user to do: SELECT attnotnull, attlen, COALESCE(conname, '') AS conname, COALESCE(condeferred, 'f') AS deferred, COALESCE(condeferrable, 'f') AS deferrable, CASE WHEN typname = 'int2' THEN 'smallint' WHEN typname = 'int4' THEN 'integer' WHEN typname = 'int8' THEN 'bigint' WHEN typname = 'bpchar' THEN 'char' ELSE typname END AS typname FROM pg_class c JOIN pg_namespace n ON (n.oid = c.relnamespace) JOIN pg_attribute a ON (a.attrelid = c.oid) JOIN pg_type t ON (t.oid = a.atttypid) LEFT JOIN pg_constraint o ON (o.conrelid = c.oid AND a.attnum = ANY(o.conkey) AND o.contype = 'f') WHERE relkind = 'r' AND nspname='mediawiki' AND relname='externallinks' AND attname='elfrom'; via sql.php gave Query OK, 0 row(s)... -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l