How Did You Hear About Us? Referrals Mod [Support Thread]

[cherylkemp]

Ok I reinstalled all the files and tried running "update_zen.sql and I get this message

ERROR: Cannot ADD column customers_info_source_id because it already exists.
Error ERROR: Cannot insert configuration_key "DISPLAY_REFERRAL_OTHER" because it already exists
Error ERROR: Cannot insert configuration_key "REFERRAL_REQUIRED" because it already exists

that might not be a big deal...just means they're already in the database. Still didn't work after that? Did you get any other message about any successful sql stuff in that same pass? you could change the references to "create" below to "replace and run it again to see if it is completely successful then. Not sure if that will solve your problem though.

DROP TABLE IF EXISTS sources;
CREATE TABLE sources (
  sources_id int NOT NULL auto_increment,
  sources_name varchar(64) NOT NULL,
  PRIMARY KEY (sources_id),
  KEY IDX_SOURCES_NAME (sources_name)
);

INSERT INTO sources VALUES (1, 'Google');
INSERT INTO sources VALUES (2, 'Yahoo!');
INSERT INTO sources VALUES (3, 'AOL');
INSERT INTO sources VALUES (4, 'MSN');
INSERT INTO sources VALUES (5, 'ZenCart');

DROP TABLE IF EXISTS sources_other;
CREATE TABLE sources_other (
  customers_id int NOT NULL default '0',
  sources_other_name varchar(64) NOT NULL,
  PRIMARY KEY (customers_id)
);

ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;


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());

[narsaw]

Still same thing "Other" gets update no matter what the customer selects.

Here is what is looks like:


****Giant image deleted****

[ranger_lp]

Referral Sources only show Other as a count. You have to look at Customers -> Customers to see what was entered as a "write-in" on an Other selection.

[narsaw]

Here is a screen shot of Admin->Customers->Customers

http://www.pcappliances.com/referrals.JPG

I've personally created some of those ac****s and selected "Google, yahoo and Other (and typed in "friend", "word of mouth", etc

Referral Sources only show Other as a count. You have to look at Customers -> Customers to see what was entered as a "write-in" on an Other selection.

[narsaw]

**SOLVED**

Turns that I was using and 'override' (includes/modules/my_template/create_accoutns.php file which I neglected to update with the inclues/modules/create_account.php from the contribution. Works beautifully.


Special thanks to ranger_lp for his tireless work in helping me track down this problem.