It is not easy to implement due to how the history is stored. But we will work on it in version 12.
Referring to: Deprecating SQLite Database Support
a) does this mean seafile 11 is the last version with sqlite support or is it already removed?
b) will there be a fix to the migration scripts, as the migration does not work at the moment:
trying to migrate a small 10 CE based installation, I get the errors below, and worse, with mariadb I get more errors than with mysql. both tests done with docker based mysql:latest and mariadb:latest images
MYSQL
ERROR 1406 (22001) at line 246 in file: ‘seahub-db.sql’: Data too long for column ‘token’ at row 1
ERROR 1406 (22001) at line 254 in file: ‘seahub-db.sql’: Data too long for column ‘token’ at row 1
ERROR 1064 (42000) at line 11956 in file: ‘seahub-db.sql’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘, reporter text NOT NULL) ENGINE=INNODB’ at line 1
ERROR 1146 (42S02) at line 12207 in file: ‘seahub-db.sql’: Table ‘seahub_db.custom_share_permission’ doesn’t exist
MARIADB
ERROR 1005 (HY000) at line 50 in file: ‘seahub-db.sql’: Can’t create table seahub_db.base_filediscuss (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1005 (HY000) at line 135 in file: ‘seahub-db.sql’: Can’t create table seahub_db.message_usermsgattachment (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1406 (22001) at line 246 in file: ‘seahub-db.sql’: Data too long for column ‘token’ at row 1
ERROR 1406 (22001) at line 254 in file: ‘seahub-db.sql’: Data too long for column ‘token’ at row 1
ERROR 1005 (HY000) at line 479 in file: ‘seahub-db.sql’: Can’t create table seahub_db.post_office_log (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1005 (HY000) at line 482 in file: ‘seahub-db.sql’: Can’t create table seahub_db.post_office_attachment_emails (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1005 (HY000) at line 485 in file: ‘seahub-db.sql’: Can’t create table seahub_db.post_office_email (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1005 (HY000) at line 11843 in file: ‘seahub-db.sql’: Can’t create table seahub_db.auth_group_permissions (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1005 (HY000) at line 11846 in file: ‘seahub-db.sql’: Can’t create table seahub_db.auth_user_groups (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1005 (HY000) at line 11849 in file: ‘seahub-db.sql’: Can’t create table seahub_db.auth_user_user_permissions (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1005 (HY000) at line 11861 in file: ‘seahub-db.sql’: Can’t create table seahub_db.drafts_draftreviewer (errno: 150 “Foreign key constraint is incorrectly formed”)
ERROR 1064 (42000) at line 11956 in file: ‘seahub-db.sql’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ’ reporter text NOT NULL) ENGINE=INNODB’ at line 1
ERROR 1146 (42S02) at line 11973 in file: ‘seahub-db.sql’: Table ‘seahub_db.base_filediscuss’ doesn’t exist
ERROR 1146 (42S02) at line 11975 in file: ‘seahub-db.sql’: Table ‘seahub_db.base_filediscuss’ doesn’t exist
ERROR 1146 (42S02) at line 12005 in file: ‘seahub-db.sql’: Table ‘seahub_db.message_usermsgattachment’ doesn’t exist
ERROR 1146 (42S02) at line 12007 in file: ‘seahub-db.sql’: Table ‘seahub_db.message_usermsgattachment’ doesn’t exist
ERROR 1146 (42S02) at line 12047 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_log’ doesn’t exist
ERROR 1146 (42S02) at line 12049 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_attachment_emails’ doesn’t exist
ERROR 1146 (42S02) at line 12051 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_attachment_emails’ doesn’t exist
ERROR 1146 (42S02) at line 12053 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_email’ doesn’t exist
ERROR 1146 (42S02) at line 12055 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_email’ doesn’t exist
ERROR 1146 (42S02) at line 12057 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_email’ doesn’t exist
ERROR 1146 (42S02) at line 12059 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_email’ doesn’t exist
ERROR 1146 (42S02) at line 12061 in file: ‘seahub-db.sql’: Table ‘seahub_db.post_office_email’ doesn’t exist
ERROR 1146 (42S02) at line 12117 in file: ‘seahub-db.sql’: Table ‘seahub_db.auth_group_permissions’ doesn’t exist
ERROR 1146 (42S02) at line 12119 in file: ‘seahub-db.sql’: Table ‘seahub_db.auth_group_permissions’ doesn’t exist
ERROR 1146 (42S02) at line 12121 in file: ‘seahub-db.sql’: Table ‘seahub_db.auth_user_groups’ doesn’t exist
ERROR 1146 (42S02) at line 12123 in file: ‘seahub-db.sql’: Table ‘seahub_db.auth_user_groups’ doesn’t exist
ERROR 1146 (42S02) at line 12125 in file: ‘seahub-db.sql’: Table ‘seahub_db.auth_user_user_permissions’ doesn’t exist
ERROR 1146 (42S02) at line 12127 in file: ‘seahub-db.sql’: Table ‘seahub_db.auth_user_user_permissions’ doesn’t exist
ERROR 1146 (42S02) at line 12137 in file: ‘seahub-db.sql’: Table ‘seahub_db.drafts_draftreviewer’ doesn’t exist
ERROR 1146 (42S02) at line 12139 in file: ‘seahub-db.sql’: Table ‘seahub_db.drafts_draftreviewer’ doesn’t exist
ERROR 1146 (42S02) at line 12207 in file: ‘seahub-db.sql’: Table ‘seahub_db.custom_share_permission’ doesn’t exist
Seafile 11 is the latest version with sqlite support.
We will check the issue.
Is the professional version of this out yet? All I can see on the downloads page is 10.0.9.
It is not out yet. You can check the announcements category in the forum for release notices.