Not shipping to a region? - Problem for a downloadable product

[Ajeh]

Do all of your Attributes for Downloads use the same options_id and options_values_id in the products_attributes table?

[DrByte]

This query might help:

select products_id, products_name from products_description where products_id in (
select products_id from products_attributes pa, products_attributes_download pd
where pa.products_attributes_id  = pd.products_attributes_id
and products_attributes_filename = '');

In phpMyAdmin, select your database from the pulldown on the left. Then click the "Query" (or maybe "SQL") tab on the right, and paste the above query code in the box and click Go.
Hopefully you get a message that says "0 results found" or something like that.
If you get any other results back, they should be the product number and name, which you'll want to look at to see whether any of its download attributes is missing a filename.


Hopefully you don't get a message saying Table products_description doesn't exist. If you do, then click the "Browse" button in the right-side of phpMyAdmin and see what common prefix all your tablenames are starting with, and insert that prefix before each of the tablenames highlighted in blue above, and try again.

[meljen]

Thank you both so much.

I *think* the problem was discovered... she sent an email back with a copy-and-paste of the text from her cart. Thankfully, that actually showed the issue right there for me. One of my downloads did not have attribute settings attached to it. It had a file, but no actual attributes. I updated it and hopefully that will be the fix that was needed!

I'll let you both know if it worked. :-)

*edit* Dr. Byte, I will try that as soon as I can to make sure this issue won't pop up with other products. Thankfully this was the first time it happened. I'm usually very careful when adding products.

[DrByte]

Upon further study, the database query I posted above isn't a complete diagnostic. It might give partial info, but isn't a thorough inspection for the symptoms being discussed here.
Ajeh is smarter on that stuff than I am

[meljen]

You did awesome Dr. Byte. :-) Thanks for trying!

Ajeh, to answer your question, yes all of my downloads have the same attribute settings... minus the attached file associated with the attribute. If that makes sense. Hope I didn't misunderstand you.