[Resolved] - SQLSTATE[42000]: Syntax error or access violation

[Francois Barroero]

Hi team. When I tried to upgrade from the admin panel, I got this error:

Websites are still running well, but I cannot acces to admin interface anymore.

Any ideas guys ?

A database error occurred

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'guid'

 

[d00p]

That means there are duplicate keys for the field "guid" in either panel_customers and/or ftp_groups - which means you either did that manually before the update or somehow managed to not complete the database update from db-version 202005150 to 202007240.

The changes that are being done in that update process are the following:

ALTER TABLE panel_customers ADD INDEX guid (guid);
ALTER TABLE panel_tasks ADD INDEX type (type);
ALTER TABLE mail_users ADD INDEX username (username);
ALTER TABLE mail_users ADD INDEX imap (imap);
ALTER TABLE mail_users ADD INDEX pop3 (pop3);
ALTER TABLE ftp_groups ADD INDEX gid (gid);

So if your databaseversion in panel_settings is 202005150 but you already have these indexes set, you can either drop these indexes and let froxlor update re-create them or comment out these changes in the file install/updates/froxlor/0.10/update_0.10.inc.php (~656-661) 

[Francois Barroero]

15 minutes ago, d00p said:

That means there are duplicate keys for the field "guid" in either panel_customers and/or ftp_groups - which means you either did that manually before the update or somehow managed to not complete the database update from db-version 202005150 to 202007240.

The changes that are being done in that update process are the following:

ALTER TABLE panel_customers ADD INDEX guid (guid);
ALTER TABLE panel_tasks ADD INDEX type (type);
ALTER TABLE mail_users ADD INDEX username (username);
ALTER TABLE mail_users ADD INDEX imap (imap);
ALTER TABLE mail_users ADD INDEX pop3 (pop3);
ALTER TABLE ftp_groups ADD INDEX gid (gid);

So if your databaseversion in panel_settings is 202005150 but you already have these indexes set, you can either drop these indexes and let froxlor update re-create them or comment out these changes in the file install/updates/froxlor/0.10/update_0.10.inc.php (~656-661) 

Thanks.

Before your answered, I've edite the /var/www/froxlor/install/updates/froxlor/0.10 # vi update_0.10.inc.php file and comment few lines in this files.

It seems i've done it right

Thanks d00p !