- Posts: 83
- Thank you received: 7
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
- Topic Author
- Offline
- Premium Member
Less
More
4 months 4 days ago #254519
by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11712
- Thank you received: 2756
4 months 4 days ago #254525
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Well, over the holiday season, for sure a lot of LS employees are on holidays.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: mferraz
Please Log in to join the conversation.
- mferraz
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 7
4 months 3 days ago #254538
by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
And it's worse on version 6.4.2+240115, it happens just after login. So, no one can now use our LimeSurvey installation.
Is again related to PostgreSQL, they probably need to abandon their support for it because they have just a few people that support it.
Unfortunately, we've opted for PostgreSQL on this new installation.
Is again related to PostgreSQL, they probably need to abandon their support for it because they have just a few people that support it.
Unfortunately, we've opted for PostgreSQL on this new installation.
Please Log in to join the conversation.
- mferraz
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 7
4 months 3 days ago #254542
by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
But looking at the last commit on git, it seems to be some updates to translations. Could that be related to a Portuguese installation?
github.com/LimeSurvey/LimeSurvey/commit/...a3d53efcb3b88adac371
github.com/LimeSurvey/LimeSurvey/commit/...239273633508768f9da9
github.com/LimeSurvey/LimeSurvey/commit/...a3d53efcb3b88adac371
github.com/LimeSurvey/LimeSurvey/commit/...239273633508768f9da9
Please Log in to join the conversation.
- mferraz
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 7
4 months 3 days ago #254546
by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Found a related bug:
bugs.limesurvey.org/view.php?id=19332
with a possible fix:
github.com/LimeSurvey/LimeSurvey/pull/3686/files
bugs.limesurvey.org/view.php?id=19332
with a possible fix:
github.com/LimeSurvey/LimeSurvey/pull/3686/files
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11712
- Thank you received: 2756
4 months 3 days ago #254549
by holch
There is no real such thing as "Portuguese installation". It is all the same installation, just the language settings are different. So if it would be a language issue, it could be easily checked by switching to for example English and see if it happens.
PostgreSQL is always risky, because less people test Limesurvey on Postgre. In theory it should work, because the framework works with Postgre, but you know how things are in software development, you need to test everything to make sure it works. I would guess that 90% of all installations are on MySQL and similar, then there are a few on MsSQL and some on Postgre. Both are a lot less tested and thus those things can happen.
I personally would always try to run Limesurvey with MySQL, just because it runs smoother from what I can see, for above reasons.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Could that be related to a Portuguese installation?
There is no real such thing as "Portuguese installation". It is all the same installation, just the language settings are different. So if it would be a language issue, it could be easily checked by switching to for example English and see if it happens.
PostgreSQL is always risky, because less people test Limesurvey on Postgre. In theory it should work, because the framework works with Postgre, but you know how things are in software development, you need to test everything to make sure it works. I would guess that 90% of all installations are on MySQL and similar, then there are a few on MsSQL and some on Postgre. Both are a lot less tested and thus those things can happen.
I personally would always try to run Limesurvey with MySQL, just because it runs smoother from what I can see, for above reasons.
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
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 7
4 months 3 days ago #254551
by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
I know there isn't a Portuguese installation. That was just a figure of speech, we can change a survey to English to try it, that did work in the past, but this issue with the latest release was affecting just right after login.
I was just pointing out the fact that in the latest release, we had some translations updated, and one of them was in fact the Portuguese one.
I had to downgrade the version so we can use the platform.
Sure, we can change it again to MySQL, is there any migration script or plan for that?
I was just pointing out the fact that in the latest release, we had some translations updated, and one of them was in fact the Portuguese one.
I had to downgrade the version so we can use the platform.
Sure, we can change it again to MySQL, is there any migration script or plan for that?
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11712
- Thank you received: 2756
4 months 3 days ago #254553
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Changes in any language just means that there has been an update to the language file, mostly because more strings have been translated or translations have been updated. This should not impact the functionality of the installation, just have more parts translated. Of course, issues can never be excluded 100%, but I think it is pretty safe to say, that this should have nothing to do with the update for the Portuguese language files. I think at the moment there is little you can do than wait for the bug report to be worked on.
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.
- mmilinovsky
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 1
4 months 3 days ago #254582
by mmilinovsky
Replied by mmilinovsky on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Hi mferraz,
> I had to downgrade the version so we can use the platform.
to which version did you downgrade and how did you do that? Same procedure as upgrading to a new version?
> I had to downgrade the version so we can use the platform.
to which version did you downgrade and how did you do that? Same procedure as upgrading to a new version?
Please Log in to join the conversation.
- mferraz
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 7
4 months 3 days ago #254583
by mferraz
Replied by mferraz on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Hi.
Exactly, I've downloaded directly from github, from the last week commit: github.com/LimeSurvey/LimeSurvey/tree/52...eccfb4eaa900d1dde9f4
Exactly, I've downloaded directly from github, from the last week commit: github.com/LimeSurvey/LimeSurvey/tree/52...eccfb4eaa900d1dde9f4
Please Log in to join the conversation.
- JiyaHana
- Offline
- New Member
Less
More
- Posts: 13
- Thank you received: 2
3 months 4 weeks ago #254837
by JiyaHana
Replied by JiyaHana on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Check you are providing a valid value for the qid parameter when creating a new survey. The error suggests an invalid input syntax for type integer, indicating that an empty or non-integer value is being used where an integer is expected.
Ex,
UPDATE lime_question_l10ns SET qid = 1 WHERE qid = ' ';
Ex,
UPDATE lime_question_l10ns SET qid = 1 WHERE qid = ' ';
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13716
- Thank you received: 2502
3 months 3 weeks ago #254854
by DenisChenu
Nonsense, dumb advice ... done with chatGPT?
Just do not set qid, since it's a serial for pgSQL, AUTO_INCREMENT for MariaDB and IDENTITY for Mssql
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.
Replied by DenisChenu on topic SQL: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
Check you are providing a valid value for the qid parameter when creating a new survey. The error suggests an invalid input syntax for type integer, indicating that an empty or non-integer value is being used where an integer is expected.
Ex,
UPDATE lime_question_l10ns SET qid = 1 WHERE qid = ' ';
Nonsense, dumb advice ... done with chatGPT?
Just do not set qid, since it's a serial for pgSQL, AUTO_INCREMENT for MariaDB and IDENTITY for Mssql
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.