Upgrade failed 6.0.6 > 6.3.2 or 6.2.5 On Raspberry Pi : sqlite3_exec failed: table EmailUser

Hello All, After upgrade seafile 6.0.6 to 6.3.2 or 6.2.5. Seafile not running.

août 05 21:12:37 raspiserver seafile.sh[12540]: failed to run “ccnet-server -t”
août 05 21:12:37 raspiserver seafile.sh[12540]: [08/05/18 21:12:37] …/common/session.c(132): using config file /opt/seafile/conf/ccnet.conf
août 05 21:12:37 raspiserver seafile.sh[12540]: [08/05/18 21:12:37] …/common/ccnet-db.c(142): Error exec query CREATE UNIQUE INDEX IF NOT EXISTS
août 05 21:12:37 raspiserver systemd[1]: seafile.service: main process exited, code=exited, status=1/FAILURE
août 05 21:12:37 raspiserver systemd[1]: Failed to start Seafile server.
– Subject: L’unité (unit) seafile.service a échoué
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

– L’unité (unit) seafile.service a échoué, avec le résultat failed.
août 05 21:12:37 raspiserver systemd[1]: Unit seafile.service entered failed state.
août 05 21:12:37 raspiserver sudo[12534]: pam_unix(sudo:session): session closed for user root
août 05 21:12:50 raspiserver sudo[12576]: pi : TTY=pts/0 ; PWD=/opt/seafile ; USER=root ; COMMAND=/bin/journalctl -xn
août 05 21:12:50 raspiserver sudo[12576]: pam_unix(sudo:session): session opened for user root by pi(uid=0)

seafile@raspiserver:/opt/seafile/seafile-server-6.2.5 $ ./seafile.sh start
[08/05/18 21:17:50] …/common/session.c(132): using config file /opt/seafile/conf/ccnet.conf
[08/05/18 21:17:51] …/common/ccnet-db.c(142): Error exec query CREATE UNIQUE INDEX IF NOT EXISTS reference_id_index on EmailUser (reference_id): sqlite3_exec failed: table EmailUser has no column named reference_id.
ccnet-db.c(142): Error exec query CREATE UNIQUE INDEX IF NOT EXISTS reference_id_index on EmailUser (reference_id): sqlite3_exec failed: table EmailUser has no column named reference_id.

Do you have a solution for this problem?

Thanks

Did you try to upgrade to 6.1.x first and after this to 6.2.x and so on?

You have to upgrade each version step by step.

I will do it in the next few days. I give you the status

Upgrade to 6.1.2 with success. I’m testing few day after next upgrade to 6.2. Thanks

Upgrade to 6.2.5 with success. My Android client 2.2.2 and next cant not upload file. The 2.2.1 version upload whith success. Please help me.

My nginx config


server {
listen 8001;
server_name localhost;
ssl on;
ssl_certificate /etc/nginx/ssl/seahub.crt;
ssl_certificate_key /etc/nginx/ssl/seahub.key;
ssl_session_timeout 5m;
ssl_protocols TLSv1.2;
ssl_ciphers ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+EXP;
ssl_prefer_server_ciphers on;
location / {
fastcgi_pass 127.0.0.1:8000;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param PATH_INFO $fastcgi_script_name;
fastcgi_param SERVER_PROTOCOL $server_protocol;
fastcgi_param QUERY_STRING $query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SERVER_ADDR $server_addr;
fastcgi_param SERVER_PORT $server_port;
fastcgi_param SERVER_NAME $server_name;
fastcgi_param HTTPS on;
fastcgi_param HTTP_SCHEME https;

        access_log      /var/log/nginx/access.log;
        error_log       /var/log/nginx/error.log;
    }
    location /seafhttp {
        rewrite ^/seafhttp(.*)$ $1 break;
        proxy_pass http://127.0.0.1:8082;
        client_max_body_size 0;
        proxy_connect_timeout  36000s;
        proxy_read_timeout  36000s;
    }
    location /media {
        root /opt/seafile/seafile-server-latest/seahub;
    }

}

That’s a bug in version 2.2.2/3. Use either 2.2.1 or 2.2.4.

I have a bug on 2.2.2 2.2.3 and 2.2.4. I’m wating a new version. Thanks