Database Error messages from Site Analysis Reports
-
Site Analysis > Recent Posts
WordPress database error: [You have an error in your SQL syntax; check the manual …….. (see full text below)Site Analysis > Top Posts
WordPress database error: [You have an error in your SQL syntax; check the manual …………. (see full text below)PHP version: 5.3.29 Mysql is 5.5.23 or higher
Full text of error messages
———————————-Recent Posts
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 ‘=> “post” AND (dt BETWEEN 1430438400 AND 1432163504) GROUP BY resource ‘ at line 5]
SELECT t1.* FROM ( SELECT resource, MAX(id) maxid FROM wp_slim_stats WHERE resource IS NOT NULL AND content_type => “post” AND (dt BETWEEN 1430438400 AND 1432163504) GROUP BY resource ) AS ts1 INNER JOIN wp_slim_stats t1 ON ts1.maxid = t1.id ORDER BY t1.dt DESC LIMIT 0, 1000Top Posts
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 ‘=> “post” AND (dt BETWEEN 1430438400 AND 1432163504) GROUP BY resource ‘ at line 3]
SELECT resource, COUNT(*) counthits FROM wp_slim_stats WHERE resource IS NOT NULL AND content_type => “post” AND (dt BETWEEN 1430438400 AND 1432163504) GROUP BY resource ORDER BY counthits DESC LIMIT 0, 1000
- The topic ‘Database Error messages from Site Analysis Reports’ is closed to new replies.