Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

[sanji]

After extensively checking my admin part, I took a fresh copy of ZC 1.3.9h + super_orders 3 + edit_orders 3 + admin levels, and started to compare this set of files with mine. I could not find anything that could be source of problem (I have other mods, including Birthday, Sales Report, Products Profit Margin, Price List, and so on, but nothing touching the core files or the important function files...

My server specs are :

OS Serveur : Linux imu172 2.6.27.35-imu-x86 #1 SMP Fri Sep 25 11:02:21 CEST 2009 i686
Base de Données : MySQL 5.0.84-log
Serveur HTTP : Apache
Version PHP : 5.2.14 (Zend : 2.2.0)
PHP Memory Limit: 64M
PHP Safe Mode: Off
PHP File Uploads: On
Max Size: 300M
POST Max Size: 300M
Database Data Size: 65,968 kB
Database Index Size: 1,449 kB

I thought for a while that this problem could be related to Super Orders 3, but apparently this is not the case. I can surf on the SO extensions without problem, but the behavior is always the same on Edit Orders :

- Once I click the button "Edit Order", I can reach the corresponding page.
- If I click on "Add product", I get the blank page corresponding to the error written in my previous posts
or
- If I click to go back on the "Main Page", I also get the blank page corresponding to the same error

What I don't get is that if URLs and picture links are transformed to "includes/languages/2/xxx" instead of "includes/languages/french/xxx", it means that at some point, in init_language.php, there is a mix between $_SESSION['language'] and $_SESSION['languages_id']. If the language part in the URLs was missing, link having "includes/languages//xxx", I would understand the issue, but I don't get why the wrong information (id instead of full text) is passed...

I spent 3 hours checking every file... so I think I will go to sleep now

[DivaVocals]

Check your PM's.. It's time for Plan "B" my very patient friend...

After extensively checking my admin part, I took a fresh copy of ZC 1.3.9h + super_orders 3 + edit_orders 3 + admin levels, and started to compare this set of files with mine. I could not find anything that could be source of problem (I have other mods, including Birthday, Sales Report, Products Profit Margin, Price List, and so on, but nothing touching the core files or the important function files...

My server specs are :

OS Serveur : Linux imu172 2.6.27.35-imu-x86 #1 SMP Fri Sep 25 11:02:21 CEST 2009 i686
Base de Données : MySQL 5.0.84-log
Serveur HTTP : Apache
Version PHP : 5.2.14 (Zend : 2.2.0)
PHP Memory Limit: 64M
PHP Safe Mode: Off
PHP File Uploads: On
Max Size: 300M
POST Max Size: 300M
Database Data Size: 65,968 kB
Database Index Size: 1,449 kB

I thought for a while that this problem could be related to Super Orders 3, but apparently this is not the case. I can surf on the SO extensions without problem, but the behavior is always the same on Edit Orders :

- Once I click the button "Edit Order", I can reach the corresponding page.
- If I click on "Add product", I get the blank page corresponding to the error written in my previous posts
or
- If I click to go back on the "Main Page", I also get the blank page corresponding to the same error

What I don't get is that if URLs and picture links are transformed to "includes/languages/2/xxx" instead of "includes/languages/french/xxx", it means that at some point, in init_language.php, there is a mix between $_SESSION['language'] and $_SESSION['languages_id']. If the language part in the URLs was missing, link having "includes/languages//xxx", I would understand the issue, but I don't get why the wrong information (id instead of full text) is passed...

I spent 3 hours checking every file... so I think I will go to sleep now

[sanji]

Wait...

I got something (I mean, apart the private messages we exchanged)...

Remove the following line in edit_orders.php

$language = (int)$_SESSION['languages_id'];

The images are back on the Edit Orders page! Plus, no more crash when you click on "Add product"...

The only bug left is an SQL error on Production Addition :

1054 Unknown column 'french' in 'on clause'
in:
[SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM products p LEFT JOIN products_description pd ON (pd.products_id=p.products_id AND pd.language_id= french) LEFT JOIN products_to_categories ptc ON ptc.products_id=p.products_id LEFT JOIN categories_description cd ON (cd.categories_id=ptc.categories_id AND cd.language_id= french) ORDER BY categories_name]
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.

Obviously, the correct term should be cd.language_id=2 (in my case), which brings 2 questions :

- why does the definition of $language cause trouble on this page (no image, wrong links, blank pages) ?
- how to pass the language id only in the SQL statements...

OK, time to go to bed again !!

sanji

[DivaVocals]

Except this problem is UNIQUE to your store.. None of us working on and testing this version ever encountered this issue..

To date one person resolved this issue (though he did not disclose how) and another resolved it by installing the module in an environment running a newer version of PHP.. (Hence why we concluded that this mod doesn't run on versions of PHP older than 5.2.x)

If I remove the same line you did from edit_orders.php in my working setup I get this error. (which is similar to the one you got)

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 ') LEFT JOIN  zen_products_to_categories ptc ON ptc.products_id=p.products_id LEFT' at  line 1
in:
[SELECT products_name, p.products_id, categories_name,  ptc.categories_id FROM zen_products p LEFT JOIN  zen_products_description pd ON (pd.products_id=p.products_id AND  pd.language_id= ) LEFT JOIN zen_products_to_categories ptc ON  ptc.products_id=p.products_id LEFT JOIN zen_categories_description cd ON  (cd.categories_id=ptc.categories_id AND cd.language_id= ) ORDER BY  categories_name]
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.

Whatever is going on with your store and this module right now seems to affect only your setup.. I am not yet convinced that the issue is with Edit Orders.

So in order to REALLY get to the bottom of this issue, we really will need to see your store files and compare them to ours so we will know what's different about your setup..

Wait...

I got something (I mean, apart the private messages we exchanged)...

Remove the following line in edit_orders.php

$language = (int)$_SESSION['languages_id'];

The images are back on the Edit Orders page! Plus, no more crash when you click on "Add product"...

The only bug left is an SQL error on Production Addition :

1054 Unknown column 'french' in 'on clause'
in:
[SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM products p LEFT JOIN products_description pd ON (pd.products_id=p.products_id AND pd.language_id= french) LEFT JOIN products_to_categories ptc ON ptc.products_id=p.products_id LEFT JOIN categories_description cd ON (cd.categories_id=ptc.categories_id AND cd.language_id= french) ORDER BY categories_name]
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.

Obviously, the correct term should be cd.language_id=2 (in my case), which brings 2 questions :

- why does the definition of $language cause trouble on this page (no image, wrong links, blank pages) ?
- how to pass the language id only in the SQL statements...

OK, time to go to bed again !!

sanji

[DivaVocals]

Also your store is attempting to call "french" as the language ID which is OBVIOUSLY incorrect as language ID should be a numeric value..

AND pd.language_id= french

So there IS something different about your store.. I can't say what until I see your store files..

Except this problem is UNIQUE to your store.. None of us working on and testing this version ever encountered this issue..

To date one person resolved this issue (though he did not disclose how) and another resolved it by installing the module in an environment running a newer version of PHP.. (Hence why we concluded that this mod doesn't run on versions of PHP older than 5.2.x)

If I remove the same line you did from edit_orders.php in my working setup I get this error. (which is similar to the one you got)

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 ') LEFT JOIN  zen_products_to_categories ptc ON ptc.products_id=p.products_id LEFT' at  line 1
in:
[SELECT products_name, p.products_id, categories_name,  ptc.categories_id FROM zen_products p LEFT JOIN  zen_products_description pd ON (pd.products_id=p.products_id AND  pd.language_id= ) LEFT JOIN zen_products_to_categories ptc ON  ptc.products_id=p.products_id LEFT JOIN zen_categories_description cd ON  (cd.categories_id=ptc.categories_id AND cd.language_id= ) ORDER BY  categories_name]
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.

Whatever is going on with your store and this module right now seems to affect only your setup.. I am not yet convinced that the issue is with Edit Orders.

So in order to REALLY get to the bottom of this issue, we really will need to see your store files and compare them to ours so we will know what's different about your setup..

[solidrock]

I have a problem. I am running 1.3.8a. I installed the latest Super Orders 3.0 and Edit Orders 3.02. Then I went to Configuration > Super Orders and set the "Edit Orders Module Switch" to "True". Next I went to Configuration > Edit Orders and set the "Super Orders Module Switch" to "True". And now I get an error when I try and load my admin page: Server error. The website encountered an error while retrieving http://simplycheese.net/store/admin***/. It may be down for maintenance or configured incorrectly.

Any ideas what I did wrong and how to fix it?

Gary

[DivaVocals]

I have a problem. I am running 1.3.8a. I installed the latest Super Orders 3.0 and Edit Orders 3.02. Then I went to Configuration > Super Orders and set the "Edit Orders Module Switch" to "True". Next I went to Configuration > Edit Orders and set the "Super Orders Module Switch" to "True". And now I get an error when I try and load my admin page: Server error. The website encountered an error while retrieving http://simplycheese.net/store/admin***/. It may be down for maintenance or configured incorrectly.

Any ideas what I did wrong and how to fix it?

Gary

A coupla things.. We never tested these packages with 1.3.8. They were modified to be 1.3.9 compatible. So I'm fairly certain that part of the issue may be attributed to the differences between the two Zen Cart versions.. Aside from that, try checking if you have everything installed correctly, and if you still get errors, you will need to find the FAQ for error tracking and post what error message the error tracker turns up..

[countrycharm]

DivaVocals I hope you are doing ok on this find Christmas Eve. I have one problem with edit orders 3.02. I been using Ty_Package_Tracker v2.3a for a long time with no issues. When I installed edit orders I merge the files that needed merging with ty package tracker. After I installed I went to admin configuration ty package tracker and turn on edit orders. I don't have super orders installed yet, but I plan to. Now when I go to customers orders I don't see anywhere to click edit orders at all. The edit order icon is not showing at the right with the other icons. I'm not sure what happen there. I have went over these files a couple of times but I don't see any misstates. I'm not saying there is not one but I just don't see it or my brain is burn out tonight. Any help would be appreciated. Thank you

[DivaVocals]

DivaVocals I hope you are doing ok on this find Christmas Eve. I have one problem with edit orders 3.02. I been using Ty_Package_Tracker v2.3a for a long time with no issues. When I installed edit orders I merge the files that needed merging with ty package tracker. After I installed I went to admin configuration ty package tracker and turn on edit orders. I don't have super orders installed yet, but I plan to. Now when I go to customers orders I don't see anywhere to click edit orders at all. The edit order icon is not showing at the right with the other icons. I'm not sure what happen there. I have went over these files a couple of times but I don't see any misstates. I'm not saying there is not one but I just don't see it or my brain is burn out tonight. Any help would be appreciated. Thank you

No problem..

Can you explain what you mean by the item I highlighted in red.. Does this mean you merged the order.php files that are in the Ty Package Tracker v3.0 fileset with the one in the Edit Orders fileset?? If so I'll double check that we didn't have some oversight between the two.. We were VERY careful to make sure that we clearly commented any required modifications to make them EASY to spot when using a file comparison program.. I'll double check that we didn't overlook something.. In addition to the "edit" icon, are you not seeing the edit buttons in the order details page when you open an order??

Also can you post a screenprint of your orders.php order list so I can see what you mean about the icons..

[orange_juice]

Hallo, I am trying to install edit orders and I get the following error:

PHP Fatal error:  Cannot redeclare zen_get_country_id() (previously declared in xxx/admin/includes/functions/extra_functions/edit_orders.php:34) in xxx/admin/includes/functions/extra_functions/edit_orders_functions.php on line 44

Kind regards,
orange_juice