throw the phpexception, any ways to solve it?

tripal / chado_search

Mainlab Chado Search: enabling advanced search function for a Tripal/Chado database

2 stars 0 forks source link

throw the phpexception, any ways to solve it? #1

Closed a2htray closed 7 years ago

a2htray commented 7 years ago

PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "chado.chado_search_sequence_search" does not exist LINE 1: SELECT distinct organism FROM chado.chado_search_sequence_se... ^: SELECT distinct organism FROM chado.chado_search_sequence_search ORDER BY organism; Array ( ) in chado_query() (line 1538 of /var/www/html/sites/all/modules/tripal/tripal_core/api/tripal_core.chado_query.api.inc).

chunhuaicheng commented 7 years ago

It looks like you enabled the sequence search but removed the required materialized view. You can use 'drush' to recreate it:

cd drush csreload

This will recreate the missing materialized views defined in your 'chado_search/file/settings.conf'. You can then go to 'Tripal' > 'Chado Schema' > 'Materialized Views' to repopulate it using Tripal's job system.

a2htray commented 7 years ago

thanks a lot, it run well

chunhuaicheng commented 7 years ago

No problem. Glad to help. I'm going to close this thread but feel free to open new ones if you have more questions or feature requests.