An exception occurred in shop's script

  • Error type: MySQL Error
  • Source, line: Parser::tws_shop_topic[3179]
  • Error message: Deadlock found when trying to get lock; try restarting transaction
 CREATE TEMPORARY TABLE MS8_tws_tmp_store (id INT UNSIGNED NOT NULL) ENGINE=MyISAM
                AS SELECT DISTINCT store.id FROM MS8_store store
                    LEFT JOIN MS8_currency curr ON store.price_curr_id = curr.id
                    LEFT JOIN MS8_topic_store topic_store ON topic_store.store_id = store.id JOIN MS8_tws_tmp_subtopics AS subtopics
                            ON subtopics.id = topic_store.topic_id 
                          JOIN MS8_store_info store_info2084 ON store_info2084.store_id=store.id AND store_info2084.value_id IN(199172) JOIN MS8_store_info store_info2085 ON store_info2085.store_id=store.id AND store_info2085.value_id IN(199175) JOIN MS8_store_info store_info2087 ON store_info2087.store_id=store.id AND store_info2087.value_id IN(199178) JOIN MS8_store_info store_info2089 ON store_info2089.store_id=store.id AND store_info2089.value_id IN(199179) WHERE store.no_visible=0 AND store.kind_key='kDefault' AND store.status_key <> 'kAbsent'