Fatal error: Uncaught exception 'ErrorException' with message 'Error: FUNCTION FIX_PRICE_BY_CURRENCY already exists<br />Error No: 1304<br />CREATE FUNCTION FIX_PRICE_BY_CURRENCY(price decimal(15, 4), currency varchar(5)) RETURNS decimal
BEGIN
DECLARE new_price decimal;
DECLARE rate decimal;
SET new_price = price;
CASE
WHEN currency = 'UAH' THEN
SET new_price = price * (1.00000000 / 1.00000000);
WHEN currency = 'USD' THEN
SET new_price = price * (1.00000000 / 0.02205072);
WHEN currency = 'EUR' THEN
SET new_price = price * (1.00000000 / 0.01893939);
END CASE;
RETURN new_price;
END' in /home/snast/optomania.com.ua/www/system/database/mysqli.php:41
Stack trace:
#0 /home/snast/optomania.com.ua/www/vqmod/vqcache/vq2-system_library_db.php(29): DBMySQLi->query('CREATE FUNCTION...')
#1 /home/snast/optomania.com.ua/www/system/library/currency.php(272): DB->query('CREATE FUNCTION...')
#2 /home/snast/optomania.com.ua/www/system/library/currency.php(28): Currency->cre in /home/snast/optomania.com.ua/www/system/database/mysqli.php on line 41