sqlite中的mediawiki传输数据库

ql3eal8s  于 2023-02-19  发布在  SQLite
关注(0)|答案(1)|浏览(183)

我已经建立了新的mediawiki环境,但我得到了以下错误,而迁移sqlite数据库到新的环境。我也升级到版本的mediawiki 1.22到1.32。有没有人有任何想法的情况或新的步骤,以建立sqlite从旧的。

Turning off Content Handler DB fields for this part of upgrade.
...have ss_active_users field in site_stats table.

An error occurred:
A database query error has occurred. Did you forget to run your application's database schema 
updater after upgrading? 
Query: UPDATE  site_stats SET ss_active_users = '0' WHERE ss_row_id = '1'
Function: DatabaseUpdater::doActiveUsersInit
Error: 8 attempt to write a readonly database
Purging caches...<!DOCTYPE html>
<html><head><title>Dahili hata - MediaWiki</title><style>body { font-family: sans-serif; 
margin: 0; padding: 0.5em 2em; }</style></head><body>
<div class="errorbox mw-content-ltr"><p>[Y@YbH@8tt-A18niaaU7SwQAAANQ] /mediawiki/mw- 
config/index.php?page=Upgrade   Wikimedia\Rdbms\DBQueryError from line 1506 of 
/var/www/html/mediawiki/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? 
<br />
Query: DELETE FROM objectcache<br />
Function: DatabaseUpdater::purgeCache<br />
Error: 8 attempt to write a readonly database<br />
</p><p>Backtrace:</p><p>#0 
 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1476): 
Wikimedia\Rdbms\Database-&gt;makeQueryException(string, integer, string, string)<br />
#1 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1236): 
Wikimedia\Rdbms\Database-&gt;reportQueryError(string, integer, string, string, boolean)<br />
#2 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(2964): 
Wikimedia\Rdbms\Database-&gt;query(string, string)<br />
#3 /var/www/html/mediawiki/includes/installer/DatabaseUpdater.php(1071): 
Wikimedia\Rdbms\Database-&gt;delete(string, string, string)<br />
#4 /var/www/html/mediawiki/includes/installer/DatabaseInstaller.php(396): DatabaseUpdater- 
&gt;purgeCache()<br />
#5 /var/www/html/mediawiki/includes/installer/WebInstallerUpgrade.php(65): DatabaseInstaller- 
&gt;doUpgrade()<br />
#6 /var/www/html/mediawiki/includes/installer/WebInstaller.php(272): WebInstallerUpgrade- 
&gt;execute()<br />
#7 /var/www/html/mediawiki/mw-config/index.php(79): WebInstaller-&gt;execute(array)<br />
#8 /var/www/html/mediawiki/mw-config/index.php(38): wfInstallerMain()<br />
#9 {main}</p></div>
</body></html>
ltqd579y

ltqd579y1#

我自己解决了这个问题,我和一些想用sqlite迁移mediawiki的人分享了步骤。
我的维基百科.sqlite .转储〉备份_sqlite.sqlite
应将上述创建的文件迁移到新的sqlite位置,然后运行该命令迁移旧数据。
数据中心〈备份_数据中心.数据中心

相关问题