Hello
I am new to the list
I am trying to upgrade my mediawiki installation from 1.31.7 to 1.34.1 and I am getting errors when executing php update.php. Same thing happened when trying to upgrade to 1.33.3 I have seen bug reports dating back to 2016. Last suggestion being to move such things to the public schema instead of the database schema. Is this safe/good idea? What other solution can I apply?
----------- Example of output -------------------- MediaWiki 1.34.1 Updater
Your composer.lock file is up to date with current dependencies! Going to run database updates for mypedia-default- Depending on the size of your database this may take a while! ...skipping: 'mwuser' table doesn't exist yet. ...skipping: 'mwuser' table doesn't exist yet. ...skipping: 'pagecontent' table doesn't exist yet. Creating sequence logging_log_id_seq Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/html/mypedia/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: CREATE SEQUENCE logging_log_id_seq Function: Wikimedia\Rdbms\DBConnRef::query Error: 42P07 ERROR: relation "logging_log_id_seq" already exists
#0 /var/www/html/mypedia/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('ERROR: relatio...', '42P07', 'CREATE SEQUENCE...', 'Wikimedia\Rdbms...') #1 /var/www/html/mypedia/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError('ERROR: relatio...', '42P07', 'CREATE SEQUENCE...', 'Wikimedia\Rdbms...', false) #2 /var/www/html/mypedia/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->query('CREATE SEQUENCE...', 'Wikimedia\Rdbms...', 0) #3 /var/www/html/mypedia/includes/libs/rdbms/database/DBConnRef.php(292): Wikimedia\Rdbms\DBConnRef->__call('query', Array) #4 /var/www/html/mypedia/includes/installer/PostgresUpdater.php(833): Wikimedia\Rdbms\DBConnRef->query('CREATE SEQUENCE...') #5 /var/www/html/mypedia/includes/installer/DatabaseUpdater.php(490): PostgresUpdater->addSequence('logging', false, 'logging_log_id_...') #6 /var/www/html/mypedia/includes/installer/DatabaseUpdater.php(454): DatabaseUpdater->runUpdates(Array, false) #7 /var/www/html/mypedia/maintenance/update.php(205): DatabaseUpdater->doUpdates(Array) #8 /var/www/html/mypedia/maintenance/doMaintenance.php(99): UpdateMediaWiki->execute() #9 /var/www/html/mypedia/maintenance/update.php(277): require_once('/var/www/html/s...') #10 {main}
---------------------------------------------------------
Thankyou