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 <[email protected]> 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 >> > > > -- Mit freundlichen Grüßen Katharina Wolkwitz Fachhochschule Südwestfalen Hochschulbibliothek Haldener Straße 182 58095 Hagen Tel.: 02331/9330-607 FAX: 02331/9330-608 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
