Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Topics - nik247

#1
General Support / failed upgrade to 2.0 (sqlite)
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"