|
|
Thanks for your fast response!
Tried with 4.0.1+200120, same issue unfortunately.
Database says:
db_1 | 2020-01-24 12:13:45.647 UTC [397] ERROR: missing FROM-clause entry for table "answerl10ns" at character 1013
db_1 | 2020-01-24 12:13:45.647 UTC [397] STATEMENT: SELECT "t"."aid" AS "t0_c0", "t"."qid" AS "t0_c1", "t"."code" AS "t0_c2", "t"."sortorder" AS "t0_c3", "t"."assessment_value" AS "t0_c4", "t"."scale_id" AS "t0_c5", "answerL10ns"."id" AS "t1_c0", "answerL10ns"."aid" AS "t1_c1", "answerL10ns"."answer" AS "t1_c2", "answerL10ns"."language" AS "t1_c3", "question"."qid" AS "t2_c0", "question"."parent_qid" AS "t2_c1", "question"."sid" AS "t2_c2", "question"."gid" AS "t2_c3", "question"."type" AS "t2_c4", "question"."title" AS "t2_c5", "question"."preg" AS "t2_c6", "question"."other" AS "t2_c7", "question"."mandatory" AS "t2_c8", "question"."question_order" AS "t2_c9", "question"."scale_id" AS "t2_c10", "question"."same_default" AS "t2_c11", "question"."relevance" AS "t2_c12", "question"."modulename" AS "t2_c13", "question"."encrypted" AS "t2_c14" FROM "lime_answers" "t" LEFT OUTER JOIN "lime_answer_l10ns" "answerL10ns" ON ("answerL10ns"."aid"="t"."aid") LEFT OUTER JOIN "lime_questions" "question" ON (t.qid = question.qid) WHERE (question.sid={survey id} AND answerL10ns.language = 'de-informal') ORDER BY question.question_order, t.scale_id, sortorder
Please let me know if I can help further! |
|
|
The issue might be that in postgres, you have to place an "AS" before the table alias (hence, LEFT OUTER JOIN "lime_answer_l10ns" AS "answerL10ns") whereas in MySQL you can leave it out. I don't have enough insight how queries are created in LS/Yii (I'm more fluent in Django), but assuming that queries are auto-generated I wonder why this issue doesn't arise elsewhere. |
|
|
I got news, at least. My first guess was wrong; the aliasing in the query is valid also in Postgres.
What doesn't work, is the alias naming answerL10ns: In Postgres, unquoted identifiers (such as the answersL10ns in the WHERE-clause) are always folded to lowercase, wheres quoted identifiers (such as the "answerL10ns" everywhere else in the clause) are used as-is (see https://www.postgresql.org/docs/10/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS for more info, especially the last paragraph of that section).
I tried to run the query with quotes added (in application/helpers/admin/export/SurveyDao.php, line 46 on fc998ce) – works! Now I only need to know how to do this cross-DB-safely, since MySQL uses backticks instead of double quotes as table name delimiter per default, afaik (not an expert in MySQL). If you can give me a hint on how this is done in LS/Yii, I'd be happy to create a PR. |
