Accidentally Set Download Status To Expired, Can't Fix

[Scully]

I just did something stupid...I accidentally clicked on the green "Status - Available" link for a customer's download order, and it went yellow (Status - Expired). When I try to reset it, I get the following error message: WARNING: An Error occurred, please refresh the page and try again. Refreshing doesn't help. I just keep getting the error message...and when I go back into his Orders page, the link remains yellow. I've tried about 10 times now to reset it, and gotten the same error every time.

Fortunately he already downloaded his book...but I'd really like to figure out what's causing the error, and fix it. Can anyone please help? Thanks!!

[Ajeh]

I cannot repeat the problem ...

If you look in your /cache or /logs directory (depends on version and v1.5 should be /cache) what debug logs do you see?

[Scully]

Hopefully I attached the screenshot properly...first time I've done that. ;-)

Thanks for your help!



Oh my, that came out nice!

[Ajeh]

Nice screen shot, but not quite what I am looking for ...

On your server, you have a directory:
/cache

in it you should see files that start with:
myDEBUG

Trigger the error, then refresh the directory to get the most recent myDEBUG file created ...

If you View it, you will see the contents and it should show the problem that triggers the warning ...

[Scully]

LOL Well, at least I figured out how to upload a file the right way!!

Okay, here's the most recent error report, and I hope it makes more sense to you than it does to me!

[31-Oct-2013 13:47:59] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sFantasy.epub'
and pa.products_id = '336'' at line 4 :: SELECT pa.products_attributes_id, pa.products_id, pad.products_attributes_filename, pad.products_attributes_maxdays, pad.products_attributes_maxcount
from products_attributes pa, products_attributes_download pad
WHERE pa.products_attributes_id = pad.products_attributes_id
and pad.products_attributes_filename = 'E.R.O.Scott-Robert'sFantasy.epub'
and pa.products_id = '336' in /home/carnal1/public_html/zencart/includes/classes/db/mysql/query_factory.php on line 101

[Scully]

Duh. I need to change the file name, so that there's not an apostophe in it, don't I? That will fix all future problems. But is there a way to fix the existing line item?

[Ajeh]

The problem is your naming convention for your file:
E.R.O.Scott-Robert'sFantasy.epub

At the least, the apostrophe in the name is causing issues ...

You need to only use letters and numbers in your filenames to not cause issues ...

You can try to manually change the settings on the file in phpMyAdmin in the table:
orders_products_download

and locate the Download in that file and change the days/count as needed ...

NOTE: When changing days, remember the days in the number of days from when the Order was made, so if you want to extend the time period, just adjust the days as needed ...

Meanwhile, you should really fix your filenames so that none contain spaces or special characters to avoid these issues in the future ...

[Ajeh]

Duh. I need to change the file name, so that there's not an apostophe in it, don't I? That will fix all future problems. But is there a way to fix the existing line item?

You are getting good at this ...

To fix the current issue, change the filename on the server then change it in the same table:
orders_products_download

[Scully]

At the risk of looking like a total moron again...where do I find the phpMyAdmin, let alone orders_products_download?

[Ajeh]

phpMyAdmin comes with your domain Control Panel, such as cPanel ...

There should be an option for phpMyAdmin and then you can find your database for your site and in that will be the tables of the database and you should see that table ...

If you search that table for the Order, you can fix the filename on it to match your new filename ...