Error on updating cyclos 4.12.1 to 4.12.3

Bug and problem reporting on Cyclos 4 version

Moderators: hugo, alexandre, rmvanarkel

Post Reply
jar
Posts: 100
Joined: Mon Apr 20, 2015 8:55 am

Error on updating cyclos 4.12.1 to 4.12.3

Post by jar » Wed Oct 09, 2019 11:52 am

Hi,

We tried updated the cyclos version 4.12.1 to 4.12.3 several times in a local machine, but when we make the login as admin or user show a cyclos exception and doesn't show the home area. Another situation, when we go to Financies Menu show another cyclos exception and doesn't show the account layout.

This is the exception:

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from account_status(?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: function account_status(bigint, unknown) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.

It appears that a database function is missing.
How is it possible?

Can you help to solve it?

Thanks.
Thanks for your kind attention.
Best regards,

JAR

alexandre
Posts: 843
Joined: Wed Sep 06, 2006 9:06 am

Re: Error on updating cyclos 4.12.1 to 4.12.3

Post by alexandre » Wed Oct 09, 2019 2:49 pm

Hi,

On the first start on the update, some database migrations must run. Check the tomcat catalina out to see if some of this migrations have failed.

If you prefer you can send a database dump that was running on version 4.12.1 to info@cyclos.org so we can check if any migration fail.

Regards
Alexandre
Alexandre Caurrinhos
Cyclos development team.

alexandre
Posts: 843
Joined: Wed Sep 06, 2006 9:06 am

Re: Error on updating cyclos 4.12.1 to 4.12.3

Post by alexandre » Thu Oct 10, 2019 8:59 am

Hi,

The problem with your database is that it has some tables / indexes that not belong to cyclos. Some of these indexes are case sensitive and due to it some migrations had failed.

We made a version with a hotfix for you, also this will be in the official 4.12.4 release.

Here the link to download:
https://services.cyclos.org/hotfix/cyclos-4.12.3.zip

regards
Alexandre
Alexandre Caurrinhos
Cyclos development team.

jar
Posts: 100
Joined: Mon Apr 20, 2015 8:55 am

Re: Error on updating cyclos 4.12.1 to 4.12.3

Post by jar » Thu Oct 10, 2019 11:14 am

Thanks.
Thanks for your kind attention.
Best regards,

JAR

Post Reply