bug: wordpress-2004-04-26.zip – categories.php

  • trying to edit the default category (renaming it) i came across this tiny bug in categories.php
    line: 130
    $wpdb->query("UPDATE $tablecategories SET cat_name = '$cat_name', category_nicename = '$category_nicename', category_description = '$category_description', category_parent = $cat WHERE cat_ID = $cat_ID");
    should be:
    $wpdb->query("UPDATE $tablecategories SET cat_name = '$cat_name', category_nicename = '$category_nicename', category_description = '$category_description', category_parent =' $cat' WHERE cat_ID = $cat_ID");
    —
    category_parent =’ $cat’ is missing the single quotes.

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

  • Fixed. You shouldn’t need quotes around integer values in SQL statements. What version of MySQL are you using?

    Thread Starter eke

    (@eke)

    mySQL 4.0.18
    on apache/win nt env.
    without quotes I get an SQL statement error. might be a WIN environment issue?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘bug: wordpress-2004-04-26.zip – categories.php’ is closed to new replies.