Jump to content

Upgrade fails 7.6.1 to 7.7 SQL Error


Recommended Posts

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.

Link to comment
Share on other sites

  • WHMCS Support Manager

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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))

Link to comment
Share on other sites

  • 1 year later...
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated