Missing links in order

Today, I had a large order come through and usually, a invoice will look like this:

1 x Wrapped Frame - Round - PSP Script
Download 1 zip file 1

However, this order (which had 22 items) had them listed in this way:
1 x Chipboard - PSP script
1 x Clothes Labels - PSP Script
1 x Cluster Template Maker - PSP Script

I immediately noticed the difference as the "Download 1 zip file 1" was missing. Just a few minutes later, the customer emailed me saying she didn't get the download links, and even in her account in the store, the links are missing. The payment went through correctly and in full.

Looking at the backend, I see the order but not the download links, so I cannot even reset them either. Any idea what might have happened, or how I can fix this (other than give her a coupon so she can buy again, hoping this time it works)?

If you have an Order missing the download but the Product itself is on the Order ... you can fix this by going to phpMyAdmin and checking the tables to fix this ...

First, check the table:
orders_products_attributes

Search for the orders_id in the table orders_products_attributes ... Is the Product in there with the Attribute for this download?

If so, get the content of the field:
products_prid

Next, browse the table:
orders_products_download

for the orders_id and you should be missing the record containing that

Do an INSERT and fill in the fields:
orders_id
orders_products_id
orders_products_filename
download_maxdays
download_count
products_prid

Now the Download should be available on the Order for this customer ...

Is this in the zencart admin panel or on my zencart install? This is totally new to me.

Ok i found that on the server.

Quote:

---

Search for the orders_id in the table orders_products_attributes ... Is the Product in there with the Attribute for this download?

---

No, that order is missing. Is there a way to create one?

In the table:
orders_products

Do you see the products_id in the table?

And you say in the table:
orders_products_attributes

that you do not see the products_id in the field:
orders_products_id

and the matching
products_prid

for the orders_products tables products_prid correct?

Maybe i was not clear. The order that came was number 5083. In the product_order_attributes, the last order is number 5082, so that is the order i do not see at all.

I see all the fields of all the other orders, just that order is totally missing.

Do you have that orders_id in the table:
orders

IF so, do you have the other Products in the table:
orders_products

IF so, do you have the other Products that have Attributes in the table:
orders_products_attributes

IF so, do you have for the Products with Downloads the downloads in the table:
orders_products_downloads

Have you an URL to this Product that has the missing download in the Order?

In the Attributes Controller, on the Download for this Product, is there a green dot next to the filename?

Quote:

---

Do you have that orders_id in the table:
orders

---

Yes

Quote:

---

IF so, do you have the other Products in the table:
orders_products

---

Yes

Quote:

---

IF so, do you have the other Products that have Attributes in the table:
orders_products_attributes

---

No

Quote:

---

IF so, do you have for the Products with Downloads the downloads in the table:
orders_products_downloads

---

No

Do you have the products_id for all the Products in that order and a URL to your site?

This may or may not be able to be rebuilt ...

Quote:

---

Do you have the products_id for all the Products in that order and a URL to your site?

---

Yes, i have a products_id for all the Products in that order, all 22 of them.
However, i am not sure where i should look for the URL as i dont see that as a field.
One thing i notice that differs from the previous orders is that previous ones have products_prid like 234:f23d2c54e398b1daabb4f964f1f45b60 while ALL the products in this particular order only have the first 3 digits, like 150 or 294, and no loooooooooooong string.