m using BAStats plugin , recently I happen to view my Graph (top page hits) and this error came ..
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 '-1' at line 1]
SELECT page_id, page_string, page_label, count(page_id) AS Count
FROM wp_bas_pages, wp_bas_log WHERE page = page_id GROUP BY page_id ORDER BYCount
DESC LIMIT -1
Warning: Invalid argument supplied for foreach() in /home/sreejith/public_html/wp-content/plugins/BAStats/BAStats.php on line 220
its working fine in others
- The topic ‘You have an error in your SQL syntax;’ is closed to new replies.