Error when adding new option values

[rdhoke]

I made fixes from http://www.zen-cart.com/showthread.p...-after-upgrade and as well as the table-prefixes fix after I downloaded the updated files but still have problem selecting option value so I can make files downloadable attached are the files I modified.

[Ajeh]

Your files are not correct ...

Could you try these three files that I have attached:

[rdhoke]

Unfortunatly those files still didnt help. Im trying to set up an option value but unfortunatly when I insert it I still get the error on a blank white page

WARNING: An Error occurred, please refresh the page and try again.

My wife is trying to set up a web site to sell downloadable images but we cant set up the value for the download.

Thanks for any help you can provide

[DrByte]

What's the actual error message contained in the logs? http://www.zen-cart.com/content.php?...-and-try-again

[rdhoke]

[28-Dec-2012 09:48:56] PHP Fatal error: 1062uplicate entry '1-1' for key 1 :: insert into zen_products_options_values
(products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
values ('1',
'1',
'Zip Format',
'0') in /home/content/14/8629614/html/includes/classes/db/mysql/query_factory.php on line 101

[DrByte]

That error message shows that your problem is not the same as the issue that the bugfix was for.
But it does suggest that perhaps you've not actually installed and used the files Ajeh posted for you.

Yours is trying to add a new attribute overtop of an option-value record (probably a system-generated record) that already exists instead of correctly renumbering itself as a new record.

So that begs the question: in what ways have you modified the Zen Cart code or database from the original installation? What's the history of this store? Has it had any upgrades? Has it had the database deleted and rebuilt for some reason? Have you manually purged data for some reason? Have you created and deleted numerous products or attributes? What plugins have you installed, if any? etc

Are you absolutely certain that you've uploaded the files Ajeh gave you and replaced the 3 files with her updated versions?

What happens if you manually delete and reset the options-values data in the database, by going to Admin->Tools->Install SQL Patch and paste this code into the box and click Send:

TRUNCATE TABLE products_options_values;

Does it work any differently after you do that? NOTE: You'll lose ALL existing options-values data by doing that.

[rdhoke]

That error message shows that your problem is not the same as the issue that the bugfix was for.
But it does suggest that perhaps you've not actually installed and used the files Ajeh posted for you.

Code was installed

Yours is trying to add a new attribute overtop of an option-value record (probably a system-generated record) that already exists instead of correctly renumbering itself as a new record.

So that begs the question: in what ways have you modified the Zen Cart code or database from the original installation? What's the history of this store? Has it had any upgrades? Has it had the database deleted and rebuilt for some reason? Have you manually purged data for some reason? Have you created and deleted numerous products or attributes? What plugins have you installed, if any? etc

No modifications to the code other than installing 1.5.1 files to update. Store is fairly new its been a work in progress. Zen Cart has been used before for a different store that didnt have downloadable files so this is a new issue for me. Dont know how to manually purge data. only one product listed right now for testing purposes only deleted original attributes as they did not work. No plug ins only changed theme to the Appearel Boutique theme. I have made exact copies of directories as a backup before upgrades then deleted files after upgrades didnt work then restored old files

Are you absolutely certain that you've uploaded the files Ajeh gave you and replaced the 3 files with her updated versions?

Yes I did several two or three times

What happens if you manually delete and reset the options-values data in the database, by going to Admin->Tools->Install SQL Patch and paste this code into the box and click Send:

TRUNCATE TABLE products_options_values;

Does it work any differently after you do that? NOTE: You'll lose ALL existing options-values data by doing that.

I now recieve that same error message for option value manager option name manager and attributes controller. Now I cant even attempt to make changes.

[DrByte]

I now recieve that same error message for option value manager option name manager and attributes controller. Now I cant even attempt to make changes.

What's in the myDebug-adm-xxxxxxx.log files when you get that error now?

[rdhoke]

[28-Dec-2012 20:37:42] PHP Fatal error: Cannot redeclare draw_optiontype_pulldown() (previously declared in /home/content/14/8629614/html/adminXXXX/attributes_controller.php:606) in /home/content/14/8629614/html/adminXXXX/includes/languages/english/attributes_controller.php on line 613

This is the error message in the log after entering sql update.

[DrByte]

That tells me you've mixed up the files.

Each admin page consists of two files: the main code and the supporting language file.
You've replaced the language file by overwriting it with the main code file.

Example: these files are expected to have completely different contents inside them, but you've copied the first one overtop of the second one:
/admin/attributes_controller.php
/admin/includes/languages/english/attributes_controller.php

You'll need to put back the originals of the language files.