Order Editor 1.3.7 Issues

[izar74]

Hi all, this should be simple.. i hope...

The mod work fine, even with MySql 5 (just change the properties of the field products_prid in orders_products and orders_products_attributes so that it can be NULL).
My problems is with language, I'm using Italian and if i modify an order, adding product it take the eng. name of it.. even if during the adding phase it show it in italian... Any idea?

p.s. Last ver of zencart 1.3.8b, Mysql 5

[remoteone]

Ok, Ive installed this latest version of EDIT_ORDERS MOD',
. but it does not work .
Get this error when adding a product:

1364 Field 'products_prid' doesn't have a default value
in:
[insert into zc1_orders_products set orders_id = 42, products_id = 196, products_model = 'PS3IR-1000', products_name = 'PS3IR-1000', products_price = '118.1727', final_price = '131.7997', products_tax = '10', products_quantity = 1;]
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.

I have no 'products_prid' inside any db table.
HELP someone ?

[srturner47]

Sorry I haven't answered questions in awhile! Life gets busy! :)

remoteone -- The is strange -- your request doesn't include anything for products_prid! So, if products_prid doesn't exist, this error would be impossible. Check your orders_products table carefully! It must be there.

So, I searched out why this could be happening, as a default value should not be required. I found this:

http://bugkill.##########################/2007/06/...e-default.html

Sounds like that might fix your problem! Give it a try.


izar74 -- Sounds like you had the same problem remoteone had. Again, I can't see a reason why this shouldn't work unless your have mysql mode setup as detailed above. It seems to work ok with MySQL 5 for me.

I know -- not your question! :) Does Zen Cart support multiple languages for products and orders? I only see one table for it, so I'm not quite sure how this works. Maybe its because I run English only sites.


dkhoward -- You'll need to use the REGULAR order editor which still should be there after installing TY Package Tracker. Just go to Customers->Orders instead of Customers->Add Tracking ID.


nidkolio -- The file with the defines for edit orders is not loading correctly. Make sure you have installed it in the right directory. It should be in admin/includes/languages/english/edit_orders.php


labraxmauler -- The fix will probably not be something easy if there is a problem with your database...there may not be, but if there is you got big problems! Much bigger than installing this mod. Sorry, I don't know how to fix that. I'd post this info to the upgrade thread and ask if something got messed up with an upgrade.

[remoteone]

Hello srturner47
Changing my.ini line (C:\Program Files\MySQL\MySQL Server 5.0\) to

sql-mode = ""
from 
# sql-mode= "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

fixed the error, but are there any security issues introduced by doing this?


With the EO mod working, Adding product with more than one attribute is not possible. ie, I cant select more than one accessory option of a product when adding the product to the order.

see attached
Cheers

[srturner47]

No, there should be no security issues with changing this as far as I know.

I didn't know you could add multiple attribute values that have the same attribute name in Zen Cart when checking out.... This is not the way it works for me on my site -- you choose one and only one attribute value for each attribute name. Not quite sure how you did this, but I certainly don't claim to know all the options in Zen Cart -- there are a lot of them!

You're out of luck if you want it to work this way. It would take a major fix (hours and hours of work) to make this work with multiple attribute values for each attribute name. And frankly, I wouldn't even know where to start -- I looked over the options for attributes and I don't see anything about allowing multiple attribute names from one value for a product.

In the meantime, if you absolutely need this feature with Edit Orders you'd need to give each attribute value that can be selected for a product an attribute name. Then, it should work fine.

[lankeeyankee]

I think this might be using checkboxes? You can select any or all of the values for one attribute option with a checkbox. There would need to be a way of multi-selecting the attributes in the dropdown by pressing the control key while selecting. The Advanced Shipper module has this functionality and inserts all of the selected items from the dropdown to be inserted into the database, I think it's a set of javascript functions. I will check into the files over the next few days and see if I can figure out what needs to be done, at least theoretically, I am not advanced enough to write this functionality for the order editor but can provide code snippets to help out.

[izar74]

Sorry I haven't answered questions in awhile! Life gets busy! :)


izar74 -- Sounds like you had the same problem remoteone had. Again, I can't see a reason why this shouldn't work unless your have mysql mode setup as detailed above. It seems to work ok with MySQL 5 for me.

I know -- not your question! :) Does Zen Cart support multiple languages for products and orders? I only see one table for it, so I'm not quite sure how this works. Maybe its because I run English only sites.

Thanks for the answer :-). Probably You are right, in the database the English is always set as 1 and the other language follow with 2, 3.... etc. When You add a new item to order it just take the first language, it's doesn't check which you are using.

As regards Mysql if your provider run MYsql 4, like mine, there are no errors, but with MYSQL 5 the field mentioned before (product_prid) must not be null by default or you get an error. Just log in the database and set it not null and you are done.

[remoteone]

...
The mod work fine, even with MySql 5 (just change the properties of the field products_prid in orders_products and orders_products_attributes so that it can be NULL).

Yep, in mySQL 5 setting default values to NULL, fixes this problem. So I changed back to sql-mode= "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" in my.ini. Ill check my live server before going live.
All good. Perhaps this is a SQL Query script that needs including with the MOD download.
Cheers.

[remoteone]

Hi lankeeyankee,
Yep, just using the standard check-boxes.

[srturner47]

lankeeyankee -- The tricky part about doing this is that you'd have pass several new variables using POST to the edit_orders.php file and then write the code to handle these variables. Unfortunately, I'm really busy with other projects right now, so I don't have time to do this at the moment. Let me know if you have any questions when you look it over.

remoteone -- I have MySQL5 too, but my server doesn't use those options by default, so no problem. I suppose the easiest fix for those who have this issue would just be to insert a products_prid by default with edit orders....I don't really understand what products_prid does anyway. It appears to just be random data to me, which is why I ignored it in the first place.

izar74 -- Yes, you are right, you'd need some way to choose the language when adding a product, which could be done though. I'm still not sure where this information is kept though (I only use one language, so I don't have a way to check this out.). In the products table the products_id auto-increments, so how are multiple languages stored for the same products_id?