eShop-> Products-> You have an error in your SQL syntax;

  • Resolved vasilissk

    (@vasilissk)


    13 years, 11 months ago

    Hello Elfin.

    I upload in new data base the new version 5.2.0 and I created a new demo page.

    When I checked the eShop-> Products-> I found this error on the bottom of the screen:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘where post_id=9 limit 1’ at line 1 for query select purchases from where post_id=9 limit 1 made by do_action, call_user_func_array, eshop_admin_products, eshop_products_manager

    This error multiplies it self for every page is listed and it desappears only when the <-Stock Control-> is “yes”

    Thank you.

    http://wordpress.org/extend/plugins/eshop/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter vasilissk

    (@vasilissk)

    13 years, 11 months ago

    Hello again.

    From a closer look it looks that there is not any table with the name <- _eshop_featured -> in the database, because there is no any entry to create <- eshop_featured-> table in <- install.php -> file, in order to create entries “yes” or “” for the <- eshop_produts.php-> file.

    There is create table <- _eshop_stock -> in install.php but there isn’t <- _eshop_featured ->.

    Hmm…
    I am thinking…
    I guess I need your help.

    Thank you.

    Thread Starter vasilissk

    (@vasilissk)

    13 years, 11 months ago

    Hello again.

    I did debuging in eshop_products.php file and in line , <- 312 ->
    there is this entry:

    }else{
    $available=’n/a’;
    }

    Repalce it with:

    }else{
    $stocktable=$wpdb->prefix .”eshop_stock”;
    $available=’n/a’;
    }

    The reason is the value <- $available=’n/a’ -> cannot find Array
    therefor when the Value is =”no” then the array loads first
    <- $stocktable=$wpdb->prefix .”eshop_stock”; ->
    and places in it the record.

    Please add this in your next version.

    Thank you.

    elfin

    (@elfin)

    13 years, 11 months ago

    I’ll look at it, thanks.

    elfin

    (@elfin)

    13 years, 11 months ago

    fixed some of this, can’t replicate the rest.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘eShop-> Products-> You have an error in your SQL syntax;’ is closed to new replies.