System error in Melbis Shop 6.1.1



Error occured in script work

Error occured, script stoped


Error type: MySQL Error

Source, line: Parser::tws_filters[515]

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 ') AND store.price > 0 AND store.no_visible=0' at line 6

Error information:

 SELECT MIN( IF(store.price_curr_id>0, IF(curr.multiplex>0, IF(curr.division=1, store.price/curr.multiplex, store.price*curr.multiplex), store.price), store.price) ) AS min,
                       MAX( IF(store.price_curr_id>0, IF(curr.multiplex>0, IF(curr.division=1, store.price/curr.multiplex, store.price*curr.multiplex), store.price), store.price) ) AS max 
                FROM ms_store store
                    LEFT JOIN ms_currency curr
                        ON curr.id = store.price_curr_id
                WHERE store.id IN(0,) AND store.price > 0 AND store.no_visible=0
                 



Melbis Shop © 2002-2012, http://www.melbis.com