Overview

One of the errors below might appear when trying to update a user or when creating a new one (either from the Staff Panel or when a new user attempts to register from the Support Center).

• AutoExecute Query: INSERT swusers ...
• AutoExecute Query: UPDATE swusers ...
  
  

Solution

This is due to the database using strict mode, and to resolve this problem one needs to disable it. Review the Disabling MySQL Strict Mode on the Server article for further instructions.