Tiny Tiny RSS: Community

Table 'tinyrss.ttrss_version' doesn't exist in engine


#1

Hi

I am trying to move tt-rss install from one pc to another

Original install on Debian Wheezy

New Install is on Debian testing

I cloned a new git copy to the new pc. Then I moved my mysql database to the new pc. I also tried importing the mysql dump of tt-rss into a new database.

But I am hitting this error that I do not understand. Even a fresh install without any database seems to give this error.

I am able to do a fresh install but this is the error I get when I try to access athe regular url after the installation.

https://paste.debian.net/hidden/a346252d/

Am I missing a package or something?>


#2

Inlining log output because having to visit another site is a pain and unsearchable:

[Mon Mar 05 22:43:17.945975 2018] [php7:warn] [pid 16750] [client 192.168.5.113:53332] PHP Warning:  PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'tinyrss.ttrss_version' doesn't exist in engine in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:17.945999 2018] [php7:error] [pid 16750] [client 192.168.5.113:53332] PHP Fatal error:  Uncaught Error: Call to a member function fetch() on boolean in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php:983\nStack trace:\n#0 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#1 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#2 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/errorhandler.php(43): Logger->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#3 [internal function]: ttrss_error_handler(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#4 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php(983): PDO->query('SELECT schema_v...')\n#5 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#6 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(1, 'Uncaught Error:...', 'include/functio...', 983, ' in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:18.948542 2018] [php7:warn] [pid 16755] [client 192.168.5.113:53334] PHP Warning:  PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'tinyrss.ttrss_version' doesn't exist in engine in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:18.948585 2018] [php7:error] [pid 16755] [client 192.168.5.113:53334] PHP Fatal error:  Uncaught Error: Call to a member function fetch() on boolean in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php:983\nStack trace:\n#0 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#1 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#2 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/errorhandler.php(43): Logger->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#3 [internal function]: ttrss_error_handler(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#4 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php(983): PDO->query('SELECT schema_v...')\n#5 /media/SYSLINX/var/www_XXXX/tinyrss_II/plugins/auth_internal/init.php(27): get_schema_version()\n#6 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php(677): Auth_Internal->authenticate(NULL, NULL)\n#7 /media/SYSLINX/var/ in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:18.948934 2018] [php7:warn] [pid 16755] [client 192.168.5.113:53334] PHP Warning:  PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'tinyrss.ttrss_version' doesn't exist in engine in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:18.948958 2018] [php7:error] [pid 16755] [client 192.168.5.113:53334] PHP Fatal error:  Uncaught Error: Call to a member function fetch() on boolean in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php:983\nStack trace:\n#0 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#1 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#2 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/errorhandler.php(43): Logger->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#3 [internal function]: ttrss_error_handler(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#4 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php(983): PDO->query('SELECT schema_v...')\n#5 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#6 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(1, 'Uncaught Error:...', 'include/functio...', 983, ' in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:40.414313 2018] [php7:warn] [pid 16760] [client 192.168.5.113:53384] PHP Warning:  PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'tinyrss.ttrss_version' doesn't exist in engine in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:40.414366 2018] [php7:error] [pid 16760] [client 192.168.5.113:53384] PHP Fatal error:  Uncaught Error: Call to a member function fetch() on boolean in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php:983\nStack trace:\n#0 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#1 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#2 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/errorhandler.php(43): Logger->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#3 [internal function]: ttrss_error_handler(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#4 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php(983): PDO->query('SELECT schema_v...')\n#5 /media/SYSLINX/var/www_XXXX/tinyrss_II/plugins/auth_internal/init.php(27): get_schema_version()\n#6 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php(677): Auth_Internal->authenticate(NULL, NULL)\n#7 /media/SYSLINX/var/ in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:40.414615 2018] [php7:warn] [pid 16760] [client 192.168.5.113:53384] PHP Warning:  PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'tinyrss.ttrss_version' doesn't exist in engine in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983
[Mon Mar 05 22:43:40.414649 2018] [php7:error] [pid 16760] [client 192.168.5.113:53384] PHP Fatal error:  Uncaught Error: Call to a member function fetch() on boolean in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php:983\nStack trace:\n#0 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#1 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#2 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/errorhandler.php(43): Logger->log_error(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#3 [internal function]: ttrss_error_handler(2, 'PDO::query(): S...', 'include/functio...', 983, '1. include/func...')\n#4 /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php(983): PDO->query('SELECT schema_v...')\n#5 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger/sql.php(8): get_schema_version()\n#6 /media/SYSLINX/var/www_XXXX/tinyrss_II/classes/logger.php(28): Logger_SQL->log_error(1, 'Uncaught Error:...', 'include/functio...', 983, ' in /media/SYSLINX/var/www_XXXX/tinyrss_II/include/functions.php on line 983

#3

well, you either didn’t migrate the database or database settings in confiig.php are incorrect
even on fresh install you still need the actual schema in the database, either done by installer or manually

try logging via mysql command line or some other administrative UI and check if the tables are actually there


#4

Well, I am %100 sure that the database settings are correct and the database stuff is migrated. I did the exact same thing with Ampache(which also uses Mysql) and it worked fine). infact I even tried with copying the original config file and also the installation.

The only difference I can see is that Tt-rss on wheezy was using Mysql5.5 and Mysql on Testing is Mariadb so not sure if that is an actual issue regarding tt-rss migration.

Based on your input, I will start from scratch and try step by step one more time.

thanks for your help


#5

Well the error message indicates that either the software isn’t talking to the right migrated database, or the migrated database is missing a table with a single column and single row which implies that the migration is incomplete.

To repeat a suggestion:

Which should look something like:

-bash-4.1$ mysql -uttrss -p$TTRSSPASS ttrss -e "select * from ttrss_version"
+----------------+
| schema_version |
+----------------+
|            133 |
+----------------+
-bash-4.1$ 
-bash-4.1$ mysql -uttrss -p$TTRSSPASS information_schema -e "select TABLE_NAME from TABLES where TABLE_SCHEMA='ttrss'"
+---------------------------------------+
| TABLE_NAME                            |
+---------------------------------------+
| ttrss_access_keys                     |
| ttrss_archived_feeds                  |
| ttrss_cat_counters_cache              |
| ttrss_counters_cache                  |
| ttrss_enclosures                      |
| ttrss_entries                         |
| ttrss_entry_comments                  |
| ttrss_error_log                       |
| ttrss_feed_categories                 |
| ttrss_feedbrowser_cache               |
| ttrss_feeds                           |
| ttrss_filter_actions                  |
| ttrss_filter_types                    |
| ttrss_filters                         |
| ttrss_filters2                        |
| ttrss_filters2_actions                |
| ttrss_filters2_rules                  |
| ttrss_labels2                         |
| ttrss_linked_feeds                    |
| ttrss_linked_instances                |
| ttrss_plugin_af_sort_bayes_categories |
| ttrss_plugin_af_sort_bayes_references |
| ttrss_plugin_af_sort_bayes_wordfreqs  |
| ttrss_plugin_storage                  |
| ttrss_prefs                           |
| ttrss_prefs_sections                  |
| ttrss_prefs_types                     |
| ttrss_sessions                        |
| ttrss_settings_profiles               |
| ttrss_tags                            |
| ttrss_user_entries                    |
| ttrss_user_labels2                    |
| ttrss_user_prefs                      |
| ttrss_users                           |
| ttrss_version                         |
+---------------------------------------+
-bash-4.1$ 

#6

Thank you so much. I am just a user, I do not have deep understading of Mysql etc stuff. So your reply is very very helpful. I will try it

thanks