Topic on Project:Support desk

Hi, I'm trying to upgrade my MediaWiki from 1.38 to 1.39. My MW instance is running on Docker.  

However I have a display error when I connect.

There is currently no text on this page. You can launch a search on this title in the other pages, search in related operations or create this page.

[9db9b7555e94f2b21245627f] /index.php?title=Accueil&action=edit Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'dowiki.linktarget' doesn't exist

Function: MediaWiki\Linker\LinkTargetStore::getLinkTargetIdFromCache

Query: SELECT lt_id,lt_namespace,lt_title FROM `linktarget` WHERE lt_namespace = 0 AND lt_title = 'Accueil' LIMIT 1

Same error when editing a page.

I tried to update my DB by running the php script update.php. But I still get the same SQL errors

#0 /var/www/html/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException('Can't DROP INDE...', 1091, 'ALTER TABLE `re...', 'Wikimedia\\Rdbms...')

#1 /var/www/html/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Can't DROP INDE...', 1091, 'ALTER TABLE `re...', 'Wikimedia\\Rdbms...')

#2 /var/www/html/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError('Can't DROP INDE...', 1091, 'ALTER TABLE `re...', 'Wikimedia\\Rdbms...', false)

#3 /var/www/html/includes/libs/rdbms/database/Database.php(3302): Wikimedia\Rdbms\Database->query('ALTER TABLE `re...', 'Wikimedia\\Rdbms...')

#4 /var/www/html/includes/libs/rdbms/database/Database.php(3241): Wikimedia\Rdbms\Database->sourceStream(Resource id #906, NULL, NULL, 'Wikimedia\\Rdbms...', NULL)

#5 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->sourceFile('/var/www/html/m...')

#6 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(807): Wikimedia\Rdbms\DBConnRef->__call('sourceFile', Array)

#7 /var/www/html/includes/installer/DatabaseUpdater.php(718): Wikimedia\Rdbms\DBConnRef->sourceFile('/var/www/html/m...')

#8 /var/www/html/includes/installer/DatabaseUpdater.php(843): DatabaseUpdater->applyPatch('/var/www/html/m...', false, 'Table revision ...')

#9 /var/www/html/includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->dropField('revision', 'rev_text_id', 'patch-revision-...')

#10 /var/www/html/includes/installer/DatabaseUpdater.php(511): DatabaseUpdater->runUpdates(Array, false)

#11 /var/www/html/maintenance/update.php(202): DatabaseUpdater->doUpdates(Array)

#12 /var/www/html/maintenance/includes/MaintenanceRunner.php(309): UpdateMediaWiki->execute()

#13 /var/www/html/maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run()

#14 /var/www/html/maintenance/update.php(312): require_once('/var/www/html/m...')

#15 {main}

If someone can help me.

see Manual:Upgrading

I followed the tutorial adapted to my case. I have MW version 1.39.3 with PHP version 7.4.33, a DB MariaDB 10.5.19 and a Memcached 1.6, running on Docker. That's three containers.

I've made my DB backup, I've got all my extensions in wfwfLoadExtension in my LocalSettings.php.

But when I do a php update.php I get these errors:

#0 /var/www/html/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException('Can't DROP INDIA...', 1091, 'ALTER TABLE `re...', 'Wikimedia\Rdbms...')

#1 /var/www/html/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Can't DROP INDIA...', 1091, 'ALTER TABLE `re...', 'Wikimedia\Rdbms...')

#2 /var/www/html/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError('Can't DROP INDIA...', 1091, 'ALTER TABLE `re...', 'Wikimedia\Rdbms...', false)

#3 /var/www/html/includes/libs/rdbms/database/Database.php(3302): Wikimedia\Rdbms\Database->query('ALTER TABLE `re...', 'Wikimedia\Rdbms...')

#4 /var/www/html/includes/libs/rdbms/database/Database.php(3241): Wikimedia\Rdbms\Database->sourceStream(Resource id #839, NULL, NULL, 'Wikimedia\Rdbms...', NULL)

#5 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->sourceFile('/var/www/html/m...')

#6 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(807): Wikimedia\Rdbms\DBConnRef->__call('sourceFile', Array)

#7 /var/www/html/includes/installer/DatabaseUpdater.php(718): Wikimedia\Rdbms\DBConnRef->sourceFile('/var/www/html/m...')

#8 /var/www/html/includes/installer/DatabaseUpdater.php(843): DatabaseUpdater->applyPatch('/var/www/html/m...', false, 'Table revision ...')

#9 /var/www/html/includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->dropField('revision', 'rev_text_id', 'patch-revision-...')

#10 /var/www/html/includes/installer/DatabaseUpdater.php(511): DatabaseUpdater->runUpdates(Array, false)

#11 /var/www/html/maintenance/update.php(202): DatabaseUpdater->doUpdates(Array)

#12 /var/www/html/maintenance/includes/MaintenanceRunner.php(309): UpdateMediaWiki->execute()

#13 /var/www/html/maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run()

#14 /var/www/html/maintenance/update.php(312): require_once('/var/www/html/m...')

#15 {main}

I tried with the URL access localhost:8080/mw-config/ but when I get to the step 'Upgrade existing installation' i got this error

An error occurred:

Error 1091: Can't DROP INDEX `user_timestamp`; check that it exists

Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/html/maintenance/archives/patch-revision-actor-comment-MCR.sql )