Zen Cart Logo
Forums / General Questions / WARNING: An Error occurred, please refresh the page and try again (tried the fix)

WARNING: An Error occurred, please refresh the page and try again (tried the fix)

Views: 4,676

Results 21 to 22 of 22
14 Apr 2017, 8:44 PM
#21
gsallen101289 avatar

gsallen101289

New Zenner

Join Date:
Aug 2009
Posts:
44
Plugin Contributions:
0

WARNING: An Error occurred, please refresh the page and try again (tried the fix)

mc12345678:

Glad that you've been able to operate as long as you have with ZC and not coming across such a similar issue. Be advised that anyone that was on email distribution from this thread has received your admin directory path, even though the post contents have been modified. Not sure what version of ZC you are using to be able to say what specifically is needed to change that directory, but suggest that you change your admin directory. There is a FAQ associated with it.

As to your issue, when you see an error message like that this FAQ is helpful: https://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

Otherwise/addition to that, please when posting about an issue identify the information that is requested of the posting tips. It will help others help you.

From the log

[14-Apr-2017 20:33:39 UTC] Request URI: /MYADMIN/options_values_manager.php?action=add_product_option_values&value_page=1, IP address: XX.XXX.XXX.XX
#1 trigger_error() called at [/home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/MYDBNAME/public_html/MYADMIN/options_values_manager.php:72]

[14-Apr-2017 20:33:39 UTC] PHP Fatal error: 1062:Duplicate 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',
'Yes',
'1') ==> (as called by) /home/MYDBNAME/public_html/MYADMIN/options_values_manager.php on line 72 <== in /home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php on line 167

14 Apr 2017, 9:12 PM
#22
gsallen101289 avatar

gsallen101289

New Zenner

Join Date:
Aug 2009
Posts:
44
Plugin Contributions:
0

Re: WARNING: An Error occurred, please refresh the page and try again (tried the fix)

gsallen101289:

From the log

[14-Apr-2017 20:33:39 UTC] Request URI: /MYADMIN/options_values_manager.php?action=add_product_option_values&value_page=1, IP address: XX.XXX.XXX.XX
#1 trigger_error() called at [/home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/MYDBNAME/public_html/MYADMIN/options_values_manager.php:72]

[14-Apr-2017 20:33:39 UTC] PHP Fatal error: 1062:Duplicate 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',
'Yes',
'1') ==> (as called by) /home/MYDBNAME/public_html/MYADMIN/options_values_manager.php on line 72 <== in /home/MYDBNAME/public_html/includes/classes/db/mysql/query_factory.php on line 167

So I went into the products_option_values table in phpMyAdmin, and deleted the records whose values are 0, 1. Seems to be working now.