Support Tickets - DB Error

btw.. could you please make this ticket private?

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.

Thank yo verymuch! Appriciated (y)

Thank you for the feedback.

*** Ticket closed ***