Thanks, Linda. This seems to have fixed it. I tested it and had to go back and fill in the required text, yea!
In case anyone else needs this...
- Go to Tools | Database Backup MYSQL and backup your database. Database Backup MYSQL is an add-on for backing up your database. If you don't have it, get it here:
Backup MYSQL Plugin
(Of course, if you know how, you can also use phpMyAdmin to do your backup.)
-
After you backup, go to Tools | Install SQL Patches
-
Paste in the following code (make sure you have no extra spaces at the end)...
INSERT INTO `configuration` VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');
-
Click "Send" and hope nothing goes wrong!
-
After I clicked "Send" I was presented with a plain white page with the following text and thought for sure I just wrecked everything!
1062 Duplicate entry 'IH_VERSION' for key 2
in:
[INSERT INTO configuration VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');]
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.
-
Instead of going back with the BACK button, I went to the Admin home page (I had to log-in again).
-
I went to my test product, tried to add it to the cart and Voila! "Sorry, you need to fill something in first!"
Hope this helps if anyone has this same problem.
Thanks again, Linda!
Very sincerely,
Rebekah
**TheWindCutter.com**
Professional Microphone Windscreens
*Got wind noise? We've got you covered. *
