By phanikanth7 on

The `SYSTEM` table was deprecated in MYSQL 8.0.

'SYSTEM` table used in _OAUTH_COMMON_VERSION (OAUTH_COMMON.MODULE) in DRUPAL OAUTH 1.0.

Please help me what is the alternative way.

⋅ Categories: Drupal 7.x

Comments

jaypan’s picture

jaypan
Location Victoria, BC
commented

PHP 8 requires a minimum of Drupal 7.79. You will need to update to a newer version of Drupal 7:

https://www.drupal.org/docs/7/system-requirements/php-requirements-for-d...

Contact me to contract me for D7 -> D10/11 migrations.

phanikanth7’s picture

phanikanth7 commented

Yes, I agree need to upgrade PHP 7 to PHP 8. 

But we need an immediate fix for the `SYSTEM` table on Drupal PHP 7+MYSQL 8.0

Could you please let me know how to fix it on Drupal PHP 7+MYSQL8.0?

jaypan’s picture

jaypan
Location Victoria, BC
commented

What version of Drupal are you on? Go to Admin -> Reports -> Status Report, and it will tell you the specific Drupal version.

Contact me to contract me for D7 -> D10/11 migrations.

phanikanth7’s picture

phanikanth7 commented

Drupal version 7.59. Thank you very much for quick reply.

jaypan’s picture

jaypan
Location Victoria, BC
commented

You have a conflict. Drupal 7.54 is not compatible with PHP 8. So you have two options:

  1. Upgrade Drupal to a version compatible with PHP 8. This means a minimum of Drupal 7.79 for PHP 8.0, a minimum of Drupal 7.92 for PHP 8.1, or Drupal 7.94 for PHP 8.2, or
  2. Downgrade PHP to PHP 7.3 (which is the last version of PHP that Drupal 7.54 is compatible with

(See https://www.drupal.org/docs/7/system-requirements/php-requirements-for-d...)

If you need a path to PHP 8 compatibility, it would be:

  1. Update Drupal to the current version of Drupal 7
  2. Update PHP to PHP 8

Contact me to contract me for D7 -> D10/11 migrations.

phanikanth7’s picture

phanikanth7 commented

Thank you very much for your support. Currently, we have installed the below versions.

  • Drupal version 7.59
  • PHP 7.1.33
  • MYSQL 8.0.

Without upgrade or downgrade can we resolve the 'SYSTEM' table issue? Is there any alternative way? Could you please help me?

gisle’s picture

gisle
he/him
Primary language Norwegian Bokmål
Location Norway
commented

Without upgrade or downgrade can we resolve the 'SYSTEM' table issue?

No.

You must to upgrade your version of Drupal or downgrade your version of PHP to solve this problem.

Is there any alternative way?

No.

Sorry to be the bearer of bearer of bad news.

- gisle

jaypan’s picture

jaypan
Location Victoria, BC
commented
  1. Downgrade to PHP 7.3
  2. Update Drupal to the current version of Drupal 7
  3. Update PHP to PHP 8

Contact me to contract me for D7 -> D10/11 migrations.