Orthanc upgrade problem (1.3.0 to 1.5.3)

Google Groups archive
1

Hi,

I am trying to migrate from 1.3.0 to 1.5.3.

Orthanc won’t start (I am using the --upgrade option) , with the following error:

[…]
W0207 22:03:23.049794 main.cpp:1224] Using a custom database from plugins
W0207 22:03:23.049820 OrthancInitialization.cpp:376] Storage directory: “/data/OrthancStorage”
I0207 22:03:23.058878 PluginsManager.cpp:172] Installing the CreateInstance extension
E0207 22:03:23.065256 PluginsManager.cpp:164] PostgreSQL error: ERROR: syntax error at or near “ASSERT”
LINE 32: ASSERT studyKey IS NULL;
^

W0207 22:03:23.065748 PluginsManager.cpp:168] PostgreSQL: An active PostgreSQL transaction was dismissed
I0207 22:03:23.065847 PluginsManager.cpp:172] Closing connection to PostgreSQL
[…]

Any ideas?

Best,

Philippe

2

Hello,

This issue has been discussed previously on the forum:
https://groups.google.com/d/msg/orthanc-users/BXfmwU786B0/J0_nPoZzFwAJ

This is due to the fact that your PostgreSQL server is too old to support the “RAISE” SQL instruction.

This is fixed in the mainline, and will be part of forthcoming release 3.1 of the PostgreSQL plugins. You could upgrade your PostgreSQL server as well.

Sébastien-

3

Thanks. I used version 3.1 instead of updating my Postgresql install.