Incompatible with MySQL >= 8.0.2

  • Hey,

    Version 1.2.0 of the plugin is not compatible with MySQL >= 8.0.2.

    Maybe there are other problems, but at least one is this error:

    
[26-Mar-2019 14:42:46 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, data, points, postid, timestamp) VALUES
		( '24', 'user_page_view', 'Baby' at line 1 for query INSERT INTO wp_achievements (uid, type, rank, data, points, postid, timestamp) VALUES
		( '24', 'user_page_view', 'Baby Owl', '', '1', '1319', '1553611366' ) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/theme/page.php'), get_footer, locate_template, load_template, require_once('/themes/theme/footer.php'), wp_footer, do_action('wp_footer'), WP_Hook->do_action, WP_Hook->apply_filters, wpachievements_wordpress_page_view, WPAchievements_Trigger::new_activity

    “Rank” is a reserved keyword starting with MySQL 8.0.2 (https://dev.mysql.com/doc/refman/8.0/en/keywords.html). Thus it should be quoted.

    Best
    Christian

  • The topic ‘Incompatible with MySQL >= 8.0.2’ is closed to new replies.