Error The website encountered an unexpected error. Please try again later. Error message PDOException: SQLSTATE: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' in lock_may_be_available() (line 167 of /httpdocs/includes/lock.inc).
I am getting the above error after deploying a website on server.
Basically, I created a Drupal website on local server. After finishing it, I generate the database script and run it on live server using phpmyadmin. and then I upload and files on server and change the setting file for database connectivity.
Once I tried to access the website, I am getting the above error like I said before.
I find this solution. but because I am running a dedicated server and don't want to update phpmyadmin. So, I am looking for way around.