Planning to migrate from mysql to pgsql. But using the plug-in data_migration to import errors,
Most of my ttrss are in Chinese,
File export is no problem: nginx+php7.4+mysql5.7
[Execute export command]:
php /ttrss/update.php --data_user admin --data_export /opt/cc.zip
Completed normally
I tried two more ways to import but failed.
The first method: nginx+php7.4+pgsql11:
Error message:
postgres@VM-8-8-debian:/root$ php /ttrss2/update.php --data_user admin --data_import /opt/cc.zip
[10:33:31/10796] Lock: update.lock
[10:33:31/10796] importing articles of user admin from /opt/cc.zip…
[10:33:31/10796] processing 00000000.json
PHP Fatal error: Uncaught Error: Class’Config’ not found in /ttrss2/plugins.local/data_migration/init.php:370
Stack trace:
#0 /ttrss2/plugins.local/data_migration/init.php(67): Data_Migration->import_article_batch()
#1 /ttrss2/classes/pluginhost.php(350): Data_Migration->data_import()
#2 /ttrss2/update.php(508): PluginHost->run_commands()
#3 {main}
thrown in /ttrss2/plugins.local/data_migration/init.php on line 370
The second method: the official docker-compose.yml
Error prompt:
docker-compose exec --user app app php8 /var/www/html/tt-rss/update.php --data_user admin --data_import /tmp/cc.zip
[10:08:30/65] Lock: update.lock
[10:08:30/65] importing articles of user admin from /tmp/cc.zip…
[10:08:30/65] processing 00000000.json
[10:08:30/65] batch has incorrect schema format version (expected: 145, got: 139
[10:08:30/65] processing 00000001.json
[10:08:30/65] batch has incorrect schema format version (expected: 145, got: 139.
[10:08:31/65] imported 0 (out of 0) articles, created 0 feeds.
What should I do now. As long as it can solve one of the import methods. thanks
Or tell me how to migrate from mysql to pgsql