Disappearing Download Attributes

[ToniScraparoni]

Linda,

Thanks so much for your post. It might just be your writing style, but it did sound dismissive, especially when this problem has been reported for years without resolution. I, for one, greatly appreciate the effort you are about to undertake to solve it.

I will send you my phone number as requested and the other things you've asked for, in addition to offering my services in any other way I can possibly help.

Stay tuned - phone number and pickup links coming soon! :)

[ToniScraparoni]

LOL, DrB! You, rude? Never! :)

Here's my list, before I go put it together for you:

Zen 1.3.9e
Custom Admin Panel
Admin Activity Report 1.3
Admin Profiles 1.0.7.1
Better Categories (that are even better still ;)
Better Together + Promo Page
Blank Sidebox (several)
Email Address Exporter
Email Archive Manager 1.4
Encrypted Master Password 1.2
GoDaddy Seal 2.2
GV Admin Edit 1.1
Image Handler 2.0
Numinix Date Reminder 1.01
Paypal Verified Logo
Product Filter 1.0
Product Info Display 1.0 (Centered)
Sales Report (Custom Version)
Simple Removal Quantity Box 1.1
Special Date 1.0
Super Orders 2.0 1.3.9 Rev1
Value GV Mod 1.3.8 v1.23
UN Wishlist 0.41

Other mods have been installed and uninstalled; possible remnants may still exist in override files. Such as:

Ad Manager 1.36 Checkout Page
Bestsellers 2.0
Categories Dressing 2.7.3
Customer Nickname
Dangling Carrot 1.33
DG Business Activity Report
Edit Orders
Enhanced Whos Online (Whos Online -Zen and mod - both conflict with Online Group Pricing 0.21. That's the lone error I can find in debugging. Error is an undefined function zen_online_group_pricing found in both functions_prices.php and includes/classes/shopping_cart.php)
Free Gifts 1.0
HTML Image Manager
IP Blocker v1.0.0
Login Box 1.5
Maximum Order Amount 1.0
Meta Tags Manufacturer 1.1
Newsletter Discount 1.3
Online Group Pricing 0.21
Orders Improved Search
Product Filter by Attributes, etc. 0.7
Shopping Cart Sidebox w/Checkout Button
Testimonial Manager
VS Featured

As you can see, I've been a busy girl. Thanks again for all of your help! :)

[ToniScraparoni]

I wanted to update this thread for a couple of reasons. First of all, a shout-out for the Zen crew, who work really hard for us even though we may not always see that. It can be hard to look beyond the tunnel sometimes, especally when things aren't working and we're frustrated. However, I have to say that Linda and DrByte have gone beyond the pale several times now, and I, for one, am greatly appreciative.

Though it took me a while to get around to it, thanks to Linda I was able to thoroughly clean my database and match everything. I have what I believe is the correct number of attributes vs. download attributes, products vs. their descriptions, etc., etc. It looks mighty pretty, if I do say so myself! ;)

All it took was a few database queries to cross-check the appropriate tables, then a little research into the discrepancies. Linda was very kind to steer me in the right MySQL direction and I was able to flesh out the rest on my own.

I found stuff hanging around from products long gone, all the way to products being in inventory and loaded fine, yet the download attribute number wasn't the same in Zen vs. the database. Some downloads that seemed fine in Zen weren't in the database at all. It was a mishmash, yet easily fixed once I became familiar with the relationship between the tables and how to write a query. Thank you again, Linda! You are awesome. :)

In case it helps anyone else, the basic query you need looks like this:

Find missing products vs products_description:

SELECT * FROM zen_products_description WHERE zen_products_description.products_id 
NOT IN (SELECT zen_products.products_id FROM zen_products);

I also used this one to check for empty download files:

SELECT * FROM zen_products_attributes_download WHERE products_attributes_filename = '';

All you have to do is cross-check your product tables and category tables (and any mod or auxiliary function tables involving products, such as reviews, wishlists, etc.) and make sure everything is even. You may have old descriptions without a product, or vice versa, or products tied to a master category which no longer exists, etc. In the case of something like wishlists, I simply deleted the products that no longer exist.

Download attributes were a bit trickier. Only the attributes table ties to a product ID, so I used that as my control. After I was able to clear the sort of discrepancies I mentioned above, my numbers are perfect. I have one more attribute than download, which is absolutely correct, given I have one text attribute that's part of a gift certificate mod. Everything else matches to the tee. I love it!

Hope this helps someone as you were kind enough to help me. Thank you again! :)

[sweetikins]

I was wondering if you are able to help, i am having the same issue Toni and i did what you said but nothing has changed. Any help would be appreciated please.

I have Zen Cart 1.3.9h and only come accross this problem maybe once a year maybe twice at the most, it is hectic trying to fix every single product, although it is mainly 1 catagory which is the same as Toni's.

I have over 10,000 products in the store majority of these are the above catagory, so i am not quite sure how to fix it. Just like Toni and the others i am experiencing the exact same thing, I have made no changes to they store whatsoever, i just cant explain it.

Thanks

[sweetikins]

anybody? need help please.