Printable View
Man, I hope so. I just don't understand why it's showing some products listed in English and some in French. It makes no sense. There must be some way to compile the product list in only one language, using a "WHERE language_id = 1" condition in that query somewhere.. I just have NO CLUE what the syntax would be or how to go about implementing it. I'm kind of glad to know it isn't just me having the problem though.Quote:
Originally Posted by DivaVocals
does anyone know of anyway to make this work for version 1.5?
Its really important!!!!
Did you read post #470? It's only three pages back.Quote:
Originally Posted by chava1106
Which is again why I always suggest reading through the support threads BEFORE posting...:smile:Quote:
Originally Posted by laurelsstitchery
I found someone who could help me sort out this issue. Here is the fix to make it show only the default language, which in my case was language ID 1. If your language ID is something else, change language_id=1 to language_id=YOUR_IDQuote:
Originally Posted by abcisme
in admin/edit_orders.php
REPLACE:
WITH:Code:$result = $db -> Execute("SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id ORDER BY categories_name");
THEN REPLACE:Code:$result = $db -> Execute("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 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 WHERE pd.language_id=1 ORDER BY categories_name");
WITH:Code:$result = $db -> Execute("SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON po.products_options_id=pa.options_id LEFT JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON pov.products_options_values_id=pa.options_values_id WHERE products_id='$add_product_products_id'");
Code:$result = $db -> Execute("SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON po.products_options_id=pa.options_id LEFT JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON pov.products_options_values_id=pa.options_values_id WHERE products_id='$add_product_products_id' AND pov.language_id=1 AND po.language_id=1");
The new version Diva has on the website works fine, just installed and used it. So you can wait until they get the readmes tweaked and it gets in the Zen Plugins as stated or download it from the website. I had no problems installing and using the current install instructions.Quote:
Originally Posted by chava1106
re: post #474 - has the package been updated? if so, do I just install over the old files with the auto installer again? let me know. thanks so much! :)Quote:
Originally Posted by DivaVocals
sorry.. 4th of July celebrations an work deterred me.. will get it uploaded tonight.. or if you know how, you can add these definitions to your orders.php language file..Quote:
Originally Posted by laurelsstitchery
I do know how to add the definitions, so I did that and all is well now. Thanks, Diva! :)Quote:
Originally Posted by DivaVocals
You are welcome! Sorry.. I should have given you those instructions to begin with instead of having you wait on me.. :laugh: Folks installing Super Orders along with Edit Orders won't have this same issue, and had I been more careful in my testing I would have discovered this..Quote:
Originally Posted by laurelsstitchery