Home Forums Sailing WordPress database error: [Unknown column 'completed_date' in 'where clause']

WordPress database error: [Unknown column 'completed_date' in 'where clause']

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #64944

    armesh
    Participant

    Freshly installed the theme on WordPress 4.4.2. Installed all required plugins & Imported the demo data and all working fine.

    However when I turn on WP_DEBUG and error reporting in wp-config.php I start to get this error on every page including wp-admin pages:

    WordPress database error: [Unknown column ‘completed_date’ in ‘where clause’]
    ( SELECT DATE(pm.meta_value) AS completed_date, ( SELECT SUM(ptt.meta_value) AS total FROM wp_posts pb INNER JOIN wp_postmeta AS pbl ON pb.ID = pbl.post_id AND pbl.meta_key = ‘_hb_booking_payment_completed’ INNER JOIN wp_postmeta AS ptt ON pb.ID = ptt.post_id AND ptt.meta_key = ‘_hb_total’ WHERE pb.post_type = ‘hb_booking’ AND DATE(pbl.meta_value) >= ‘2016-04-09’ AND DATE(pbl.meta_value) <= ‘2016-04-15’ AND DATE(pbl.meta_value) = completed_date ) AS total FROM wp_posts AS p INNER JOIN wp_postmeta AS pm ON p.ID = pm.post_id AND pm.meta_key = ‘_hb_booking_payment_completed’ WHERE p.post_type = ‘hb_booking’ AND p.post_status = ‘hb-completed’ AND DATE(pm.meta_value) >= ‘2016-04-09’ AND DATE(pm.meta_value) <= ‘2016-04-15’ GROUP BY completed_date )

    Am I missing something here?

    Attachments:
    You must be logged in to view attached files.

    Due to Privacy&Security matters, Replies to this topic are hidden and can only be seen by our supporters or the topic owner.

    Please create a new support topic for your issues.

    You can check how to Create an account and Create a Support topic here

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. You can click here

Best Deals
Get Eduma Now

For Only *
$439 $69

 
GRAB THE DEAL
* Hurry up! Offer ends this Friday!
close-link
ấdsa
ádasd
ádsad
Subscribe
Give it a try, you can unsubscribe anytime.
close-link
Download
LEARNPRESS
WordPress LMS
Download the best WordPress LMS now. Completely Free.
close-link
Learn More