MySQL 5.6.19 Error with inproper SELECT statement

  • Hello WP Statistic-Support,

    I’ve installed the latest WP Statistic Version 12.6.13, running on PHP 7.3 and MySQL 5.6.19. When opening a report, e.g. your Summary, the following Error is logged (silently):

    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 ” at line 1 für Abfrage SELECT page_id FROM wp_statistics_pages WHERE date = ‘2020-06-01’ AND type = ” AND id = von require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_Statistics_Rest->hit, WP_Statistics_Hits->Pages

    Seems to a problem with selecting the id?

    Best regards,

    Carsten

  • The topic ‘MySQL 5.6.19 Error with inproper SELECT statement’ is closed to new replies.