Entries in share_fileshare missing after SQLite to MySQL migration

Seafile Server
1

I did an upgrade from seafile 9 to 10, did the convertion from sqlite to mysql, and the upgrade to seafile 11.
After this, I noticed that most of my share links are missing. The missing links are in seahub-db.sql in a way like:

INSERT INTO share_fileshare VALUES(886,'a.b@c.ath.cx','a0a2d6d0-7c8b-4e76-adff-b2cdfe51cbd0','/dir/file.ext','1234567890abcdefghij','2024-01-09 21:14:50.493424',9,'f',NULL,NULL,'view_download');

If I try to add the entry manually via mysql:

MariaDB [seahub_db]> INSERT INTO share_fileshare VALUES(886,'a.b@c.ath.cx','a0a2d6d0-7c8b-4e76-adff-b2cdfe51cbd0','/dir/file.ext','1234567890abcdefghij','2024-01-09 21:14:50.493424',9,'f',NULL,NULL,'view_download');
ERROR 1406 (22001): Data too long for column 'token' at row 1
MariaDB [seahub_db]> DESCRIBE share_fileshare;
+-------------+--------------+------+-----+---------------+----------------+
| Field       | Type         | Null | Key | Default       | Extra          |
+-------------+--------------+------+-----+---------------+----------------+
| id          | int(11)      | NO   | PRI | NULL          | auto_increment |
| username    | varchar(255) | NO   | MUL | NULL          |                |
| repo_id     | varchar(36)  | NO   | MUL | NULL          |                |
| path        | longtext     | NO   |     | NULL          |                |
| token       | varchar(10)  | NO   | UNI | NULL          |                |
| ctime       | datetime     | NO   |     | NULL          |                |
| view_cnt    | int(11)      | NO   |     | NULL          |                |
| s_type      | varchar(2)   | NO   | MUL | NULL          |                |
| password    | varchar(128) | YES  |     | NULL          |                |
| expire_date | datetime     | YES  |     | NULL          |                |
| permission  | varchar(50)  | NO   |     | view_download |                |
+-------------+--------------+------+-----+---------------+----------------+
11 rows in set (0.005 sec)

fails, because the token does not fit the table definition.

Is there a way to restore the share links?

2

I just noticed that seahub/sql/mysql.sql at 338d053c6e2ea62588f12497dfb77de8ccc71338 · haiwen/seahub · GitHub creates the token varchar(100) , so I adjusted the new table via
ALTER TABLE share_fileshare MODIFY COLUMN token varchar(100) NOT NULL;

3

I had the same issue, please add this to the FAQ section of “Seafile Admin Manual
Migrate From SQLite to MySQL”.
In addition, I encountered another " `150 “Foreign key constraint is incorrectly formed” for drafts_draftreviewer, because drafts_draft was after that in the sql file. I’ve changed the order accordingly and the sql import finally went through without any errors. So please add this to the FAQ section, too. So other users will be able to fix their issues quickly.