Error when opening Attribute Controller

Apologies if this is in the wrong section.

I am getting an error when trying to click on the Attribute Controller.
I get the following 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
in:
[INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Can someone please let me know how I can fix this?

Thanks
Kerry

kerrydunk:

I am getting an error when trying to click on the Attribute Controller.
I get the following 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

This looks like you are missing a Database record. If you are lucky, the problem will 'fix itself' by simply navigating your way to catalog->option_value_manager.

From the zencart code I see........
// check for damaged database, caused by users indiscriminately deleting table data

Followed by this code, which looks like it fixes the missing data.

$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 could be way off the mark here though.

Cheers
RodG