Category: MySQL
-
Drupal 7 issue with SQL Mode TRADITIONAL
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1231 Variable ‘sql_mode’ can’t be set to the value of ‘TRADITIONAL’ in lock_may_be_available() (line 165 of /includes/lock.inc). This was the case when I installed Drupal 7 with Cpanel/Fantastico, the drupal site was displaying the above error. This issue is discussed at drupal issues . try to patch it…
-
Mysql backup script
Ensuring data integrity and security is paramount. Regular backups play a crucial role in safeguarding your MySQL databases against unforeseen disasters