Hi,

since I upgraded to the current Xampp-version before I tried to upgrade mediawiki I'm pretty much up-to-date with Apache 2.4.10, php 5.5.15 and MySQL 5.6.20.

The strange thing is, when I paste this CREATE TABLE `user_properties`( up_user int not null, up_property varbinary(32) not null, up_value blob ) ENGINE=InnoDB, DEFAULT CHARSET=binary;

into the SQL-window of phpMyAdmin I also get "#1146 - Table '_fhbwiki.user_properties' doesn't exist".

But after I just dropped the table in the SQL-window, which produced yet another error message: #1051 - Unknown table '_fhbwiki.external_user' and then did the SQL-statement again - it worked. And so it did for a few more tables that followed...

I even managed to do an

ALTER TABLE `log_search` DROP PRIMARY KEY, ADD UNIQUE INDEX ls_field_val (ls_field,ls_value,ls_log_id)

by hand. And now the upgrade seems to be done...

Thanks for the help pointing me in the right direction. :-) Kate

Am 17.10.2014 um 14:35 schrieb Dave Humphrey:

I would take a guess and say the upgrade procedure is trying to create that table and fails for some reason. Are you sure you are running the minimum versions required for 1.23 (PHP 5.3.2, MySQL 5.0.2)?

Try creating that table manually by copy/pasting the CREATE TABLE into a MySQL session and see if it works or if you get an error (or if it already exists but is not accessible for some reason).

On 17 October 2014 08:19, Katharina Wolkwitz wolkwitz@fh-swf.de wrote:

...

Hi again,

before I can move my wikis to the new server I need to upgrade them to the current version (or at least it says so in every how-to I've found so far).

The wiki is currently running under version 1.16.2 and I want to get to 1.23.5

And now I'm encountering the following problems:

Creating user_properties table...Es gab einen Syntaxfehler in der Datenbankabfrage. Die letzte Datenbankabfrage lautete: âCREATE TABLE `user_properties`( up_user int not null, up_property varbinary(32) not null, up_value blob ) ENGINE=InnoDB, DEFAULT CHARSET=binary â aus der Funktion â<tt>DatabaseBase::sourceStream</tt>â. Die Datenbank meldete den Fehler: â<tt>1146: Table '_fhbwiki.user_properties' doesn't exist (localhost)</tt>â.

Any hints and tipps appreciated.

Kate

---

MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l