Unable to update to version "New 18.0 Update 4 Final"

[danielteng]

I understand we need to update to Update 5 but we are unable to get pass Update 4 final as it always hit an error.
The error is shown below:
Exception data:
Severity: ERROR
SqlState: 23505
MessageText: could not create unique index "gateway_name_key"
Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
SchemaName: public
TableName: gateway
ConstraintName: gateway_name_key
File: d:\pginstaller.auto\postgres.windows-x64\src\backend\utils\sort\tuplesort.c
Line: 4056
Routine: comparetup_index_btree

This is the statement:
ALTER TABLE IF EXISTS gateway
ADD CONSTRAINT gateway_name_key UNIQUE (name);

Can anyone assist? Will my system stop working on Dec 1st?

 

[news]

Hi,

I am stuck on 18.0.2.314 Final.

Checked multiple times for updates but nothing showing up. I got an email stating that have to update to v18 Update 5 by 30th November 2022

I am self-hosted on Raspberry pi 4

 

[JosIPVG]

Hi,

I am stuck on 18.0.2.314 Final.

Checked multiple times for updates but nothing showing up. I got an email stating that have to update to v18 Update 5 by 30th November 2022

I am self-hosted on Raspberry pi 4

Pi deployments wont be able to update further then what you have currently since it's no longer supported for a while now.
Either move to a hosted enviroment or take a back up and install it on a supported device to make updates available.

 

[AndreasPo_3CX]

Hello @danielteng

Provided that the system is installed and configured as per our official guidelines (see below) this is going to be an issue that requires more in-depth analysis to troubleshoot. As such we would suggest that you open a technical support ticket about it.

https://www.3cx.com/docs/manual/phone-system-installation-windows/
https://www.3cx.com/docs/manual/installing-debian-linux-pbx/

 

[sbohanan]

Hi,

I am stuck on 18.0.2.314 Final.

Checked multiple times for updates but nothing showing up. I got an email stating that have to update to v18 Update 5 by 30th November 2022

I am self-hosted on Raspberry pi 4

Out of curiosity, what exactly will happen if we are unable to update by the 30th of November, 2022? Will the phone system just stop working on the 1st of December?

 

[danielteng]

Thanks everyone for the replies. I got my partner to help with the upgrade and all is working now, except for the "break" IVR. will open a different thread on this instead

To those who want to know the solution, we did an uninstall and reinstall and restoring the backup.