MySQL

I was migrating Drupal 7 website to a newer infrastructure (PHP 7.4) and during the migration process when tried to connect to the MySQL database  I faced following error - SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'. Here is the error code: Resolve all issues below to continue the installation. For help configuring your database server, see the installation handbook, or contact your hosting provider. Failed…

Drupal 6 was released in 2008 and Drupal 7 was released in 2011. While Drupal 6 is still used by some websites, it is important to upgrade to Drupal 7 as it provides improved performance, security updates, and new features. This article will guide you through the preparation process for upgrading Drupal 6 to Drupal 7. Backup your website Before making any changes, it is important to create a backup of your website. This will ensure that you can restore your website if something goes wrong…