attributes

[Andy c]

HI

I have yet another problem.. Have taken the leap to learn attributes but while trying to get it to work......
When I am trying to insert Option Values I keep getting this meassage

1062 Duplicate entry '1-1' for key 1
in:
[insert into zen_products_options_values (products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order) values ('1', '1', 'rrrrr', '3')]
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.

there is 1 insert already and I can't delete it either I get this message
 Error: Mismatched Option Name and Option Value selected from: 12-14 Size

have got it working on my test site so have no idea what could be the problem 

thanks

[Andy c]

have found this thread
http://www.zen-cart.com/forum/showthread.php?p=1014878#post1014878
ran the sql
and now get this any ideas plz


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 '0' at line 1
in:
[DELETE FROM zen_products_options_values where products_options_values_id > 0;]
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.

[seamus]

take these off [ ] and then run the patch

[Andy c]

delete from products_options_values where products_options_values_id > 0;

yeah that's what I ran and it brings up this error without the []

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 '0' at line 1
in:
[DELETE FROM zen_products_options_values where products_options_values_id > 0;]
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.

[seamus]

check that your not leaving any spaces or anything at the end of the line,
I've seen the thread you got the info from on the zen cart forum and provided you havent added any prefix to the zen cart tables in your database, it should be fine, I've checked the sql syntax in an sql validator and it seems fine.

how did you install your zen cart? was it a manual or auto install?
auto installs like to add a prefix or zen_ to the database tables so if it was an auto install try this

DELETE FROM zen_products_options_values where products_options_values_id > 0;

if it was a manual install and there was no prefix set for the database tables try this

DELETE FROM products_options_values where products_options_values_id > 0;

you could check in phpmyadmin via cpanel, go into phpmyadmin and click on your zen cart database, have a look at the database names and if there is a prefix on the tables, it'll be on the start of every database name
eg,
address_book  < no prefix
zen_address_book  < has a prefix of zen_

[Andy c]

yeah everything has a prefix of zen .....
I'm using scotts hosting with scripts

thanks for helping

[Andy c]

can anyone help plz ..am still unable to use attributes

thanks