Colin Girard created the topic: _xtdir_final_categorypromoted_view' doesn't exist
xtdir for SP
whenever i try to update an entry position, I get this error.
Extly Log: Table 'ehcanada_2015b.j17_xtdir_final_categorypromoted_view' doesn't exist
Then the entry displays no promotion error.
Please explain how to fix. I have tried reinstalling xtdir and that makes all entries have no promotion.
The database is indeed missing that table view. As I have a second install that contains it. But I cannot export that database either.
Support Team replied the topic: _xtdir_final_categorypromoted_view' doesn't exist
Views are created by XTDir for SobiPro when it is initially installed. If you have migrated from server, they might not be copied. If views are not created in your database, you can recreate them with any of the following methods:
In the latest XTDir for SobiPro 5.6, you can click on "XTDir for SobiPro: Promoted Entries Configuration" / "Recreate Views"
In phpMyAdmin, you can execute views.sql script to manually recreate them (File: administrator/components/com_xtdir/sql/install/mysql/views.sql)
Uninstall and install again XTDir for SobiPro, installer creates all views. Otherwise, a database configuration problem may be present. This method also resets all previous configuration.
Please let us know if you have any further questions.