08 Nov 2016

System.Data.SqlClient.SqlException: Invalid object name ‘Users’.

Error Message

System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries.
See the inner exception for details. —> System.Data.Entity.Core.UpdateException:
An error occurred while updating the entries. See the inner exception for details. —>
System.Data.SqlClient.SqlException: Invalid object name ‘Users’.

Icon
P20160513_159

After updating to 3.1.1001 from an earlier version you cannot create or update users: Invalid object name 'Users'.

Solution One

This issue was caused by an old trigger left on the user?s table which was still pointing to the Users table (which was renamed to cp_Users in 3.1.1000).

When you download the hotfix open SQL Managment Studio and connect to your CloudPanel database. Run the script to remove the old trigger and extra tables that do not belong in the database anymore.