Storage Setting Test Error

[Md Rasel Khan]

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.

[Md Rasel Khan]

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.

[WHMCS Dan]

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.