Upgrade fails 7.6.1 to 7.7 SQL Error

[grimmcreative]

Tried to perform an Upgrade from 7.6.1 to 7.7
Always fails with this Error Message:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Local Storage: /var/www/vhosts/...' for key 'name' (SQL: insert into tblstorageconfigurations(is_local, name, handler, settings, sort_order, updated_at, created_at) values (1, Local Storage: /var/www/vhosts/.../whmcs/downloads, WHMCS\File\Provider\LocalStorageProvider, {"local_path":"\/var\/www\/vhosts\/...\/whmcs\/downloads"}, 4, 2019-01-24 09:05:27, 2019-01-24 09:05:27))

Any Idea how to resolve this?

Thanks.

[WHMCS John]

Hi @grimmcreative,

This error is caused by invalid or duplicate directory entries in the configuration.php file.

I've written a help article which explains how to resolve this and complete the update process: https://help.whmcs.com/m/85428/l/1039448-troubleshooting-duplicate-entry-local-storage-errors

[grimmcreative]

2 minutes ago, WHMCS John said:

Hi @grimmcreative,

This error is caused by invalid or duplicate directory entries in the configuration.php file.

I've written a help article which explains how to resolve this and complete the update process: https://help.whmcs.com/m/85428/l/1039448-troubleshooting-duplicate-entry-local-storage-errors

Ah ok.

i looked into my configuration.php File and there are no entries for folders :D

JUST THIS:
<?php
$license = 'Leased-xxxx';
$db_host = 'localhost';
$db_username = 'xxx';
$db_password = 'xxx';
$db_name = 'xxx';
$cc_encryption_hash = 'xxxx';
$templates_compiledir = 'templates_c';
$mysql_charset = 'utf8';
$display_errors = true;

Will try out to implement it and process an upgrade again. 
Thanks for quick Support.

[grimmcreative]

I followed the given Steps.
Now i get a different Error Message:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'client_files' for key 'asset_type' (SQL: insert into `tblfileassetsettings` (`asset_type`, `storageconfiguration_id`, `updated_at`, `created_at`) values (client_files, 2, 2019-01-24 12:36:31, 2019-01-24 12:36:31))

[grimmcreative]

Update: Did the TRUNCATE on tblstorageconfigurations and tblfileassetsettings 

then Upgrade was able to finish 🙂

[tuganet]

On 1/24/2019 at 12:45 PM, grimmcreative said:

Update: Did the TRUNCATE on tblstorageconfigurations and tblfileassetsettings 

then Upgrade was able to finish 🙂

Hi, i'm having the same issue.   Can u explain this step you have done?

Thanks

Joaquim