Hello

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2008-05-01 17:33:03] (Fresh Installation)
v1.3.8 [2008-05-01 17:33:03] (Fresh Installation)
PHP Version: 5.2.4 (Zend: 2.2.0)
Database: MySQL 5.0.67-log
Easy Populate basic 1.2.5.4
ultimate_seo_urls_2.106

I have a few zen stores. In one of my stores the products table has 12,000 more records than the products_descriptions table. This particular site is a constant problem child: slows down, freezes, crashes, etc. the other sites I have on the same (shared) server run fine, we just have problems with this one.

I compared the data from products and products_descriptions, looking for the orphan product IDs. I expected to find scattered missing prod ids, but that's not the case: it's as thought the desc table was truncated right after record x.

Products has 48,000; product_descriptions has 26,000. Products_descriptions has products_ids from 1 to 26,000, no skips, nothing higher. [ids rounded]

I did run into this before in this store, about a month ago. I deleted the products from the products table that didn't have a record in the prods_description table. I then ran the ez populate util to clean up orphan product records (/admin/easypopulate.php?dross=delete). After I uploaded my full products file the prods and prod_descs tables had exactly the same number of records, the site was fine.

Now the mis-match has happened again. But if I search in my store for one of the model numbers whose product id is NOT in the prods_desc table, it does come up, and has a name, description!

So, three questions:

Why are the products and prod_desc tables mis-matched in this one store? My others are never off by more than 12 records. What can be causing this to happen? All stores get the same uploads, have the same mods.

Where else is prod name and desc stored? I am in the proper database and tables: if I alter a record in phpMyAdmin it is reflected in my store. But this name and description are NOT in my products_descriptions table.

And I think I will try re-building this store from scratch. Is it possible to re-run the zen install to update/write-over a site? Maybe I have old code in the template or something. I do use the override system. Or would it be best to build it from scratch under a new domain, then move it into the current one?

Thanks in Advance

--Pat