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

Code:
AND pd.language_id= french
So there IS something different about your store.. I can't say what until I see your store files..

Quote Originally Posted by DivaVocals View Post
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..