A WordPress plugin that uses Google Analytics data to determine the most popular posts on your site and display a list of popular posts via the included widget.
When running the job manually from the admin with "update google analytics" I get the following output:
Running cron...
Beginning analyticbridge_cron...
Making a call to ga:get...
returned report:
- itemsPerPage: 1000
- row count: 3
Notice: Array to string conversion in pluginsfolder/ga-popular-posts/analytic-bridge.php on line 191
Notice: Array to string conversion in pluginsfolder/ga-popular-posts/analytic-bridge.php on line 191
Notice: Array to string conversion in pluginsfolder/ga-popular-posts/analytic-bridge.php on line 191
WordPress databasefout: [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 'ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id)' at line 2]
INSERT INTO `wp_analyticbridge_pages` (pagepath, post_id) VALUES
ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id)
WordPress databasefout: [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 'ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id),`querytime`=values(querytime),`v' at line 2]
INSERT INTO `wp_analyticbridge_metrics` (page_id,startdate,enddate,querytime,metric,value) VALUES
ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id),`querytime`=values(querytime),`value`=values(value)
Making a call to ga:get...
returned report:
- itemsPerPage: 1000
- row count: 4
Notice: Array to string conversion in pluginsfolder/ga-popular-posts/analytic-bridge.php on line 191
Notice: Array to string conversion in pluginsfolder/ga-popular-posts/analytic-bridge.php on line 191
Notice: Array to string conversion in pluginsfolder/ga-popular-posts/analytic-bridge.php on line 191
Notice: Array to string conversion in pluginsfolder/ga-popular-posts/analytic-bridge.php on line 191
WordPress databasefout: [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 'ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id)' at line 2]
INSERT INTO `wp_analyticbridge_pages` (pagepath, post_id) VALUES
ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id)
WordPress databasefout: [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 'ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id),`querytime`=values(querytime),`v' at line 2]
INSERT INTO `wp_analyticbridge_metrics` (page_id,startdate,enddate,querytime,metric,value) VALUES
ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id),`querytime`=values(querytime),`value`=values(value)
Google Analytics Popular Posts cron executed successfully
End analyticbridge_cron
This process used 61 ms for its computations
It spent 10 ms in system calls
When running the job manually from the admin with "update google analytics" I get the following output: