View Single Post
  #1  
Old 04-13-2009, 03:50 PM
 
Christofer Christofer is offline
 

eXpert
  
Join Date: Apr 2009
Location: Thessaloniki, Greece
Posts: 202
 

Default Weird smarty error about currency?

I am getting this error while browsing categories and inside the product listing :
Our price: €10.00 (Warning: Smarty error: math ``altercurrencyvalue*rate'' in ``customer/home.tpl'': parameter ``rate'' is not numeric in /var/www/vhosts/gsmcorner.gr/httpdocs/include/lib/smarty/Smarty.class.php on line 1092
$)

By the way i made those changes you see in that post, but when i saw the error i finished the 3 files from skin1_original and put them back to skin1 to see if the changed i made was makign that error, but the error remains with the original files too..

by the way i tried to do checkout now and i get this on top of page :
INVALID SQL: 1064 : 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 '00 / 100) as surcharge FROM xcart_payment_methods WHERE paymentid='0' AND paymen' at line 1
SQL QUERY FAILURE:SELECT IF (surcharge_type='$', surcharge, surcharge * 20,00 / 100) as surcharge FROM xcart_payment_methods WHERE paymentid='0' AND payment_script!='payment_giftcert.php'
INVALID SQL: 1064 : 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 '00 / 100) as surcharge FROM xcart_payment_methods WHERE paymentid='0' AND paymen' at line 1
SQL QUERY FAILURE:SELECT IF (surcharge_type='$', surcharge, surcharge * 20,00 / 100) as surcharge FROM xcart_payment_methods WHERE paymentid='0' AND payment_script!='payment_giftcert.php'

i didn't made any changes to my e-shop template, i think the problem comes from the second language charset or ??
__________________
X-Cart Gold : 4.2.1 (on linux parallels plesk / mysql)
Php v5.2.9 (Zend: 2.2.0) - MySql v5.0.79 - LiteSpeed server
Modules : X-Offer & X-Aom & One page checkout
Product tabs & Product downloads & many more
Reply With Quote