Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Setting Value Options i get: WARNING: An Error occurred, please refresh the page and

Setting Value Options i get: WARNING: An Error occurred, please refresh the page and

Views: 818

Results 1 to 2 of 2
2 Jan 2013, 1:54 PM
#1
home2gifts avatar

home2gifts

New Zenner

Join Date:
Dec 2012
Posts:
12
Plugin Contributions:
0

Setting Value Options i get: WARNING: An Error occurred, please refresh the page and

Whilst trying to set option values under Admin>Catalog>Option Value Manager After clicking the insert button i get 'WARNING: An Error occurred, please refresh the page and try again.' I have viewed my myDEBUG-adm.log which reads as follows

[02-Jan-2013 12:40:30 UTC] PHP Fatal error: 1062: Duplicate entry '1-1' for key 1 :: insert into products_options_values
(products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
values ('1',
'1',
'Wrap Around',
'0') in /var/www/vhosts/**********.co.uk/httpdocs/includes/classes/db/mysql/query_factory.php on line 120

And Line 120 of that file reads :

trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);

Any ideas how to solve this issue anybody?

2 Jan 2013, 2:46 PM
#2
home2gifts avatar

home2gifts

New Zenner

Join Date:
Dec 2012
Posts:
12
Plugin Contributions:
0

Re: Setting Value Options i get: WARNING: An Error occurred, please refresh the page and

I have sorted it. In the database manager i noticed there was a value already set at ID 1 which zencart was trying to create again. I set the value id to 99 in the database manager and then went back to create the option value in zencart and it has now started the value ids at 100 problem solved