MyDEBUG: help w QueryFactory errors

[RixStix]

Not really sure where posts related to MyDEBUG files should be started. Maybe a new category is needed in the forum.

There are a few files, all have PHP Fatal Error: 1062, queryFactory and insert into db_cache_entry_name in the list.

[11-Aug-2014 04:22:03 America/Los_Angeles] #1 trigger_error() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:155]
#2 queryFactory->show_error() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:132]
#3 queryFactory->set_error() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:262]
#4 queryFactory->Execute() called at [/home/XXXXXXXX/public_html/includes/classes/cache.php:131]
#5 cache->sql_cache_store() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:239]
#6 queryFactory->Execute() called at [/home/XXXXXXXX/public_html/includes/classes/category_tree.php:50]
#7 category_tree->zen_category_tree() called at [/home/XXXXXXXX/public_html/includes/modules/sideboxes/categories.php:19]
#8 require(/home/XXXXXXXX/public_html/includes/modules/sideboxes/categories.php) called at [/home/XXXXXXXX/public_html/includes/modules/westminster_new/column_left.php:40]
#9 require(/home/XXXXXXXX/public_html/includes/modules/westminster_new/column_left.php) called at [/home/XXXXXXXX/public_html/includes/templates/westminster_new/common/tpl_main_page.php:208]
#10 require(/home/XXXXXXXX/public_html/includes/templates/westminster_new/common/tpl_main_page.php) called at [/home/XXXXXXXX/public_html/index.php:97]

[11-Aug-2014 04:22:03 America/Los_Angeles] PHP Fatal error: 1062uplicate entry 'zc_56bef17b17fbeb6627441de26659411d' for key 'PRIMARY' :: insert into db_cache set cache_entry_name = 'zc_56bef17b17fbeb6627441de26659411d',
cache_data =

[10-Aug-2014 08:58:49 America/Los_Angeles] #1 trigger_error() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:155]
#2 queryFactory->show_error() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:132]
#3 queryFactory->set_error() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:262]
#4 queryFactory->Execute() called at [/home/XXXXXXXX/public_html/includes/classes/cache.php:131]
#5 cache->sql_cache_store() called at [/home/XXXXXXXX/public_html/includes/classes/db/mysql/query_factory.php:239]
#6 queryFactory->Execute() called at [/home/XXXXXXXX/public_html/includes/init_includes/init_db_config_read.php:19]
#7 require(/home/XXXXXXXX/public_html/includes/init_includes/init_db_config_read.php) called at [/home/XXXXXXXX/public_html/includes/autoload_func.php:48]
#8 require(/home/XXXXXXXX/public_html/includes/autoload_func.php) called at [/home/XXXXXXXX/public_html/includes/application_top.php:158]
#9 require(/home/XXXXXXXX/public_html/includes/application_top.php) called at [/home/XXXXXXXX/public_html/index.php:26]

[10-Aug-2014 08:58:49 America/Los_Angeles] PHP Fatal error: 1062uplicate entry 'zc_cc21d2f64edffccfe06d12dd3327bf64' for key 'PRIMARY' :: insert into db_cache set cache_entry_name = 'zc_cc21d2f64edffccfe06d12dd3327bf64',
cache_data =

[09-Aug-2014 13:55:23 America/Los_Angeles] PHP Fatal error: 1062uplicate entry 'zc_cc21d2f64edffccfe06d12dd3327bf64' for key 'PRIMARY' :: insert into db_cache set cache_entry_name = 'zc_cc21d2f64edffccfe06d12dd3327bf64',
cache_data =

[lhungil]

Usually a "timing" issue... The more "stress" a server is under, the higher the probability this error will occur... Not really worth getting into the details (do a search of "db_cache site:zen-cart.com" in a search engine if you really want to read more).

If you see these messages in your error logs more then once a month, it would probably be best to just disable the SQL CACHE by editing your "configure.php" files and setting SQL_CACHE to "none".

NOTE: There are a few proposed long term fixes, but most involve using some form of database locking / transactions. This would probably require using InnoDB, sqlite, or something similar (on hosts supporting these)...

[RixStix]

TNX for the response. Since upgrading to 1.5.3, it's appearing in the folder at least daily. We'll leave it as-is and see if the host updating PHP and MySQL in the next day or so makes a difference. If not, then change it to none as you suggest.