Hello,
I am trying to update our system to the New 18.0 Update 6 Final, on the update available page it shows this :-
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.
I am trying to update our system to the New 18.0 Update 6 Final, on the update available page it shows this :-
| Release | New 18.0 Update 6 Final | Out Of Date | 18.0.5.418 | 18.0.6.908 | New 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.
