INN / doubleclick-for-wp

WordPress plugin for serving Google Ad Manager ads
https://wordpress.org/plugins/doubleclick-for-wp/
GNU General Public License v2.0
25 stars 11 forks source link

WP Database error in this widget #10

Closed benlk closed 8 years ago

benlk commented 9 years ago

Seen only on NPQ on vagrant.

[Tue Sep 01 16:29:29 2015] [error] [client 127.0.0.1] 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 'ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(id),`querytime`=values(querytime),`v' at line 27266 for query INSERT INTO `wp_56_analyticbridge_metrics` (page_id,startdate,enddate,querytime,metric,value) VALUES \n( \n\t\t\t\t\t\t\t(SELECT `id` from wp_56_analyticbridge_pages WHERE `pagepath`='/2015/08/28/values-in-your-organization-and-what-they-have-to-do-with-raising-money-part-1/'),\n\t\t\t\t\t\t\t'2015-08-31',\n\t\t\t\t\t\t\t'2015-08-31',\n\t\t\t\t\t\t\t'2015-09-01 17:29:27',\n\t\t\t\t\t\t\t'ga:sessions',\n\t\t\t\t\t\t\t'407')\n\t\t\t\t\t\t, \n( \n\t\t\t\t\t\t\t(SELECT `id` from wp_56_analyticbridge_pages WHERE `pagepath`='/2015/08/28/values-in-your-organization-and-what-they-have-to-do-with-raising-money-part-1/'),\n\t\t\t\t\t\t\t'2015-08-31',\n\t\t\t\t\t\t\t'2015-08-31',\n\t\t\t\t\t\t\t'2015-09-01 17:29:27',\n\t\t\t\t\t\t\t'ga:pageviews',\n\t\t\t\t\t\t\t'536')\n\t\t\t\t\t\t, \n( \n\t\t\t\t\t\t\t(SELECT `id` from wp_56_analyticbridge_pages WHERE `pagepath`='/2015/08/28/

And so on.

benlk commented 8 years ago

Wrong project. This should be in INN/analytics-bridge