[SOLVED] Unable to set user quota - Column count doesn't match value count

Seafile Server
1

Hi,

I am unable to set quotas on my server 6.2.0, running on MySQL under Ubuntu.
This is logged in seafile.log:

…/common/seaf-db.c(425): Error prepare statement REPLACE INTO UserQuota VALUES (?, ?): mysql_stmt_prepare failed: Column count doesn’t match value count at row 1.

The table has this definition:

CREATE TABLE UserQuota (
id BIGINT(20) NOT NULL AUTO_INCREMENT,
user VARCHAR(255) NOT NULL,
quota BIGINT(20) NULL DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE INDEX user (user)
)
COLLATE=‘utf8_general_ci’
ENGINE=InnoDB
;

I recently performed the update from 6.0.8 to version 6.3.4 (64 bit), but I found that I needed the 32 bit version so I installed 6.2.0 32 bit and ran the minor-upgrade.sh script. I don’t recall getting any error messages.
Is something wrong with the table definition? That table is empty, as I had not set any quotas before.

EDIT
I tried to find the definition for that table in seahub/sql/mysql/ but I could not find it. But searching for UserQuota in the github repos I found that this table is created by seafile-server/server/quota-mgr.c at v6.2.0-server · haiwen/seafile-server · GitHub. So, I just stopped seafile, renamed my original table to UserQuotaOld, and after restarting the server the correct table was created.