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
2 months 2 weeks ago #255646 by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
I was trying to upgrade from the existing installation, and yeah, there is probably an issue with the current database.

And yeah, I'm with you on that stance about any other database than MySQL/MariaDB.

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 months 2 weeks ago #255651 by DenisChenu
Replied by DenisChenu on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Remind : it's fixed in the version of YESTERDAY !

github.com/LimeSurvey/LimeSurvey/commit/...43b58a9d7422f1650c3e
the 6.4.5 only.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 2 weeks ago #255653 by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
That was the release that I've tried to update.

Please Log in to join the conversation.

More
2 months 1 week ago #256181 by mmilinovsky
Replied by mmilinovsky on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
I can confirm, that with version 6.4.6 the bug has gone in our installation.
The following user(s) said Thank You: mferraz

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 1 week ago #256182 by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Yep, I can also confirm too.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source