Describe the problem you’re having:
Since my upgrade to ttrss version efae0858183d1d71604ff3c9882c8e30dba3b336 the system is missing the table ttrss.ttrss_user_labels2. I can’t remember which version I had before :-/ But it was working before.
I checked my existing tables and yes this specific table is missing. I have this tables:
---------------------------------------+
| Tables_in_ttrss |
±--------------------------------------+
| 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_prefs |
| ttrss_users |
| ttrss_version |
±--------------------------------------+
I gathered the information about the missing table via prefs.php -> system:
“SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ttrss.ttrss_user_labels2’ doesn’t exist”
ttrss is not asking if it should update the db schema after login. It just hangs at 80% and the browser console informs me about a http 500 error.
Also
./update.php --update-schema
gives me:
[16:38:46/11114] Lock: update.lock
[16:38:46/11114] checking for updates (mysql)…
[16:38:46/11114] update not required.
Could you tell me if this table is needed in the current version and maybe someone has a clue how to recreate the table if needed? thx
…
tt-rss version (including git commit id):
efae0858183d1d71604ff3c9882c8e30dba3b336
…
Platform (i.e. Linux distro, PHP, PostgreSQL, etc) versions:
Debian Jessie
PHP 5.6.38-0+deb8u1
mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3
…