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_brand_tabs[1530]

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 ')' at line 2

Error information:

 SELECT DISTINCT store.id FROM ms_store store LEFT JOIN ms_currency curr ON store.price_curr_id = curr.id
                    LEFT JOIN ms_topic_store topic_store ON topic_store.store_id = store.id WHERE store.no_visible=0 AND store.kind_key IN('kDefault', 'kCertificate') AND store.status_key <> 'kDiscontinued' AND topic_store.topic_id IN(87) AND store.brand_id IN () 



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