Welcome to the LimeSurvey Community Forum

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

SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 months 1 week ago #244334 by mferraz
Please help us help you and fill where relevant:
Your LimeSurvey version: 6.1.4+230620
Own server or LimeSurvey hosting: own server
Survey theme/template: default
==================

Hi, I'm getting the following error on this installation. I've opted for PostgreSQL, and I'm getting the following when I try to create a new survey. The survey is created, but it's always generating the error. Getting the same when I activate the survey.SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""
LINE 1: ...LECT * FROM "lime_question_l10ns" "t" WHERE qid = '' and lan...
Thank you in advance.
 

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 months 1 week ago #244338 by mferraz
The following invalid query is tried:
inqueritos@inqueritos STATEMENT: SELECT * FROM "lime_question_l10ns" "t" WHERE qid = '' and language = 'en' LIMIT 1

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 1 week ago #244342 by holch
If you think this is a bug, create a bug report: bugs.limesurey.org.

Be as specific as possible about your installation and the error.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 months 1 week ago - 10 months 1 week ago #244355 by mferraz
Hi.

Thank you for your reply.

I'll do it; I'm trying to recover my password there but I still haven't received the e-mail for that.
Last edit: 10 months 1 week ago by mferraz.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 months 1 week ago #244356 by mferraz
The following user(s) said Thank You: holch, tpartner

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 6 days ago #244363 by holch
I am not sure if this has something to do with your issue, but in the bug report you say you run PHP 8.2 which is not supported by any Limesurvey version at the moment.

manual.limesurvey.org/Installation_-_Lim...rvey_on_your_website

LS 6 currently supports PHP 7.4.x to 8.1.x.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 months 6 days ago #244364 by mferraz
Thank you for your reply.
I've a working 3.x installation with PHP 8.2 without issue but using MySQL instead of PostgreSQL.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 months 6 days ago #244366 by mferraz
But I've now changed to the 8.1 version. Still, the same issue persists.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 6 days ago #244369 by holch

I've a working 3.x installation with PHP 8.2 without issue but using MySQL instead of PostgreSQL.


Great to know that it works for you with LS 3.x, but it can't be guaranteed.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 6 days ago #244370 by holch

But I've now changed to the 8.1 version. Still, the same issue persists.


As I said, it might not have anything to do with your issue.

So your bug report is still valid. But I would update it with the information that this also happens with PHP 8.1 because I am sure the first thing they will ask you is to test with PHP 8.1. As you have done this already, let the developers know in the bug report and speed things up.

Oh, i just checked and you did it already. Great!

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 months 6 days ago #244371 by mferraz
Thank you for your reply.

I did. :)

Please Log in to join the conversation.

More
3 months 1 week ago #254518 by mmilinovsky
Do you know if there is any progress on this for LS version 6.4.1?

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose