Quote Originally Posted by Cath View Post
Good morning!

I'm working locally.

I renamed the template and admin folders in 1_Main_Files and 2_ZC_Version.

I copied the contents of both folders to my ZC folder. I used ZC156 from the 2_ZC_Version folder.

When I checked Option Name Manager, there were no options (the page was blank).

I then ran the following (and it said it was successful):

Code:
SELECT @products_options_types_id := pot.products_options_types_id+1 FROM `products_options_types` pot order by pot.products_options_types_id desc limit 1;
When I ran the following, I received the message: WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

Code:
INSERT INTO `products_options_types` (products_options_types_id, products_options_types_name) VALUES (@products_options_types_id, 'Link');

INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Link product option type', 'PRODUCTS_OPTIONS_TYPE_LINK', @products_options_types_id, 'Numeric value of the link product option type', 6, 0, now(), NULL, NULL);
and my Option Name Manager screen was still blank.

Backup to the rescue!

Can anyone tell me where I've gone wrong?

Thanks in advance.
Well a couple of things at least to try to help. It's hard to say what if anything was done wrong without first knowing what version of Zen cart is involved. Then there is the question of what else might have been installed as an edit or additional plugin. Lastly and perhaps most helpful if attempting to again apply the files, is to report back what information is provided in the debug logs when either experiencing a black screen, partial blank or one of those errors in the SQL statement reports.

Ultimately what is needed to be applied for this module should be commented in the file(s) that are merged with original Zen cart code.