System error in Melbis Shop 6.1.1



Error occured in script work

Error occured, script stoped


Error type: MySQL Error

Source, line: Parser[1663]

Error: Deadlock found when trying to get lock; try restarting transaction

Error information:

 CREATE TEMPORARY TABLE MS_tws_tmp_store (id INT UNSIGNED NOT NULL) ENGINE=MEMORY
                AS 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 JOIN MS_tws_tmp_subtopics AS subtopics
                            ON subtopics.id = topic_store.topic_id 
                          JOIN MS_store_info store_info13 ON store_info13.store_id=store.id AND store_info13.value_id IN(74826) JOIN MS_store_info store_info111 ON store_info111.store_id=store.id AND store_info111.value_id IN(19541) JOIN MS_store_info store_info845 ON store_info845.store_id=store.id AND store_info845.value_id IN(75077) WHERE store.no_visible=0 AND store.kind_key='kDefault' AND store.status_key <> 'kAbsent'
                 



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