Toggle sidebar Toggle sidebar

updating from 18.0.5.418 to New 18.0 Update 6 Final 18.0.6.908

Status
Not open for further replies.

totalkitchens

Free User
Joined
Sep 15, 2020
Messages
1
Reaction score
1
Hello,


I am trying to update our system to the New 18.0 Update 6 Final, on the update available page it shows this :-

ReleaseNew 18.0 Update 6 FinalOut Of Date18.0.5.41818.0.6.908New 18.0 Update 6 Final Available

but when a download the selected update & it attempts to install, I get an email a few minutes later with the following text in a file:-

Hit:1 http://repo.3cx.com/debian/1806 buster InRelease
Hit:2 http://repo.3cx.com/debian-security/1806 buster InRelease
Hit:3 http://repo.3cx.com/3cx buster-testing InRelease
Hit:4 http://repo.3cx.com/3cx buster InRelease
Reading package lists...
Reading package lists...
Building dependency tree...
Reading state information...
3cxpbx is already the newest version (18.0.6.908).
0 upgraded, 0 newly installed, 0 to remove and 51 not upgraded.
W: --force-yes is deprecated, use one of the options starting with --allow instead.



So from what this file says it is already at that version so does not need to be updated is that correct, but when I tried ealier in the day, I got this txt file attached to an email but nothing had been updated :-



Hit:1 http://repo.3cx.com/debian/1806 buster InRelease

Get:2 http://repo.3cx.com/debian-security/1806 buster InRelease [8,136 B]

Hit:3 http://repo.3cx.com/3cx buster-testing InRelease

Hit:4 http://repo.3cx.com/3cx buster InRelease

Get:5 http://repo.3cx.com/debian-security/1806 buster/main amd64 Packages [70.6 kB]

Fetched 78.7 kB in 0s (225 kB/s)

Reading package lists...

Reading package lists...

Building dependency tree...

Reading state information...

3cxpbx is already the newest version (18.0.6.908).

0 upgraded, 0 newly installed, 0 to remove and 51 not upgraded.

1 not fully installed or removed.

After this operation, 0 B of additional disk space will be used.

Setting up 3cxpbx (18.0.6.908) ...

debconf: unable to initialize frontend: Dialog

debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.)

debconf: falling back to frontend: Readline

debconf: unable to initialize frontend: Dialog

debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.)

debconf: falling back to frontend: Readline

Updating certificates in /etc/ssl/certs...

2 added, 0 removed; done.

Running hooks in /etc/ca-certificates/update.d...

done.

Removed /etc/systemd/system/3CXCfgServ01.service.

Removed /etc/systemd/system/3CXAudioProvider01.service.

Removed /etc/systemd/system/3CXMediaServer.service.

Removed /etc/systemd/system/3CXGatewayService.service.

Removed /etc/systemd/system/3CXEventNotificationManager.service.

Removed /etc/systemd/system/3CXPhoneSystemMC01.service.

Removed /etc/systemd/system/3CXSystemService01.service.

Removed /etc/systemd/system/3CXIVR01.service.

Removed /etc/systemd/system/3CXQueueManager01.service.

Removed /etc/systemd/system/3CXHotelModule01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXCfgServ01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXAudioProvider01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXMediaServer.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXGatewayService.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXEventNotificationManager.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXPhoneSystemMC01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXSystemService01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXIVR01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXQueueManager01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXHotelModule01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXPhoneSystem01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXCallFlow01.service.

Removed /etc/systemd/system/3CXPhoneSystem01.service.

Removed /etc/systemd/system/3CXCallFlow01.service.

Updating from Version 18.0.6.908

Loading global scripts...

Loading instance scripts...

Loading instances...

CurrentDbVersion=542

Updating global DB tables...

Applying script for all instance tables

Loading instance parameters from phonesystem_mastertable

Updating instance DB tables...

Replacing parameters

Npgsql.PostgresException (0x80004005): 42601: syntax error at end of input

at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)

at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)

at Npgsql.NpgsqlDataReader.NextResult()

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar(Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar()

at Updater2Db.UpdateInfoExtractor.ExecuteScript(String sqlQuery, String transactionName, Exception& err)

Exception data:

Severity: ERROR

SqlState: 42601

MessageText: syntax error at end of input

Position: 36

File: scan.l

Line: 1119

Routine: scanner_yyerror

Npgsql.PostgresException (0x80004005): 42601: syntax error at end of input

at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)

at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)

at Npgsql.NpgsqlDataReader.NextResult()

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar(Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar()

at Updater2Db.UpdateInfoExtractor.ExecuteScript(String sqlQuery, String transactionName, Exception& err)

Exception data:

Severity: ERROR

SqlState: 42601

MessageText: syntax error at end of input

Position: 36

File: scan.l

Line: 1119

Routine: scanner_yyerror
Adjusting timezone

Linux timezone file path = /usr/share/zoneinfo/Australia/Adelaide

Configuring Linux timezone

Running /usr/bin/sudo /usr/sbin/3CXSetTimezone "Australia/Adelaide"



Current default time zone: 'Australia/Adelaide'

Local time is now: Tue Feb 7 10:28:15 ACDT 2023.

Universal Time is now: Mon Feb 6 23:58:15 UTC 2023.





System.Exception: DB update failed

at UpdaterNx.Program.Main(String[] args)

W: --force-yes is deprecated, use one of the options starting with --allow instead.


any help would be great.
 
  • Like
Reactions: michalkolacek
It would seem you have made changes to the iso , installed packages or made other changes.... So best do backup and clean restore.


Since you have a very small free instance you best move to startup free
 
Last edited:
  • Like
Reactions: Evolute IT
The same problem here :
apt dist-upgrade

Načítají se seznamy balíků… Hotovo

Vytváří se strom závislostí

Načítají se stavové informace… Hotovo

Propočítává se aktualizace… Hotovo

Následující balíky byly nainstalovány automaticky a již nejsou potřeba:

dh-python gnupg-agent irqbalance libbind9-140 libdns-export162 libdns162 libicu57 libisc-export160 libisc160 libisccc140 libisccfg140 liblttng-ust-ctl2 liblwres141 libnuma1 libperl5.24 libprocps6 libpython3.5-minimal libpython3.5-stdlib libsodium18 libunistring0

liburcu4 linux-image-4.19.0-18-amd64 python-pyasn1 python3-distutils python3-lib2to3 python3.5 python3.5-minimal rename runit-helper sgml-base tcpd xml-core

Pro jejich odstranění použijte „apt autoremove“.

Následující balíky budou aktualizovány:

3cxpbx

1 aktualizováno, 0 nově instalováno, 0 k odstranění a 0 neaktualizováno.

Nutno stáhnout 0 B/119 MB archivů.

Po této operaci bude na disku použito dalších 11,3 MB.

Chcete pokračovat? [Y/n]

Přednastavují se balíky…

(Načítá se databáze … nyní je nainstalováno 53454 souborů a adresářů.)

Připravuje se nahrazení …/3cxpbx_18.0.6.908_amd64.deb …

Removed /etc/systemd/system/sysinit.target.wants/3CXFirewall.service.

Removed /etc/systemd/system/3CXCallFlow01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXCallFlow01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXMediaServer.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXSystemService01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXCfgServ01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXEventNotificationManager.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXQueueManager01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXIVR01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXPhoneSystemMC01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXPhoneSystem01.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXGatewayService.service.

Removed /etc/systemd/system/multi-user.target.wants/3CXAudioProvider01.service.

Removed /etc/systemd/system/3CXMediaServer.service.

Removed /etc/systemd/system/3CXSystemService01.service.

Removed /etc/systemd/system/3CXCfgServ01.service.

Removed /etc/systemd/system/3CXEventNotificationManager.service.

Removed /etc/systemd/system/3CXQueueManager01.service.

Removed /etc/systemd/system/3CXIVR01.service.

Removed /etc/systemd/system/3CXPhoneSystemMC01.service.

Removed /etc/systemd/system/3CXPhoneSystem01.service.

Removed /etc/systemd/system/3CXGatewayService.service.

Removed /etc/systemd/system/3CXAudioProvider01.service.

Rozbaluje se 3cxpbx (18.0.6.908) přes (18.0.5.418) …

Nastavuje se balík 3cxpbx (18.0.6.908) …

Updating certificates in /etc/ssl/certs...

0 added, 0 removed; done.

Running hooks in /etc/ca-certificates/update.d...

done.

Updating from Version 18.0.5.418

Loading global scripts...

Loading instance scripts...

Loading instances...

CurrentDbVersion=542

Updating global DB tables...

Applying script for all instance tables

Loading instance parameters from phonesystem_mastertable

Updating instance DB tables...

Replacing parameters

Npgsql.PostgresException (0x80004005): 42601: syntax error at end of input

at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)

at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)

at Npgsql.NpgsqlDataReader.NextResult()

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar(Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar()

at Updater2Db.UpdateInfoExtractor.ExecuteScript(String sqlQuery, String transactionName, Exception& err)

Exception data:

Severity: ERROR

SqlState: 42601

MessageText: syntax error at end of input

Position: 36

File: scan.l

Line: 1119

Routine: scanner_yyerror

Npgsql.PostgresException (0x80004005): 42601: syntax error at end of input

at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)

at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)

at Npgsql.NpgsqlDataReader.NextResult()

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar(Boolean async, CancellationToken cancellationToken)

at Npgsql.NpgsqlCommand.ExecuteScalar()

at Updater2Db.UpdateInfoExtractor.ExecuteScript(String sqlQuery, String transactionName, Exception& err)

Exception data:

Severity: ERROR

SqlState: 42601

MessageText: syntax error at end of input

Position: 36

File: scan.l

Line: 1119

Routine: scanner_yyerror

Adjusting timezone

Linux timezone file path = /usr/share/zoneinfo/Europe/Prague

Configuring Linux timezone

Running /usr/bin/sudo /usr/sbin/3CXSetTimezone "Europe/Prague"



Current default time zone: 'Europe/Prague'

Local time is now: Thu Feb 2 13:43:34 CET 2023.

Universal Time is now: Thu Feb 2 12:43:34 UTC 2023.







Created symlink /etc/systemd/system/sysinit.target.wants/3CXFirewall.service → /lib/systemd/system/3CXFirewall.service.

System.Exception: DB update failed

at UpdaterNx.Program.Main(String[] args)
 
Status
Not open for further replies.

Latest Posts

Forum statistics

Threads
111,974
Messages
590,081
Members
164,899
Latest member
mazet
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom