View Revisions: Issue #16563

Summary 16563: We cannot create a new question and Limesurvey deletes some answers
Revision 2020-08-04 18:06 by cdorin
Description

When we try to create a new question this error appears in Postgres Log:

  • SELECT * FROM "lime_questions" "t" WHERE sid = 616628 AND qid = '' LIMIT 1
    invalid input syntax for integer: "" at character 65

We attach an error that it appears in the console.

Afterthat we have created the new question directly into the database and It worked but... when we changed some attribute (e.g. hide tip) Limesurvey deletes some answers from database. See attached the database changes:

  • After to create the question:
  • Table lime_answers: lime_answers1.jpg
  • Table lime_answers_I10ns1: lime_answers_I10ns1.jpg
  • Table lime_question_attributes: lime_question_attributes1.jpg
  • After to modify an attribute:
  • Table lime_question_attributes: lime_question_attributes2.jpg
  • Table lime_answers: lime_answers2.jpg (two of three answers options have disapeared)
Revision 2020-08-03 19:09 by estupendu
Description

When we try to create a new question this error appears in Postgres Log:

  • SELECT * FROM "lime_questions" "t" WHERE sid = 616628 AND qid = '' LIMIT 1
    invalid input syntax for integer: "" at character 65

We attach an error that it appears in the console.

Afterthat we have created the new question directly into the database and It worked but... when we changed some attribute (e.g. hide tip) Limesurvey deletes some answers from database. See attached the database changes:

  • After to create the question:
  • Table lime_answers: lime_answers1.jpg
  • Table lime_answers_I10ns1: lime_answers_I10ns1.jpg
  • Table lime_question_attributes: lime_question_attributes1.jpg
  • After to modify an attribute:
  • Table lime_question_attributes: lime_question_attributes2.jpg
  • Table lime_answers: lime_answers2.jpg (two of three answers options have disapeared)