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_block_bestcomments[25]

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND sc.store_id = s.id AND LENGTH(sc.summary) > 80 ' at line 4

Error information:

 SELECT sc.id, sc.store_id, sc.params, sc.award, sc.positive, sc.negative, sc.summary, sc.create_time, s.name AS store_name,
                        s.seo_psu, s.status_key, sc.user_name
                FROM MS_store_comment sc, MS_store s
                WHERE s.id IN()
                    AND sc.store_id = s.id AND LENGTH(sc.summary) > 80
                    AND ( sc.params IS NULL OR sc.params NOT LIKE '%"group":"editor"%' )    
                ORDER BY sc.pro_cnt DESC, sc.contra_cnt, sc.award DESC LIMIT 2
                 



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