search

NAL-i5K / tripal_eutils

ncbi loader via the eutils interface
GNU General Public License v3.0
4 stars 3 forks source link

Undefined table: arraydesign #221

Closed Ferrisx4 closed 4 years ago

Ferrisx4 commented 4 years ago

When executing an import job via Drush, the transaction fails with the following error:

WD tripal_chado: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "arraydesign" does not exist                                                                                                                                             [error]
LINE 1:            SELECT platformtype_id           FROM  arraydesig...
                                                          ^:            SELECT platformtype_id           FROM { arraydesign}           GROUP BY platformtype_id         ; Array
(
)
 in chado_query() (line 1790 of /Library/WebServer/Documents/sites/all/modules/Custom/tripal/tripal_chado/api/tripal_chado.query.api.inc).

The arraydesign table does exist in the database but the function appears to not be appending the schema to the tablename: SELECT platformtype_id FROM { arraydesign} GROUP BY platformtype_id

almasaeed2010 commented 4 years ago

Do you see the space in { arraydesign}? The one just after the bracket. That's the issue.

almasaeed2010 commented 4 years ago

Wait I think we fixed this issue on the main tripal. Try upgrading tripal to the latest master first.

Ferrisx4 commented 4 years ago

Ah OK thanks, @almasaeed2010, that seemed to have worked. Apparently I need another pair of eyes.

almasaeed2010 commented 4 years ago

This issue actually has been bother a lot of people. It might need addressing in Tripal itself since it implements the interpreter. Maybe we could suggest at least documenting that this is a common issue.