Unknown Column 'sp.inline' in 'field list'
-
Since the last update (1.8.0.47), I’ve been getting a repeating error message in my error logs that says:
Unknown Column 'sp.inline' in 'field list'
It’s coming in very frequently; almost every minute. And when the error is generated, it generates several messages in the exact same second, which makes me think it’s related to a function that applies to each ad on the page.
This error doesn’t seem to be stopping the ads from showing, but it is something that concerns me. Do you know what might be the source of this problem?
Here’s an extended example of the message I’m receiving:
[09-May-2016 13:49:42 UTC] WordPress database error Unknown column 'sp.inline' in 'field list' for query SELECT ua.pid, ua.aid, ua.code_before, ua.code_after, ua.asize, ua.width, ua.height, ua.img, ua.link, ua.alt, ua.acode, ua.rel, ua.php, ua.inline, ua.ad_server, ua.dfp, ua.amode, ua.clicks, ua.adCycle, ua.block_children, ua.limit_hits, ua.hits_limit, ua.hits_period, ua.limit_clicks, ua.clicks_limit, ua.clicks_period, ua.swf, ua.swf_vars, ua.swf_params, ua.swf_attrs, ua.swf_fallback FROM (SELECT sp.pid, sp.aid, @code_before := sp.code_before AS code_before, @code_after := sp.code_after AS code_after, sp.asize, sp.width, sp.height, sp.img, sp.link, sp.alt, sp.acode, sp.rel, sp.php, sp.inline, sp.ad_server, sp.dfp, sp.amode, 0 AS clicks, IF(sp.ad_server OR (sp.sale AND sp.sale_mode = 0 AND NOT (NOW() BETWEEN sp.sdate AND sp.fdate)), -1.0, 2.0) AS adCycle, (sp.sale AND sp.sale_mode = 0 AND NOT (NOW() BETWEEN sp.sdate AND sp.fdate)) AS block_children, 0 AS limit_hits, 0 AS hits_limit, 0 AS hits_period, 0 AS limit_clicks, 0 AS clicks_limit, 0 AS clicks_period, 0 AS swf, NULL AS swf_vars, NULL AS swf_params, NULL AS swf_attrs, NULL AS swf_fallback FROM wp_sampro_places sp WHERE sp.pid = 8 UNION SELECT spa.pid, spa.aid, @code_before AS code_before, @code_after AS code_after, sa.asize, sa.width, sa.height, sa.img, sa.link, sa.alt, sa.acode, sa.rel, sa.php, sa.inline, 0 AS ad_server, 0 AS dfp, sa.amode, sa.clicks, IF(spa.weight, spa.hits*10/(spa.weight*1000), 0) AS adCycle, 0 AS block_children, sa.limit_hits, sa.hits_limit, sa.hits_period, sa.limit_clicks, sa.clicks_limit, sa.clicks_period, sa.swf, sa.swf_vars, sa.swf_params, sa.swf_attrs, sa.swf_fallback FROM wp_sampro_places_ads spa INNER JOIN wp_sampro_ads sa ON spa.aid = sa.aid WHERE spa.pid = 8 AND spa.trash < 1 AND sa.moderated > 0 AND spa.weight > 0 AND IF(sa.users = 0, TRUE, (sa.users_unreg = 1)) AND ((sa.ptype = 0) OR (sa.ptype = 1 AND (sa.ptypes+0 & 16512))) AND IF(sa.schedule, '2016-05-09 09:49:39' BETWEEN sa.sdate AND sa.fdate, TRUE)) ua NATURAL LEFT JOIN (SELECT wsst.pid, wsst.aid, SUM(wsst.hits) AS thits, SUM(wsst.clicks) AS tclicks FROM wp_sampro_stats wsst WHERE wsst.pid = 8 GROUP BY wsst.pid, wsst.aid) sst WHERE IF(ua.limit_hits, (sst.thits IS NULL OR ua.hits_limit >= sst.thits), TRUE) AND IF(ua.limit_clicks, (sst.tclicks IS NULL OR ua.clicks_limit >= sst.tclicks), TRUE) ORDER BY ua.adCycle LIMIT 1; made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mytheme/page-templates/page-events.php'), get_sidebar, locate_template, load_template, require_once('/themes/mytheme/sidebar-events.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, sam_pro_place_widget->widget, SamProPlace->__construct, SamProPlace->getData
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
- The topic ‘Unknown Column 'sp.inline' in 'field list'’ is closed to new replies.