Attribute error

[sportsguy]

What does this mean? It come when I try to add an option value to an option name. Basically I'm still a beginner, sorted out one issue now on to this one. I learn quick so thanks to anyone that can help!

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', 'Red', '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.

[Ajeh]

It looks like you either manually tried to clean out your database tables or moved databases or otherwise lost the auto increment settings ...

You could run, AFTER a backup of your database, the file:

/zc_install/sql/db_rebuild_autoincrement.sql

This will rebuild the auto increment fields ...

[sportsguy]

Thanks. I of course wouldn't have thought of that so I'll give it a shot. You're a big help!

[peanut77]

Hi I am having the same problem but with amending category titles - I have posted in general questions - so apologies for posting twice but this kind of matches my issue - I have ran the patch as suggested above but I still get the following error when adding or amending a category mete tag title

1062 Duplicate entry '1-1' for key 1
in:
[insert into welshtartans_zmeta_tags_categories_description (metatags_title, metatags_keywords, metatags_description, categories_id, language_id) values ('Welsh Cilt Regalia', '', '', '1', '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.

[sportsguy]

So..referring to the advice you gave me on my attribute error thread:

You could run, AFTER a backup of your database, the file:

/zc_install/sql/db_rebuild_autoincrement.sql

This will rebuild the auto increment fields ...

Can you step me through this very simply. I have made my backup but the idiot question is how do I run
/zc_install/sql/db_rebuild_autoincrement.sql

I added it onto my domain but the page won't load.

any suggestion? Thank you so much.

Jeff
Sportsguy

[peanut77]

I ran this by opening that file up in notepad and then going to admin and then tools?install sql patches and running it there.

(back up back up back up!! - my mantra before doing anything :-)

[sportsguy]

Thanks Peanut,

OK, I opened in Notepad. Then do I copy to the text area in Tools admin install sql patches? Or....do I upload the notepad file.

This is not my area of expertise but I learn quickly from this forum.

[peanut77]

Hello

You copy everything to the text area in tools>install sql patches - then hit execute

(Again back up before you do anything)

This basically runs this query on your database.

I am no expert and everything I have learned about databases, sql patches etc has also been picked up from here !

[sportsguy]

Ok, so I copied the text and hit "send". I get the whole query filling up my browser page and done. What do I do after that? I checked and my attributes still gave me the same error.

[LostSheep]

Hello
After configuring product attribute I've an error msg at my user side web, in product browsing:
Fatal error: Call to undefined function zen_truncate_paragraph() in C:\Program Files\...\htdocs\zen\includes\modules\meta_tags.php on line 271
What it points to? Please advise me.
Thanks mate