Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

I cannot create a new question

More
5 years 3 weeks ago #203560 by estupendu
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

I attach an error that it appears in the console.

Could you help me?

Thanks.
The topic has been locked.
More
5 years 3 weeks ago #203565 by estupendu
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)

We do not understand why.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose