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

[Woody619]

Hi,
I accessed options_values_manager.php with no problem searched back and forwards between pages, deleted one option fine and when I went to rename another option I got a WARNING: An Error occurred, please refresh the page and try again.

Now that error is all I get on attributes controller, option names manager, option values manager.

I have tried the fix on http://www.zen-cart.com/showthread.p...25#post1154025 with no lucky.

I was deleting options in the attributes controller only a few weeks ago with no problems, nothing added or changed since then.

Website www.anythingframed.co.uk

Current version 1.5.1

Fresh install was 1.3.6 FTP and was upgraded to 1.3.7, 1.3.8, 1.3.9h, 1.5.0 and 1.5.1

Sadly the upgrade (last year) from 1.3.9h to 1.5.0 was done by someone on odesk (big mistake, big nightmare).

Used to have the old newsletter subscribe addon.

Have installed, tabbed products pro, Testimonials Manager, Recaptcha Settings, Sitemap XML.

It was never requested but added and turned off Ceon URI Mapping (SEO)

Error log
PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1 :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT') in /home/sites/anythingframed.co.uk/public_html/includes/classes/db/mysql/query_factory.php on line 120

[DrByte]

If you're *still* getting that error then you didn't apply the fix you said you did.
http://www.zen-cart.com/showthread.p...25#post1154025

[Woody619]

Thank you for your reply.

I have downloaded the 3 files in question and compared them to the 3 files from the fix folder and they are identical.

Back to scratching my head, can't understand how it works one minute but the next minute errors.

been using zencart since 2007 so i'm no newbie and have searched and read a lot of other posts before posting this.

[DrByte]

Error log
PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1 :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT') in /home/sites/anythingframed.co.uk/public_html/includes/classes/db/mysql/query_factory.php on line 120

While I understand that you say you changed it, if the errors you're STILL getting are indeed still the same as what you posted above, then you've not applied the fix, else the error message would be different.

[Woody619]

again thank you so much for your reply.

the error log now
[08-Aug-2013 17:37:01] PHP Fatal error: 1062: Duplicate entry '0-1' for key 'PRIMARY' :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT') in /home/sites/anythingframed.co.uk/public_html/includes/classes/db/mysql/query_factory.php on line 120

[DrByte]

The quick fix for that is (if I recall correctly) discussed in the thread that's linked in the post you quoted. Ajeh outlines the process. I'll summarize it here: find that products_option_values table in phpMyAdmin, and delete the records whose values are 0, 1, 'TEXT' already. After that the PHP code should work okay again.

[Woody619]

Excellent thank you very much, working now.

Just had to delete a 0 value in products_option_values table in phpMyAdmin.

[jeffiec]

After applying this fix, I am having a strange issue when trying to apply an option value.

Scenario:
When selecting option names from the admin menu, upon loading the page, zen cart follows the code replaced by this fix, and displays what would be the next product name id in the first column of the table along the insert line, in my case, i have 20 option names, the number displays 21.
NOTE: This does not write to the table! I refreshed it several times going between this page and any other in the admin side.

When selecting option values from the admin menu, upon loading, zen cart follows the code replace by the fix for that code, and displays what should be the next option value, however, in the product value id, it displays 319, I only have 110? for some reason, it jumps 200+ id numbers.
NOTE: This DOES write to the database! It keeps the number in the database unlike the product options names. Navigating away and back, writes another entry.

So when you click insert, of course it fails with a duplicate record of 319 or what ever the last number it incremented to.
I just cant figure out where it is getting the 200+ jump in ids from?
Any help appreciated.
Jeff

[jeffiec]

So rimming out this section, line 28 in options_value_manager.php is seeming to work, it no longer inserts the lines in the database when switching to and from the pages.
for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
if ((int)$languages[$i]['id'] > 0 && !in_array((int)$languages[$i]['id'], $ary)) {
// $db->Execute("INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, " . (int)$languages[$i]['id'] . ", 'TEXT')");
//$db->Execute("INSERT INTO " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) VALUES (" . (int)PRODUCTS_OPTIONS_VALUES_TEXT_ID . ", " . (int)$languages[$i]['id'] . ", 'TEXT')");
}
}
I know this is not the proper fix but it works for now, any help would be appreciated.
Jeff

[bergernovelties]

zen 1.5.1 linux refresh install ftp

adding attribute values cause error on product page. products show in category listing but getting error on product detail page. removing all attributes corrects problem.