Error messages

  • Resolved John

    (@dsl225)


    3 months ago

    I’m getting those errors on server every now and then but everything works fine. Looks like they show up when there are orders but not sure:

    [27-Aug-2024 02:58:56 UTC] WordPress database error Unknown column ‘wp_posts.ID’ in ‘field list’ for query SELECT
    COUNT(wp_posts.ID) AS order_count,
    SUM(meta_total.meta_value) AS total
    FROM sxixeevau_posts
    JOIN sxixeevau_postmeta AS meta_total ON wp_posts.ID = meta_total.post_id
    JOIN sxixeevau_postmeta AS meta_mode ON wp_posts.ID = meta_mode.post_id
    WHERE sxixeevau_posts.post_type = ‘sunshine-order’
    AND meta_mode.meta_key = ‘mode’
    AND meta_mode.meta_value = ‘live’
    AND meta_total.meta_key = ‘total’ made by require_once(‘wp-admin/admin.php’), do_action(‘sunshine-gallery_page_sunshine-update’), WP_Hook->do_action, WP_Hook->apply_filters, SPC_Update->update_page, SPC_Update->common_updates, sunshine_tracking_send

    [27-Aug-2024 02:58:56 UTC] WordPress database error Unknown column ‘wp_posts.ID’ in ‘field list’ for query SELECT
    COUNT(DISTINCT wp_posts.ID) AS order_count,
    SUM(meta_total.meta_value) AS total
    FROM sxixeevau_posts
    JOIN sxixeevau_postmeta AS meta_total ON wp_posts.ID = meta_total.post_id AND meta_total.meta_key = ‘total’
    JOIN sxixeevau_postmeta AS meta_payment ON wp_posts.ID = meta_payment.post_id AND meta_payment.meta_key = ‘payment_method’ AND meta_payment.meta_value = ‘paypal’
    JOIN sxixeevau_postmeta AS meta_mode ON wp_posts.ID = meta_mode.post_id AND meta_mode.meta_key = ‘mode’ AND meta_mode.meta_value = ‘live’
    WHERE sxixeevau_posts.post_type = ‘sunshine-order’
    made by require_once(‘wp-admin/admin.php’), do_action(‘sunshine-gallery_page_sunshine-update’), WP_Hook->do_action, WP_Hook->apply_filters, SPC_Update->update_page, SPC_Update->common_updates, sunshine_tracking_send

Viewing 1 replies (of 1 total)
  • Plugin Author WP Sunshine

    (@wpsunshine)

    Thanks for pointing this out, I have found the issue and will have it fixed in the next update.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.