I can't figure out what I did wrong?
I exported the "Attrib-Detailed-EP2013Mar07" file and added one line of attribute information to the following fields. I was trying to add an attribute to an existing drop down option
v_products_attributes_id ( did not place any thing here. I figured SQL will generate the ID)
v_products_id (Placed the product ID 229, identical to the existing product ID)
v_products_model (Placed the model #, identical to the existing product #)
v_options_id (placed 8 for option id, matching the existing option id/name)
v_products_options_name (placed the the option name)
v_products_options_type (placed 0 for, thinking this is used for a drop down)
v_options_values_id (added 1 to the highest number of 16 and wrote 17)
v_products_options_values_name (added a new name)
v_options_values_price (added the price)
v_options_values_price v_price_prefix (added a +)
the rest of the fields were unchanged.
The reason why you see all the below error message and not just once, is because I believe I re imported "Attrib-Detailed-EP2013Mar07" about 4 times. I did not place any IDs as I figured program will assign appropriate ids.
MySQL error 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 'AND
products_id = AND
options_id = 8 AND
options_values_id =
' at line 3
When executing:
SELECT * FROM zen_products_attributes
WHERE (
products_attributes_id = AND
products_id = AND
options_id = 8 AND
options_values_id =
) LIMIT 1
MySQL error 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 'AND
products_id = 229 AND
options_id = 8 AND
options_values_id = ' at line 3
When executing:
SELECT * FROM zen_products_attributes
WHERE (
products_attributes_id = AND
products_id = 229 AND
options_id = 8 AND
options_values_id =
) LIMIT 1
MySQL error 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 'AND
products_id = 229 AND
options_id = 8 AND
options_values_id = ' at line 3
When executing:
SELECT * FROM zen_products_attributes
WHERE (
products_attributes_id = AND
products_id = 229 AND
options_id = 8 AND
options_values_id = 17
) LIMIT 1
