Welcome to the LimeSurvey Community Forum

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

I cannot create a new question

  • estupendu
  • estupendu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 8 months ago #203560 by estupendu
I cannot create a new question was created 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.
  • estupendu
  • estupendu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 8 months ago #203565 by estupendu
Replied by estupendu on topic I cannot create a new question
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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose