https://bugzilla.wikimedia.org/show_bug.cgi?id=17026

           Summary: Update of MW 1.11 to MW 1.13 on postgresql: missing
                    rev_parent_id
           Product: MediaWiki
           Version: 1.13.3
          Platform: All
        OS/Version: All
            Status: NEW
          Keywords: postgresql
          Severity: critical
          Priority: Normal
         Component: Maintenance scripts
        AssignedTo: [email protected]
        ReportedBy: [email protected]


When I update my MW running on a postgresql database (on Linux, but I guess
that does not matter) from 1.11 to 1.13, the update script does not report
errors, but any attempt to open a page in MW 1.13 leads to errors because the
column revision.rev_parent_id is missing.

Indeed, the scripts for mysql include a statement adding this column but those
for postgres don't. I guess the right statement for postgres is

alter table revision add rev_parent_id integer;

but I'm not sure about the exact datatype. And I don't know where to insert
this in the update scripts.

I executed this manually, and everything appears to work fine.

I'm wondering whether the update has ever been tested on postgresql, since it
seems impossible that this bug is not detected. Is this due to a lack of
testers in the postgresql area?


-- 
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to