Thread:Project:Support desk/Error: 1054 and more

I run me wiki since years in december I made an update to 1.9.23. PHP Version 5.5.8 MySQL 5.5

In the last days there were errors (can't upload pictures etc.) and now nothing works:

"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 `kinowiki_l10n_cache` WHERE lc_lang = 'de' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get" Error: 1054 Unknown column 'lc_lang' in 'where clause' (localhost)

I didn't forget the update because I din't cahnce the mediawiki version

So I try to make an update but it doens't work. Here the error:

...have ipb_id field in ipblocks table. ...have ipb_expiry field in ipblocks table. ...already have interwiki table ...indexes seem up to 20031107 standards. ...hitcounter table already exists. ...have rc_type field in recentchanges table. ...have user_real_name field in user table. ...querycache table already exists. ...objectcache table already exists. ...categorylinks table already exists. ...have pagelinks; skipping old links table updates ...il_from OK ...have rc_ip field in recentchanges table. ...index PRIMARY already set on image table. ...have rc_id field in recentchanges table. ...have rc_patrolled field in recentchanges table. ...logging table already exists. ...have user_token field in user table. ...have wl_notificationtimestamp field in watchlist table. ...watchlist talk page rows already present. ...user table does not contain user_emailauthenticationtimestamp field. ...page table already exists. ...have log_params field in logging table. ...logging table has correct log_title encoding. ...have ar_rev_id field in archive table. ...have page_len field in page table. ...revision table does not contain inverse_timestamp field. ...have rev_text_id field in revision table. ...have rev_deleted field in revision table. ...have img_width field in image table. ...have img_metadata field in image table. ...have user_email_token field in user table. ...have ar_text_id field in archive table. ...page_namespace is already a full int (int(11)). ...ar_namespace is already a full int (int(11)). ...rc_namespace is already a full int (int(11)). ...wl_namespace is already a full int (int(11)). ...qc_namespace is already a full int (int(11)). ...log_namespace is already a full int (int(11)). ...have img_media_type field in image table. ...already have pagelinks table. ...image table does not contain img_type field. ...already have unique user_name index. ...user_groups table exists and is in current format. Adding ss_total_pages field to table site_stats...

An error occured: Es gab einen Syntaxfehler in der Datenbankabfrage. Die letzte Datenbankabfrage lautete: „ALTER TABLE `kinowiki_site_stats` ADD ss_total_pages bigint default -1, ADD ss_users bigint default -1, ADD ss_admins int default -1 “ aus der Funktion „DatabaseBase::sourceFile( /users/kinowiki/www/wiki/maintenance/archives/patch-ss_total_articles.sql )“. Die Datenbank meldete den Fehler: „1060: Duplicate column name 'ss_admins' (localhost)“. Backtrace:


 * 1) 0 /users/kinowiki/www/wiki/includes/db/Database.php(885): DatabaseBase->reportQueryError('Duplicate colum...', 1060, 'ALTER TABLE `ki...', 'DatabaseBase::s...', false)


 * 1) 1 /users/kinowiki/www/wiki/includes/db/Database.php(3193): DatabaseBase->query('ALTER TABLE `ki...', 'DatabaseBase::s...')


 * 1) 2 /users/kinowiki/www/wiki/includes/db/Database.php(3105): DatabaseBase->sourceStream(Resource id #152, false, false, 'DatabaseBase::s...')


 * 1) 3 /users/kinowiki/www/wiki/includes/installer/DatabaseUpdater.php(420): DatabaseBase->sourceFile('/users/kinowiki...')


 * 1) 4 /users/kinowiki/www/wiki/includes/installer/DatabaseUpdater.php(454): DatabaseUpdater->applyPatch('patch-ss_total_...', false)


 * 1) 5 [internal function]: DatabaseUpdater->addField('site_stats', 'ss_total_pages', 'patch-ss_total_...')


 * 1) 6 /users/kinowiki/www/wiki/includes/installer/DatabaseUpdater.php(281): call_user_func_array(Array, Array)


 * 1) 7 /users/kinowiki/www/wiki/includes/installer/DatabaseUpdater.php(244): DatabaseUpdater->runUpdates(Array, false)


 * 1) 8 /users/kinowiki/www/wiki/includes/installer/DatabaseInstaller.php(257): DatabaseUpdater->doUpdates


 * 1) 9 /users/kinowiki/www/wiki/includes/installer/WebInstallerPage.php(525): DatabaseInstaller->doUpgrade


 * 1) 10 /users/kinowiki/www/wiki/includes/installer/WebInstaller.php(254): WebInstaller_Upgrade->execute


 * 1) 11 /users/kinowiki/www/wiki/mw-config/index.php(50): WebInstaller->execute(Array)


 * 1) 12 /users/kinowiki/www/wiki/mw-config/index.php(18): wfInstallerMain


 * 1) 13 {main}