Forum

Hi Mark,

Because I have a fairly custom website I found that the new version introduced a new bug causing the plugin to show an unsightly SQL error on some of my custom pages! (because on my custom pages $post->ID is null)

The solution was to edit frontend.php – adding some simple error checking in the function sb_add_headers()

i.e. change line (around) 443 from:

$pageid = $wpdb->get_var("SELECT ID FROM {$wpdb->posts} WHERE post_content LIKE '%[sermons%' AND (post_status = 'publish' OR post_status = 'private') AND ID={$post->ID} AND post_date < NOW();");

TO:

$pageid = NULL;
if ($post->ID != '') $pageid = $wpdb->get_var("SELECT ID FROM {$wpdb->posts} WHERE post_content LIKE '%[sermons%' AND (post_status = 'publish' OR post_status = 'private') AND ID={$post->ID} AND post_date < NOW();");

This change doesn't seem to affect any of the other operation and is similar to how you error-checked sb_display_url around line 40.