failed upgrade to 2.0 (sqlite)

[nik247]

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"

[victor]

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

[nik247]

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

Regards,
Nikolay