Quote Originally Posted by qhome View Post
@mitchcecg
Try this: MYSQL 5 version Only!

I read that empty quotes '' are supposed to be changed to NULL in strict mode, so I did that. See if that works for you.


Code:
INSERT INTO configuration VALUES (NULL, 'Return: Full Name', 'USPS_RETURN_FULLNAME', NULL, 'Set this to your return address Full Name', last_insert_id(), '5', now(), now(), NULL, NULL),
                                 (NULL, 'Return: Company Name', 'USPS_RETURN_COMPANY_NAME', NULL, 'Set this to your return address Company Name', last_insert_id(), '10', now(), now(), NULL, NULL),
                                 (NULL, 'Return: Address 1', 'USPS_RETURN_ADDRESSONE', NULL, 'Set this to your return address street 1', last_insert_id(), '15', now(), now(), NULL, NULL),
                                 (NULL, 'Return: Address 2', 'USPS_RETURN_ADDRESSTWO', NULL, 'Set this to your return address street 2', last_insert_id(), '20', now(), now(), NULL, NULL),
                                 (NULL, 'Return: City', 'USPS_RETURN_CITY', NULL, 'Set this to your return address city', last_insert_id(), '25', now(), now(), NULL, NULL),
                                 (NULL, 'Return: State', 'USPS_RETURN_STATE', NULL, 'Set this to your return address state. NOTE: THIS MUST BE IN A 2 LETTER ABBREVIATED FORMAT (i.e. AZ, KY, MI)', last_insert_id(), '30', now(), now(), NULL, NULL),
                                 (NULL, 'Return: ZipCode', 'USPS_RETURN_ZIPCODE', NULL, 'Set this to your return address zipcode', last_insert_id(), '35', now(), now(), NULL, NULL),
                                 (NULL, 'Return: Phone Number', 'USPS_RETURN_PHONENUMBER', NULL, 'Set this to your company phone number for International Shipping. (no dashes: 4041234567)', last_insert_id(), '40', now(), now(), NULL, NULL),
                                 (NULL, 'Delivery: Default Notify via Email', 'USPS_DELIVERY_DEFAULT_EMAIL_NOTIFY', 'true', 'Set this to true if you want the Notify By Email checkbox checked by default', last_insert_id(), '45', now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),"),
                                 (NULL, 'Delivery: Default Contents Value', 'USPS_DELIVERY_DEFAULT_CONTENTS_VALUE', '15.00', 'Set this if you want a default contents value for International shipping', last_insert_id(), '50', now(), now(), NULL, NULL),
                                 (NULL, 'Delivery: Default Weight (Pounds)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_POUNDS', '1', 'Set this to the default weight in pounds. Useful if you sell only one type of item. Leave blank if using the order total weight', last_insert_id(), '55', now(), now(), NULL, NULL),
                                 (NULL, 'Delivery: Default Weight (Ounces)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_OUNCES', NULL, 'Set this to the default weight in ounces. Useful if you sell only one type of item. Leave blank if using the order total weight', last_insert_id(), '60', now(), now(), NULL, NULL),
                                 (NULL, 'Delivery: Default Shipping from Same ZipCode (Radio Button)', 'USPS_DELIVERY_SAME_ZIPCODE', 'same', 'Set this to same if you want to have your Return Address Zipcode as the default Ship-From zipcode. If set to Other, then enter in your default Ship-From zipcode in the next setting', last_insert_id(), '65', now(), now(), NULL, "zen_cfg_select_option(array('same', 'other'),"),
                                 (NULL, 'Delivery: Default Shipping from Other ZipCode (If Radio Button set to Other)', 'USPS_DELIVERY_OTHER_ZIPCODE', '00000', 'Set the default ZipCode you would like as your Ship-From zipcode. Only if the above setting is set to Other', last_insert_id(), '70', now(), now(), NULL, NULL),
                                 (NULL, 'Delivery: Default Non-Delivery Checkbox (Return-to-Sender)', 'USPS_DELIVERY_DEFAULT_NONDELIVERY', 'Y', 'Set this to Y if you want the checkbox for Return-To-Sender to be checked by default (International Packages Only)', last_insert_id(), '75', now(), now(), NULL, "zen_cfg_select_option(array('N', 'Y'),"),
                                 (NULL, 'Delivery: Default Privacy Acknowledge Checkbox', 'USPS_DELIVERY_DEFAULT_ACKNOWLEDGE', 'on', 'Set this to on if you want the Acknowledge checkbox to be checked by default (International Packages Only)', last_insert_id(), '80', now(), now(), NULL, "zen_cfg_select_option(array('off', 'on'),");
when I cut and paste your it into the sql command I get the following responce

1263 Column was set to data type implicit default; NULL supplied for NOT NULL column 'configuration_value' at row 1
in:
[INSERT INTO hi_configuration VALUES (NULL, 'Return: Full Name', 'USPS_RETURN_FULLNAME', NULL, 'Set this to your return address Full Name', last_insert_id(), '5', now(), now(), NULL, NULL), (NULL, 'Return: Company Name', 'USPS_RETURN_COMPANY_NAME', NULL, 'Set this to your return address Company Name', last_insert_id(), '10', now(), now(), NULL, NULL), (NULL, 'Return: Address 1', 'USPS_RETURN_ADDRESSONE', NULL, 'Set this to your return address street 1', last_insert_id(), '15', now(), now(), NULL, NULL), (NULL, 'Return: Address 2', 'USPS_RETURN_ADDRESSTWO', NULL, 'Set this to your return address street 2', last_insert_id(), '20', now(), now(), NULL, NULL), (NULL, 'Return: City', 'USPS_RETURN_CITY', NULL, 'Set this to your return address city', last_insert_id(), '25', now(), now(), NULL, NULL), (NULL, 'Return: State', 'USPS_RETURN_STATE', NULL, 'Set this to your return address state. NOTE: THIS MUST BE IN A 2 LETTER ABBREVIATED FORMAT (i.e. AZ, KY, MI)', last_insert_id(), '30', now(), now(), NULL, NULL), (NULL, 'Return: ZipCode', 'USPS_RETURN_ZIPCODE', NULL, 'Set this to your return address zipcode', last_insert_id(), '35', now(), now(), NULL, NULL), (NULL, 'Return: Phone Number', 'USPS_RETURN_PHONENUMBER', NULL, 'Set this to your company phone number for International Shipping. (no dashes: 4041234567)', last_insert_id(), '40', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Notify via Email', 'USPS_DELIVERY_DEFAULT_EMAIL_NOTIFY', 'true', 'Set this to true if you want the Notify By Email checkbox checked by default', last_insert_id(), '45', now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),"), (NULL, 'Delivery: Default Contents Value', 'USPS_DELIVERY_DEFAULT_CONTENTS_VALUE', '15.00', 'Set this if you want a default contents value for International shipping', last_insert_id(), '50', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Weight (Pounds)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_POUNDS', '1', 'Set this to the default weight in pounds. Useful if you sell only one type of item. Leave blank if using the order total weight', last_insert_id(), '55', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Weight (Ounces)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_OUNCES', NULL, 'Set this to the default weight in ounces. Useful if you sell only one type of item. Leave blank if using the order total weight', last_insert_id(), '60', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Shipping from Same ZipCode (Radio Button)', 'USPS_DELIVERY_SAME_ZIPCODE', 'same', 'Set this to same if you want to have your Return Address Zipcode as the default Ship-From zipcode. If set to Other, then enter in your default Ship-From zipcode in the next setting', last_insert_id(), '65', now(), now(), NULL, "zen_cfg_select_option(array('same', 'other'),"), (NULL, 'Delivery: Default Shipping from Other ZipCode (If Radio Button set to Other)', 'USPS_DELIVERY_OTHER_ZIPCODE', '00000', 'Set the default ZipCode you would like as your Ship-From zipcode. Only if the above setting is set to Other', last_insert_id(), '70', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Non-Delivery Checkbox (Return-to-Sender)', 'USPS_DELIVERY_DEFAULT_NONDELIVERY', 'Y', 'Set this to Y if you want the checkbox for Return-To-Sender to be checked by default (International Packages Only)', last_insert_id(), '75', now(), now(), NULL, "zen_cfg_select_option(array('N', 'Y'),"), (NULL, 'Delivery: Default Privacy Acknowledge Checkbox', 'USPS_DELIVERY_DEFAULT_ACKNOWLEDGE', 'on', 'Set this to on if you want the Acknowledge checkbox to be checked by default (International Packages Only)', last_insert_id(), '80', now(), now(), NULL, "zen_cfg_select_option(array('off', 'on'),");]
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.

Hope this helps
THANX
MITCHcecg