Support Tickets - DB Error

DB Error

CMS 13.02.2016 631 Bug Report Status: Closed Solution: Yes trivuztech


This error showing while tying to change ecommerce widget settings and some other section as well.


Replies (4)

  • avatar trivuztech

    btw.. could you please make this ticket private?

    13.02.2016 0
  • avatar Jerome

    Thank you for opening a support ticket.

    That is indeed a bug, please open following file plugins/ecommerce/admin/shop.php and find:

    $result = $jakdb->query('UPDATE '.DB_PREFIX.'setting SET value = CASE varname
    WHEN "e_title" THEN "'.smartsql($defaults['jak_title']).'"
    WHEN "e_desc" THEN "'.smartsql($defaults['jak_lcontent']).'"
    WHEN "e_shop_shop" THEN "'.smartsql($defaults['jak_shop']).'"
    WHEN "e_shop_shop_b" THEN "'.smartsql($defaults['jak_shop_b']).'"
    WHEN "e_shop_shop_bt" THEN "'.smartsql($defaults['jak_shop_bt']).'"
    WHEN "e_thanks" THEN "'.smartsql($defaults['jak_thankyou']).'"
    WHEN "shopemail" THEN "'.smartsql($defaults['jak_email']).'"
    WHEN "shopdateformat" THEN "'.smartsql($defaults['jak_date']).'"
    WHEN "shoptimeformat" THEN "'.smartsql($defaults['jak_time']).'"
    WHEN "shopurl" THEN '.$defaults['jak_shopurl'].'
    WHEN "e_productopen" THEN '.$defaults['jak_itemopen'].'
    WHEN "e_agreement" THEN '.$defaults['jak_wcatid'].'
    WHEN "shoprss" THEN "'.smartsql($defaults['jak_rssitem']).'"
    WHEN "e_currency" THEN "'.smartsql($defaults['jak_currency']).'"
    WHEN "e_currency1" THEN "'.smartsql($defaults['jak_currency1']).'"
    WHEN "e_currency2" THEN "'.smartsql($defaults['jak_currency2']).'"
    WHEN "e_shop_download" THEN "'.smartsql($defaults['jak_download']).'"
    WHEN "e_shop_download_b" THEN "'.smartsql($defaults['jak_download_b']).'"
    WHEN "e_shop_download_bt" THEN "'.smartsql($defaults['jak_download_bt']).'"
    WHEN "e_taxes" THEN "'.smartsql($defaults['jak_taxes']).'"
    WHEN "shoppagemid" THEN "'.smartsql($defaults['jak_mid']).'"
    WHEN "shoppageitem" THEN "'.smartsql($defaults['jak_item']).'"
    WHEN "e_shop_address" THEN "'.smartsql($defaults['jak_address']).'"
    WHEN "e_country" THEN "'.smartsql($defaults['jak_country']).'"
    END
    WHERE varname IN ("e_title", "e_desc", "e_shop_shop", "e_shop_shop_b", "e_shop_shop_bt", "e_thanks", "shopemail", "shopdateformat", "shoptimeformat", "shopurl", "e_productopen", "e_agreement", "shoprss", "e_currency", "e_currency1", "e_currency2", "e_shop_download", "e_shop_download_b", "e_shop_download_bt", "e_taxes", "shoppagemid", "shoppageitem", "e_shop_address", "e_country")');

    replace with:

    $result = $jakdb->query('UPDATE '.DB_PREFIX.'setting SET value = CASE varname
    WHEN "e_title" THEN "'.smartsql($defaults['jak_title']).'"
    WHEN "e_desc" THEN "'.smartsql($defaults['jak_lcontent']).'"
    WHEN "e_thanks" THEN "'.smartsql($defaults['jak_thankyou']).'"
    WHEN "shopemail" THEN "'.smartsql($defaults['jak_email']).'"
    WHEN "shopdateformat" THEN "'.smartsql($defaults['jak_date']).'"
    WHEN "shoptimeformat" THEN "'.smartsql($defaults['jak_time']).'"
    WHEN "shopurl" THEN "'.smartsql($defaults['jak_shopurl']).'"
    WHEN "e_productopen" THEN "'.smartsql($defaults['jak_itemopen']).'"
    WHEN "e_agreement" THEN "'.smartsql($defaults['jak_wcatid']).'"
    WHEN "shoprss" THEN "'.smartsql($defaults['jak_rssitem']).'"
    WHEN "e_currency" THEN "'.smartsql($defaults['jak_currency']).'"
    WHEN "e_currency1" THEN "'.smartsql($defaults['jak_currency1']).'"
    WHEN "e_currency2" THEN "'.smartsql($defaults['jak_currency2']).'"
    WHEN "e_shop_download" THEN "'.smartsql($defaults['jak_download']).'"
    WHEN "e_shop_download_b" THEN "'.smartsql($defaults['jak_download_b']).'"
    WHEN "e_shop_download_bt" THEN "'.smartsql($defaults['jak_download_bt']).'"
    WHEN "e_taxes" THEN "'.smartsql($defaults['jak_taxes']).'"
    WHEN "shoppagemid" THEN "'.smartsql($defaults['jak_mid']).'"
    WHEN "shoppageitem" THEN "'.smartsql($defaults['jak_item']).'"
    WHEN "e_shop_address" THEN "'.smartsql($defaults['jak_address']).'"
    WHEN "e_country" THEN "'.smartsql($defaults['jak_country']).'"
    END
    WHERE varname IN ("e_title", "e_desc", "e_thanks", "shopemail", "shopdateformat", "shoptimeformat", "shopurl", "e_productopen", "e_agreement", "shoprss", "e_currency", "e_currency1", "e_currency2", "e_shop_download", "e_shop_download_b", "e_shop_download_bt", "e_taxes", "shoppagemid", "shoppageitem", "e_shop_address", "e_country")');

    That should fix it.

    13.02.2016 0
  • avatar trivuztech

    Thank yo verymuch! Appriciated (y)

    14.02.2016 0
  • avatar Jerome

    Thank you for the feedback.

    *** Ticket closed ***

    15.02.2016 0