Hi,

My zen cart site is version 1.3.5.

Recently, there is an issue with database, which website cannot load products and images.

My host said. "There were about 50 queries running, the same query was running about 30 times. It's very strange - perhaps there is a bug in Zencart which is causing it not to work with the database properly".

At the time my host refered to, it was only about 5 vistors and might opened about 20 connections (pages) maximum.

So how did these 50 queries come from and why it keep running? Is it a bug? or it is my host did not configure it properly?

here are queries my host refered to:

"There are lots of MySQL queries happening again:

2187403 chines00 localhost chines00_s 312 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2187150 chines00 localhost chines00_s 354 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2187093 chines00 localhost chines00_s 367 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2187000 chines00 localhost chines00_s 384 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2186988 chines00 localhost chines00_s 387 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2186920 chines00 localhost chines00_s 404 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2186242 chines00 localhost chines00_s 523 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2185969 chines00 localhost chines00_s 560 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2185761 chines00 localhost chines00_s 586 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'
2185670 chines00 localhost chines00_s 600 Query delete from
dt_db_cache where cache_entry_name =
'zc_d38797dcf3d115b1928659d3089e0d3d'


There are lots more than this - but most are the same query, some are just
'Query delete from dt_db_cache' and there are also a few trying to do the
opposite to the delete: 'Query select * from dt_db_cache where
cache_entry_name = 'zc_d38797dcf3d115b1928659d3089e0d3d'"

Can someone please help? it has caused my site went down twice in 2 days. It seems it will cause further problem if I did not sort it out.

Also, does anyone know how to clearing the cache? I hope clear the cache will help database running.

thank you in advance!