[Pkg-mediawiki-devel] Bug#706869: squeeze -> wheezy upgrade does not work

[Richard Kettlewell]

On 2013-05-05 20:51, Jonathan Wiltshire wrote:
> On Sun, May 05, 2013 at 05:42:46PM +0100, Richard Kettlewell wrote:
>> After upgrading to wheezy all pages display the following:
>>
>> A database error has occurred. Did you forget to run
>> maintenance/update.php after upgrading? See:
>> https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
>> Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND
>> lc_key = 'deps' LIMIT 1
>> Function: LCStore_DB::get
>> Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost)
>>
>> update.php does not work:
>> Creating user_properties table...A database query syntax error has
>> occurred.
>> The last attempted database query was:
>> "CREATE TABLE `user_properties`(
>>   up_user int not null,
>>   up_property varbinary(32) not null,
>>   up_value blob
>>   ) ENGINE=InnoDB, DEFAULT CHARSET=binary
>> "
>> from within function "DatabaseBase::sourceFile(
>> /usr/share/mediawiki/maintenance/archives/patch-user_properties.sql
>> )".
>> Database returned error "1142: CREATE command denied to user
>> 'wikiuser'@'localhost' for table 'user_properties' (localhost)"
>>
>> The update should be run automatically, and it should succeed (for
>> instance by granting the wikiuser create/index/alter on wikidb, or
>> by running the update as a more powerful database user).
>
> Both these symptoms are expected and documented in NEWS.Debian, and
> displayed during upgrade if you have apt-listchanges installed. Please
> follow the steps in that file.

Perhaps it should be mentioned in the wheezy release notes (i.e. s4.5)?

> An automatic upgrade is not feasible for installations carried forward
> from before Squeeze.

This installation was first installed under squeeze.

ttfn/rjk