Troubleshooting downloads attributes has hit a brick wall

[PhilipR]

Zen Cart 1.2.3
Database Patch Level: 1.2.4

I have an attribute setup for downloads that I originally set up by following the FAQ. It used to work (six months ago) and I was able to:

- Purchase an mp3
- Log in as admin and set my order status from Processing -> Delivered
- Log back in as the user, go to My Account (as I recall), click on the order in question and see download buttons.


I recently added a bunch of new products and (through an automated script) set their attribs in the same way. However, I now can't make the downloads work EITHER for the new mp3 products NOR for prior ones.

Now I:

- Purchase an mp3
- Log in as admin and set my order status from Processing -> Delivered
- Log back in as the user, go to My Account, click on the order, and I get a list of the product(s) with no download buttons. Previously my recollection is that there were buttons to download.

Digging a bit in the database, I find that:

- there are rows for the products in zen_products_attributes (I can post a dump of a sample row if this would be helpful)
- there's a row for a corresponding products_attributes_id in zen_products_attributes_download
- There are NOT any rows corresponding to my latest order in zen_orders_products_attributes or zen_orders_products_attributes_download


Any more thoughts on how to troubleshoot? I'd hate to go into the ZC source code and find where this is supposed to get copied over on a per-order basis, so I'm hoping someone has an easier suggestion.

Due diligence: I searched for zen_orders_products_attributes and didn't find the results to be relevant.

[PhilipR]

Follow-up:

Turns out this issue had to do with a form that I had created as part of another product's (the album's) description. My form was probably not passing the correct variables for the attributes, so that's where I'll look. When I purchased a song without going through this custom form, I was fine.

That said, I've found something else that seems to be a possible bug or misconfiguration. When I purchase the mp3s and choose check/money order as payment it lets me download even BEFORE the admin changes the status, i.e. while status is still processing. That can't be right, can it?

I'll be digging thru changelogs to see if ZC still works this way....

[misty]

If at all possible, would upgrade to latest version of ZenCart,, your current version
may not be secure

[PhilipR]

Yeah, that's a whole other can of worms, but very true. The owner of the server (whom I subcontract for) knows of this problem.

Turned out the issue here was the configuration of the Check/Money Order payment module. Apparently by default it sets "purchased" items to status #2 - Processing. And apparently Processing allows you to DL.

Someone correct me if I'm wrong -- I'll certainly do a virgin install of the newest version module before I enter a bug against it.

[Ajeh]

The Orders Status of a Payment Module is the control feature of Downloads ...

It is best to always define these specifically so that you have no surprises ...