Print Page - failed upgrade to 2.0 (sqlite)

Title: failed upgrade to 2.0 (sqlite)
Post by: nik247 on January 05, 2016, 05:20:35 PM

I try upgrade (sqlite) to ver. 2.0 on Debian Wheezy and get next errors:

Upgrading database...
Upgrading from version 349 to 350
SQL query failed (no such function: char):
UPDATE object_properties SET comments = comments || char(13,10) || (SELECT description FROM ap_common WHERE ap_common.id = object_properties.object_id) WHERE EXISTS (SELECT description FROM ap_common WHERE ap_common.id = object_properties.object_id AND description IS NOT NULL AND description <> '')
Rolling back last stage due to upgrade errors...
Database upgrade failed

Debian Wheezy use sqlite3 Version: 3.7.13-1+deb7u2
But "The char function was added in 3.7.16"

Title: Re: failed upgrade to 2.0 (sqlite)
Post by: Victor Kirhenshtein on January 05, 2016, 05:39:18 PM

Hi,

you have few options here:

1. Run nxdbmgr with -X option so it will skip failing queries;
2. Install newer sqlite from backports;
3. Build NetXMS from sources and specify --with-internal-sqlite option to configure to use bundled sqlite;
4. Migrate to another database (actually, recommended option).

Please note that in the future SQLite support as backend database will be dropped completely.

Best regards,
Victor

Title: Re: failed upgrade to 2.0 (sqlite)
Post by: nik247 on January 05, 2016, 05:57:13 PM

Thanks.
I fixed upgrade with -X.
And will migrate to mysql.

Regards,
Nikolay

NetXMS Support Forum

English Support => General Support => Topic started by: nik247 on January 05, 2016, 05:20:35 PM