PHP MYSQL errors
-
[09-Apr-2017 06:16:10 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 ‘searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%mysite.net%” AN’ at line 3 for query
SELECT REPLACE( SUBSTRING_INDEX( SUBSTRING_INDEX( SUBSTRING_INDEX( referer, “://”, -1 ), “/”, 1 ), “.”, -5 ), “www.”, “” ) AS referer_calculated, COUNT(*) counthits
FROM wpTABLE_slim_stats
WHERE searchterms IS NOT NULL searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%mysite.net%” AND dt BETWEEN 1491004800 AND 1491722168
GROUP BY referer_calculated
ORDER BY counthits DESC
LIMIT 0, 1000 made by wp_dashboard, do_meta_boxes, call_user_func, wp_slimstat_reports::callback_wrapper, call_user_func, wp_slimstat_reports::raw_results_to_html, call_user_func, wp_slimstat_db::get_top, wp_slimstat_db::get_results
[12-Apr-2017 05:41:32 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 ‘searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%myothersite’ at line 3 for query
SELECT REPLACE( SUBSTRING_INDEX( SUBSTRING_INDEX( SUBSTRING_INDEX( referer, “://”, -1 ), “/”, 1 ), “.”, -5 ), “www.”, “” ) AS referer_calculated, COUNT(*) counthits
FROM TABLE2_slim_stats
WHERE searchterms IS NOT NULL searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%myothersite.com%” AND dt BETWEEN 1491004800 AND 1491979290
GROUP BY referer_calculated
ORDER BY counthits DESC
LIMIT 0, 1000 made by wp_dashboard, do_meta_boxes, call_user_func, wp_slimstat_reports::callback_wrapper, call_user_func, wp_slimstat_reports::raw_results_to_html, call_user_func, wp_slimstat_db::get_top, wp_slimstat_db::get_results
- The topic ‘PHP MYSQL errors’ is closed to new replies.