Error messages about cottongen.settings.txt

[EugeneKim76]

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,

[chunhuaicheng]

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.