Issue with Option Value

[konzo]

So everything else in my page works fine, I can add options in "product options" in the "options name manager", however when I go into the "option values" and try to add a new value and click "insert" to finish it, the page goes to a new page that says:

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

I have reinstalled the entire site using FTP program.

Why wont it still work ??? As I said its pretty much the only issue I am having.

www.tallywhackers.com.au/twap

[Ajeh]

Please click Reply and answer the questions listed ...

[konzo]

Version 1.50
New site installed by FileZilla and started using zc_install
Only changed the colors on the template, added a logo and some products. Added PayPal. changed the meta tags file and page name
I've searched forum and facts (which have previously helped).
This is my first site in a few years, had a zen cart back in 2007/08 for a different business.
Problem started first time I tried to use the attributes section
Otherwise site seems to work fine

www.tallywhackers.com.au/twap is the site

[Ajeh]

If you go in phpMyAdmin and browse the table:
products_options_types

Do you have 6 records in there?

If you browse the table:
products_options

how many records do you have?

If you browse the table:
products_options_values

how many records do you have?

Also, try to reload the page:
/your_admin_dir/options_values_manager.php

Also, look in the directory:
/cache

do you see any debug logs from the admin and if so, what errors are they reading?

[konzo]

If you go in phpMyAdmin and browse the table:
products_options_types

Do you have 6 records in there?

Yes

Dropdown
Text
Radio
Checkbox
File
Read Only

If you browse the table:
products_options

how many records do you have?

Two

1. Size (Dropdown)
2. Colour (Dropdown

I entered them myself

If you browse the table:
products_options_values

how many records do you have?

Zero. It wont let me enter them. When I click insert is when the problem occurs and it goes to a blank page.

Also, try to reload the page:
/your_admin_dir/options_values_manager.php

I have done that ... still doesnt work

Also, look in the directory:
/cache

do you see any debug logs from the admin and if so, what errors are they reading?

Plenty of Errors in Debugs. They are as follows, ill just include the first 2 and the last 2:

[28-Jan-2012 21:32:35] PHP Fatal error: 1062uplicate entry '1-1' for key 'PRIMARY' :: insert into products_options_values
(products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
values ('1',
'1',
'One Size',
'1') in /clientdata/apache-www/t/a/tallywhackers.com.au/www/twap/includes/classes/db/mysql/query_factory.php on line 101




[28-Jan-2012 21:32:45] PHP Fatal error: 1062uplicate entry '1-1' for key 'PRIMARY' :: insert into products_options_values
(products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
values ('1',
'1',
'One Size',
'1') in /clientdata/apache-www/t/a/tallywhackers.com.au/www/twap/includes/classes/db/mysql/query_factory.php on line 101




[31-Jan-2012 10:53:58] PHP Fatal error: 1062uplicate entry '1-1' for key 'PRIMARY' :: insert into products_options_values
(products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
values ('1',
'1',
'Black',
'1') in /clientdata/apache-www/t/a/tallywhackers.com.au/www/twap/includes/classes/db/mysql/query_factory.php on line 101




[31-Jan-2012 10:58:14] PHP Fatal error: 1062uplicate entry '1-1' for key 'PRIMARY' :: insert into products_options_values
(products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
values ('1',
'1',
'test',
'1') in /clientdata/apache-www/t/a/tallywhackers.com.au/www/twap/includes/classes/db/mysql/query_factory.php on line 101

[Ajeh]

Could you run this in the Tools ... Install SQL Patches ...

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

[konzo]

I tried to install it as you said, when I submitted, I got the following:



Uploaded with ImageShack.us

[Ajeh]

Could you go to your phpMyAdmin ...

and run the following:

DROP TABLE IF EXISTS products_options_values;
CREATE TABLE products_options_values (
  products_options_values_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  products_options_values_name varchar(64) NOT NULL default '',
  products_options_values_sort_order int(11) NOT NULL default '0',
  PRIMARY KEY (products_options_values_id,language_id),
  KEY idx_products_options_values_name_zen (products_options_values_name),
  KEY idx_products_options_values_sort_order_zen (products_options_values_sort_order)
) ENGINE=MyISAM;

[konzo]

excuse my stupidity, but phpMyAdmin? Is that the actual file on my PC or on the back of house admin on the net?

[Ajeh]

You have a Control Panel with your domain ... you should find it in there ... if not, contact your hosting provider and ask them how to access it ...