HTTP 500 Error When Customers Try to Edit Listings

  • Jennifer
    Jennifer
    June 27, 2019 at 3:09 pm

    I also have a support ticket in on this issue, but since it’s been taking a while to get an answer, hoping I can get some help here.

    Classified Theme Version 8.9.6 (working beautifully for years)
    On the Admin side, everything is working 100%

    On the User/Customer Side, they are receiving HTTP 500 Internal Server Error when they try to View/Edit their own listing through their Dashboard.
    50% of the time, they receive the same error when trying to view any listing on the site, not just their own.
    There doesn’t appear to be any issue with Adding New Listings.

    Not sure how long this has been an issue, as the site functions normally on the admin side, and new listings were being submitted successfully by customers. Just the other day a customer reached out to me to let me know they were experiencing issues with the site. I created a customer account and saw the same errors they were experiencing.
    A recent error log attached that you guys can probably understand better than me.
    site; http://www.floridasporthorse.com

    Help! (and thank you!)

  • Jennifer
    Jennifer
    June 27, 2019 at 3:15 pm

    File size was too big for error log and couldn’t edit original post.
    Short Excerpt of Error Log-

    [14-Jun-2019 02:24:05 America/New_York] WordPress database error Unknown column ‘wp_postmeta.meta_value’ in ‘order clause’ for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (

    wp_term_relationships.term_taxonomy_id IN (212)

    ) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘revision’, ‘nav_menu_item’, ‘custom_css’, ‘customize_changeset’, ‘oembed_cache’, ‘user_request’, ‘wp_block’, ‘listing_type’, ‘wlt_message’, ‘wlt_banner’, ‘wlt_campaign’, ‘wlt_feedback’, ‘elementor_library’) AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 desc LIMIT 0, 20 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

    [14-Jun-2019 03:23:57 America/New_York] WordPress database error Unknown column ‘wp_postmeta.meta_value’ in ‘order clause’ for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (

    wp_term_relationships.term_taxonomy_id IN (624)

    ) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘revision’, ‘nav_menu_item’, ‘custom_css’, ‘customize_changeset’, ‘oembed_cache’, ‘user_request’, ‘wp_block’, ‘listing_type’, ‘wlt_message’, ‘wlt_banner’, ‘wlt_campaign’, ‘wlt_feedback’, ‘elementor_library’) AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 desc LIMIT 0, 20 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

    [14-Jun-2019 03:27:37 America/New_York] PHP Warning: Illegal string offset ‘class’ in /home/floridas/public_html/wp-content/themes/CT/framework/class/class_shortcodes.php on line 1796

    [14-Jun-2019 03:27:37 America/New_York] PHP Warning: Cannot assign an empty string to a string offset in /home/floridas/public_html/wp-content/themes/CT/framework/class/class_shortcodes.php on line 1796

    [14-Jun-2019 03:27:37 America/New_York] PHP Warning: Illegal string offset ‘class’ in /home/floridas/public_html/wp-content/themes/CT/framework/class/class_shortcodes.php on line 1823

  • Jennifer
    Jennifer
    June 27, 2019 at 5:04 pm

    Better Error Log attached of today’s errors.

    Attachments:
    You must be logged in to view attached files.
Viewing 3 posts - 1 through 3 (of 3 total)

Copyright © 2010-2020 PremiumPress Limited.

secure payments