WRONG SQL SYNTAX

  • Resolved tripflex

    (@tripflex)


    9 years, 9 months ago

    All of your direct $wpdb query calls are incorrect. If you’re doing a select from a specific table, you should be using the $wpdb global, not specifically wp_comments or wp_postmeta

    Example your incorrect code:
    $most_sell_courses = $wpdb->get_results( "SELECT 'meta_value', 'post_id' FROM 'wp_postmeta' WHERE 'meta_key' LIKE '%total_sales%' and meta_value > 0", OBJECT );

    Correct code:
    $most_sell_courses = $wpdb->get_results( "SELECT 'meta_value', 'post_id' FROM $wpdb->postmeta WHERE 'meta_key' LIKE '%total_sales%' and meta_value > 0", OBJECT );

    Basically anywhere you are specifically using wp_XXX you need to use $wpdb->prefix or just directly call $wpdb->XXX … reason being, if the standard wp_ prefix is not used, your plugin will not function at all.

    See documentation:
    https://codex.ww.wp.xz.cn/Class_Reference/wpdb

    https://ww.wp.xz.cn/plugins/woo-sensei-analytics/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter tripflex

    (@tripflex)

    9 years, 9 months ago

    I had to replace any of the ticks in the SQL code above with a standard ‘ as the ticks are used on here to create code blocks, but you should still get the point

    Plugin Author WPExperts.io

    (@wpexpertsio)

    9 years, 9 months ago

    Hi Tripflex!

    Really appreciate for sharing this. You are absolutely right that this is really important thing which should not be neglect. We will fix and update this plugin soon.

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WRONG SQL SYNTAX’ is closed to new replies.