Jump to content

Recommended Posts

Today I moved my WHMCS from Namecheap shared hosting to SiteGround web hosting. Everything is working fine but getting en error when I click to test Storage Settings after editing new path/directory.

Quote

Error
Configuration settings could not be verified. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_error' in 'field list' (SQL: update `tblstorageconfigurations` set `updated_at` = 2020-04-30 22:32:39, `last_error` = where `id` = 12)

Check the attachment to better understand.

Screenshot_4.png

Share this post


Link to post
Share on other sites

I fixed this issue. There are is a column is missing after updating to 7.10. That's why getting this error. This issue does not appear after moved to new hosting. It appears after updating to version 7.10. How did I understand that? Okay, after posting this issue, I again moved to old hosting, then facing the same error. Then I revert the older version & check storageconfiguration table of MySQL Database, and I see the "last_error" column not available on the new database. Then I added it manually, and it's working now.

Check the attachment to better understand.

Screenshot_5.png

Share this post


Link to post
Share on other sites

Hi there,

This would usually indicate there was a problem applying the necessary database changes during the update process.

It looks like you've resolved the issue yourself now, but if you'd like us to take a look and confirm there are no other database issues please don't hesitate to open a ticket and we can take a look for you.

Share this post


Link to post
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