Order Editor 1.3.7 Issues

[srturner47]

I'd be happy to try and help you out, but I don't really understand what the problem is. I've renamed my admin directory, and this still seems to work fine for me. What problem or error are you getting?

[Shepherd348]

Thanks,

A question that might clear it all up is simply, where are the order editing files supposed to be uploaded to? All the instructions say is to upload them to the "store". I assumed that meant the main directory, but now I'm thinking that it is probably supposed to be in the admin section, because the 404 error is for a page that it is searching for in the renamed admin section.

Are these files supposed to be there?

Also, do I upload the order edit "admin" directory, or the entire edit_orders directory. As it is unpackaged, it is edit_orders/admin/includes/etc.

I appreciate your timely response.

Shepherd

[Shepherd348]

Ok, while I was waiting for a reply, I pushed over the files in the admin folder and tried it again. I still get the same message, which states that FILENAME_ORDER_EDIT.php?page=1 can't be found.

Looking in the edit_orders/admin directory, there is a file edit_orders, but no file order_edit.

So, is this file misnamed, or is the command looking for the file boogered up?

Shepherd

[srturner47]

You've copied the files to the wrong directories. After unzipping, rename the folder admin to your new admin directory name. Then, copy the files from inside the main directory - edit_orders - into the main directory of your web site.

Or, since all the files are in the admin directory, just copy the files from the admin directory to your admin directory.

[Shepherd348]

Thanks for your reply. Just have one more question. If I understand you correctly, I am to rename the existing folder edit_orders/admin to match the renamed folder on my site, then copy all of the files into that folder.

Since there is already an includes folder in there, won't it overwrite those files? Or, is that what I'm supposed to do. I see many matching files that will overlay each other if copied.

Sorry, for all the hand holding, but I just want to make sure before I nuke something.

Shepherd

[Shepherd348]

Never mind about that question. I backed up my files, said a little prayer and pushed the button. At long last, it works. Thanks for your help. I'm not the sharpest knife in the drawer, but you've probably figured that out.

Shepherd

[gsdcypher]

srturner47,

your update fixed many issues, but... i was trying to edit an order today by adding an item to an order and got this 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 '27.0000', products_options_id = ' at line 5
in:
[insert into orders_products_attributes set orders_id = 2043, orders_products_id = 2383, products_options = 'length', products_options_values = '3/8" x 33'', options_values_price = '27.0000', products_options_id = '23', products_options_values_id = '174', price_prefix = '';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

fix ideas?

thanks.

[srturner47]

I'm not 100% sure, but I think I know why you are having this problem. Your product option 3/8" x 33' ends in an apostrophe. This closes the SQL command prematurely. Try renaming your option to 3/8 " x 33 ft ... if that doesn't work try 38 in x 33 ft. Let me know if that solves the issue.

[gsdcypher]

Thanks srturner47.

I will go through and change all of my options. It will be a major PITA, but worth it.

cheers!

[mauryg]

If you have a LOT of options to change and you are adept with SQL, you could simply export the table to CSV, use a find/replace edit in Excel and then reimport the table.