PHP 8 Error

  • The plugin throws the following error when I attempt to enable it while running PHP 8 (note that my local directory structure has been replaced with “…”). It almost appears to be a WordPress error, and not a Better Messages error, however, none of my other plugins are throwing this error.

    Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF' at line 1 in /.../wp-includes/wp-db.php:2056 Stack trace: #0 /.../wp-includes/wp-db.php(2056): mysqli_query() #1 /.../wp-includes/wp-db.php(1945): wpdb->_do_query() #2 /.../wp-includes/wp-db.php(2695): wpdb->query() #3 /.../wp-admin/includes/upgrade.php(2749): wpdb->get_results() #4 /.../wp-content/plugins/bp-better-messages/inc/install.php(101): dbDelta() #5 /.../wp-includes/class-wp-hook.php(303): bpbp_install_tables() #6 /.../wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters() #7 /.../wp-includes/plugin.php(470): WP_Hook->do_action() #8 /.../wp-content/plugins/bp-better-messages/inc/install.php(115): do_action() #9 /.../wp-includes/class-wp-hook.php(303): bp_better_messages_activation() #10 /.../wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters() #11 /.../wp-includes/plugin.php(470): WP_Hook->do_action() #12 /.../wp-admin/plugins.php(193): do_action() #13 {main} thrown in /.../wp-includes/wp-db.php on line 2056

    • This topic was modified 3 years, 4 months ago by Llewen.
Viewing 7 replies - 16 through 22 (of 22 total)
  • Thread Starter Llewen

    (@llewen)

    Getting a little frustrated. My apologies. The problem is that Debian support, even on Debian Testing, isn’t full featured for PHP 8.1. The imagick module for PHP 8.1 hasn’t yet been released.

    Plugin Author wordplus

    (@wordplus)

    I didnt tested with PHP8.1, only with PHP8.0.

    “You have an error in your SQL syntax” its error returned by MySQL, not PHP.

    Did you tried with latest version of plugin?

    Thread Starter Llewen

    (@llewen)

    I’m going to try php8.0. The imagick plugins is available for php8.0.

    Plugin Author wordplus

    (@wordplus)

    how is imagick plugin related to mysql error?

    Thread Starter Llewen

    (@llewen)

    I don’t know, but imagick is a required plugin for WordPress, and it is missing, so I’m guessing that is the issue. If not then it is an SQL syntax error that 8.1 is catching that 8.0 didn’t.

    Thread Starter Llewen

    (@llewen)

    That’s the basic issue, I’m using PHP 8.1, not PHP 8.0. I foolishly assumed there would be nothing major code breaking between PHP 8.0 and PHP 8.1. But it would appear that there is. So the thread isn’t named properly, it should be PHP 8.1, not PHP 8…

    Thread Starter Llewen

    (@llewen)

    In answer to your earlier question, all my plugins are up to date with the latest available from WP.

Viewing 7 replies - 16 through 22 (of 22 total)
  • The topic ‘PHP 8 Error’ is closed to new replies.