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

[abcisme]

Wish I could help, but the answer is a LOT over my head.. Hopefully someone else in the community knows the answer and will share..

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.

[chava1106]

does anyone know of anyway to make this work for version 1.5?


Its really important!!!!

[laurelsstitchery]

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.

[DivaVocals]

Did you read post #470? It's only three pages back.

Which is again why I always suggest reading through the support threads BEFORE posting...

[abcisme]

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.

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_ID

in admin/edit_orders.php

REPLACE:

$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");

WITH:

$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");

THEN REPLACE:

$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'");

WITH:

$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");

[ted]

does anyone know of anyway to make this work for version 1.5?


Its really important!!!!

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.

[laurelsstitchery]

Yes this was already brought to my attention.. Will update the package later this evening..

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! :)

[DivaVocals]

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! :)

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

[laurelsstitchery]

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

I do know how to add the definitions, so I did that and all is well now. Thanks, Diva! :)

[DivaVocals]

I do know how to add the definitions, so I did that and all is well now. Thanks, Diva! :)

You are welcome! Sorry.. I should have given you those instructions to begin with instead of having you wait on me.. 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..