- Posts: 10
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
I cannot create a new question
- estupendu
- Topic Author
- Offline
- New Member
Less
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.
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.
Attachments:
The topic has been locked.
- estupendu
- Topic Author
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 1
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.
- 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.
Attachments:
The topic has been locked.