https://bugzilla.wikimedia.org/show_bug.cgi?id=30383
Web browser: ---
Bug #: 30383
Summary: update.php failed to add column "rev_sha1" to table
"revision".
Product: MediaWiki
Version: 1.19-svn
Platform: PC
OS/Version: other
Status: NEW
Severity: critical
Priority: Unprioritized
Component: Database
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: b...@cht.com.tw
Classification: Unclassified
After upgrade to the head version of MediaWiki,
our server output print following message every time:
> MediaWiki internal error.
>
> Original exception: exception 'DBQueryError' with message 'A database error
> has occurred. Did you forget to run maintenance/update.php after upgrading?
> See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
> Query: SELECT
> rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,page_namespace,page_title,page_latest
> FROM "page","revision" WHERE page_id = '1' AND rev_id = '1606' AND
> (page_id=rev_page) LIMIT 1
> Function: Revision::fetchFromConds
> Error: 1 ERROR: column "rev_sha1" does not exist
> LINE 1: ...,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,p...
> ^
> ' in D:\App\mediawiki\includes\db\Database.php:874
I did run the "maintenance\update.php", but got:
> MediaWiki 1.19alpha Updater
>
> Going to run database updates for my_wiki
> Depending on the size of your database this may take a while!
> Abort with control-c in the next five seconds (skip this countdown with
> --quick)
> ... 0
> ...category table already exists.
>
> ... ommitted ...
>
> Populating rev_len column
> ...doing rev_id from 1 to 200
> A database query syntax error has occurred.
> The last attempted database query was:
> "SELECT
> rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev
> _user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1 FROM
> "revision"
> WHERE (rev_id >= 1) AND (rev_id <= 200) AND (rev_len IS NULL) "
> from within function "PopulateRevisionLength::doDBUpdates".
> Database returned error "1: ERROR: column "rev_sha1" does not exist
> LINE 1: ...,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1 ...
Our environment:
OS: Windows Server 2008 R2
Database: PostgreSQL Database Server 8.3
--
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
