Getting errors as such, is the database damaged? Do you think I should go back to previous backup or not necessary?
Thank you.
Printable View
Getting errors as such, is the database damaged? Do you think I should go back to previous backup or not necessary?
Thank you.
You should be using Dr. Bytes MySQL Backup tool any time you are working with EP. This ensures that your can easily roll back your databases.Quote:
Originally Posted by Kevin205
The databases would not be damaged, but I cannot determine what you did. Looks like I'll have to add some additional error handling to prevent these kind of user errors.
-chadd
I always backup!
Got it thanks. Chad
Attachment 12106
Chad - Why is the value of v_products_options_type field is different in the Attrib-Detailed-EP than Attrib-Basic-EP CSV?
I have used Radio buttons for Size and Drop down for Material.
The v_products_options_type in Attrib-Detailed-EP for product model 53 is 2 for Size and 0 for Material, but in Attrib-Basic-EP the value for Size and Material are both set to 2.
Shouldn’t it be 2 (Radio Button) for Size and 0 (Drop Down) for Material in Attrib-Basic-EP also?
I would appreciate it if you would explain the difference. Thanks.
I just created a test using your same BASIC data, and when I down load the DETAILED it is correct: v_products_options_type match.Quote:
Originally Posted by Kevin205
Are you using the products_options_name "Material" more than once with DIFFERENT products_options_type (drop box vs radio button)?
Check your options names/values through the admin...
I thought I had messed up again, so I went ahead and installed a fresh install of 1.5.1 with clean database. The only plug-in installed is EP4 (Easy Populate 4.0.22 - Beta 6-10-2012).
I then created two products:
Prod 1
Shirt A (Model: SHIRT_200), with 1 attributes:
Size: Small, Medium, Large
Prod 2
Shirt B (Model: SHIRT_100), with 2 attributes:
Size: Small, Medium, Large
Color: Blue, Red, Green
As you can see when I exported the "Attrib-Basic-EP" and "Attrib-Detailed-EP", I am still getting “0” in v_products_options_type in the Attrib-Basic-EP (on record#3 of spreadsheet).
Shouldn’t that value be a “2” for Radio Button? Same result as before. Am I missing something Here?
Attachment 12107
PM Sent...Quote:
Originally Posted by Kevin205
Congratulations Kevin, you found a bug in the Basic Attribute EXPORT (not import).
A same product with different types of options was not exporting correctly.
Thank you for your diligence!
-chadd
Chad – Please do not congratulate me as I do not deserve any. You deserve all the congratulations and recognition yourself with all of your hard work helping others.
Thank you again for an amazing module.
Here is the result. Perfect.
Attachment 12109
I will test with other options tomorrow and keep you posted. Thanks.