I am using Limesurvey: Version 4.3.8+200803
Database: PostgreSQL
When I 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 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)