Mysql Error

Viewing 3 replies - 1 through 3 (of 3 total)
  • mikebronner

    (@mikebronner)

    8 years, 2 months ago

    Getting this error as well. This is due to content quotes not being escaped, breaking SQL query quotes.

    gaswirth

    (@gaswirth)

    8 years, 1 month ago

    Also getting this. Any way to fix without going through each entry and removing quotation marks?

    andyuknetweb

    (@andyuknetweb)

    7 years, 9 months ago

    I solved this by changing line 77 from:

    $fix = $wpdb->query("UPDATE $wpdb->postmeta SET meta_value = '".$edited."' WHERE meta_id = ".$item->meta_id );

    to:

    $fix = $wpdb->query($wpdb->prepare("UPDATE $wpdb->postmeta SET meta_value = %s WHERE meta_id = %s", $edited, $item->meta_id));

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Mysql Error’ is closed to new replies.