Welcome to the LimeSurvey Community Forum

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

Postgres database upgrade error

  • hgreenwald
  • hgreenwald's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 8 months ago #172728 by hgreenwald
Postgres database upgrade error was created by hgreenwald
A few weeks ago, I started encountering errors with the database upgrade script starting with 3.14.1. Another user posted a bug, so I reverted to 3.13.2 and waited for a fix. I tried updating to 3.14.5 today and am getting the same error:

An non-recoverable error happened during the update. Error details:
SQLSTATE[42602]: Invalid name: 7 ERROR: invalid name syntax

File updatedb_helper.php, line 2291.


How can I fix this? I'm running Postgres 10.5 on RHEL 7.
The topic has been locked.
More
5 years 8 months ago #172730 by jelo
Replied by jelo on topic Postgres database upgrade error
You already commented on this bugticket.
bugs.limesurvey.org/view.php?id=13958
Just in case others look for the issue.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • hgreenwald
  • hgreenwald's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 8 months ago #172731 by hgreenwald
Replied by hgreenwald on topic Postgres database upgrade error
The bug ticket has been marked resolved. How can I reopen it or otherwise get it attention?
The topic has been locked.
More
5 years 8 months ago #172732 by jelo
Replied by jelo on topic Postgres database upgrade error
Ticket is still open (Marked as resolved, but not closed). So your comment will be seen.
Since PostgreSQL and MS SQL is not that much tested during development it may take a while.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 8 months ago #172741 by LouisGac
Replied by LouisGac on topic Postgres database upgrade error
Yes it was supposed to be fixed...
The topic has been locked.
More
5 years 8 months ago #172873 by Trimbos
Replied by Trimbos on topic Postgres database upgrade error
Just updated with comfortupdate and getting:

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block


File updatedb_helper.php, line 2289.
Please fix this error in your database and try again

Obviously something completely wrong, and totally messed up stuff.
What is this??
The topic has been locked.
  • markusfluer
  • markusfluer's Avatar
  • Visitor
  • Visitor
5 years 8 months ago #172893 by markusfluer
Replied by markusfluer on topic Postgres database upgrade error
The issue is fixed now.
Coming nex release also updates on postgresql should work as expected.
The topic has been locked.
More
5 years 8 months ago #172896 by jelo
Replied by jelo on topic Postgres database upgrade error

markusfluer wrote: The issue is fixed now.

This one?
github.com/LimeSurvey/LimeSurvey/commit/...97b4a6ef8ef7260bcf8e

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: markusfluer
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose