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

[kkjoseph]

i keep getting the error message 'WARNING: An Error occurred, please refresh the page and try again.' every time I try to upload a sql patch!

SOMEONE PLEASE HELP ME!!!!!!!

[DrByte]

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

[stevesh]

I can point you to the FAQ about that exact problem:

http://www.zen-cart.com/content.php?...-and-try-again

[kkjoseph]

Well this is the only error I see on the error log -

[15-May-2013 12:41:11] PHP Fatal error: 1062: Duplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen' :: INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'columns', 'Select the layout style:<br />Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),'); in /home/fivebc/public_html/includes/classes/db/mysql/query_factory.php on line 120

and I don't know what this means!

[kkjoseph]

Here is the Error Message I get when I use PHPMyAdmin

Error
SQL query:
## The following is used only to remove the column layout grid module:
#delete from configuration where configuration_key in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');
INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified,date_added, use_function, set_function )
VALUES (
'Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'columns', 'Select the layout style:<br />Each product can be listed in its own row (rows option)
or products can be listed in multiple columns per row (columns option)', '8', '40', NULL , NOW( ) , NULL , 'zen_cfg_select_option(array("rows", "columns"),'
);

MySQL said:
#1062 - Duplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen'

[DrByte]

"duplicate entry" means that the thing you're trying to add to the database has already been added. Well, at least for that particular INSERT statement anyway.
Sounds like you've been running the same SQL statements over and over and over again. Not sure why.

[kkjoseph]

Well I have been trying to run a sql patch again because it didnt seem to work. I just install a new template and the configuratons for the template is coming up blank in admin

[DrByte]

Okay. Let's start at the beginning then.
After installing Zen Cart, what have you done? How did you arrive at this stage you're at now? Detailed steps on how to replicate your problem on a fresh installation of v1.5.1. If we can replicate the problem consistently, then we can help you with recovering from the problem.

[kkjoseph]

Ok I had zencart for a while now so I know my way around it.

1. I followed the steps to install the Abbington Mega (New Template)

2. Everything seems to work fine at this point

3. In admin configurations > Abbington Mega is empty- so I can edit my footer social media or slide show on define page

[DrByte]

So, does that mean the real issue you need help with is something to do with the Abbington template?
I suggest posting in the support thread for that template, since the configuration menu details you mention are specific to that template.