Hi,
I am on zencart v1.3.7 and have been trying to install the How Did You Hear About Us Version 1.3.7 mod -- I was also getting the 1064 SQL syntax error message. I tried several of the suggestions here with no luck through the zencart sql patch screen. So, I went to my phpmyadmin screen on my hosting site and pasted in:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display "Other" Referral option', 'DISPLAY_REFERRAL_OTHER', 'true', 'Display "Other - please specify" with text box in referral source in account creation', '1', '22', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Referral', 'REFERRAL_REQUIRED', 'true', 'Require the Referral Source in account creation', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

The error message that came up on their screen which said I needed to check the syntax indicated a difference in the word "now" just before the ()); and displayed that word in CAPS. Knowing nothing about SQL, I left everything else the same in the above sql patch, except I changed the "now" to "NOW" and submitted the sql again. I got a success message. I went back to my store, and now I have the two options showing up under the configuration for My Store and Customer Details. I just checked my "Online Catalog" and so far, the screen where customers can create an account looks correct with the "Other" option showing up as well as the text box where they can type.