chunhuaicheng
commented
5 years ago Hi,
It looks like the table 'chado_search_qualitative_traits' was not created when you enabled the module. If you make any change to your 'setting.conf' after installing the module, you need to clear the chado_search cache. You can use 'drush' for this purpose:
drush csreload
This command will pick up changes in the setting.conf and recreate tables that are missing.
Let me know if this does not solve your problem.
Dear all, I installed chado_search by using process below.
git clone https://gitlab.com/mainlabwsu/chado_search.git cp cottongen.settings.txt settings.conf drush pm-enable chado_search
However, when I entered search page (http://localhost/find/qualitative_traits), error message was shown below.
Unable to create SelectFilter form element. Please check your settings. SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "chado_search_qualitative_traits" does not exist LINE 1: ...lic, chado; SELECT distinct trait_descriptor FROM chado_sear... ^ Unable to bind DynamicSelectFilter form element. Please check your SQL statement in the AJAX callback. SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "chado_search_qualitative_traits" does not exist LINE 1: ..., public, chado; SELECT distinct trait_value FROM chado_sear... ^ Unable to create SelectFilter form element. Please check your settings. SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "chado_search_qualitative_traits" does not exist LINE 1: ...lic, chado; SELECT distinct trait_descriptor FROM chado_sear... ^ Unable to bind DynamicSelectFilter form element. Please check your SQL statement in the AJAX callback. SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "chado_search_qualitative_traits" does not exist LINE 1: ..., public, chado; SELECT distinct trait_value FROM chado_sear... ^ Unable to create SelectFilter form element. Please check your settings. SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "chado_search_qualitative_traits" does not exist LINE 1: ...lic, chado; SELECT distinct trait_descriptor FROM chado_sear... ^ Unable to bind DynamicSelectFilter form element. Please check your SQL statement in the AJAX callback. SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "chado_search_qualitative_traits" does not exist LINE 1: ..., public, chado; SELECT distinct trait_value FROM chado_sear... ^
Is there any to solve this error?
Best,