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)

Code:
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..

Quote Originally Posted by sanji View Post
Wait...

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

Remove the following line in edit_orders.php

Code:
$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 :

Code:
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