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

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

Quote:

---

Originally Posted by narsaw

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.

Code:

---

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

---

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

Here is what is looks like:


****Giant image deleted****

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.

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

Quote:

---

Originally Posted by 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.

---

**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.

Quote:

---

Originally Posted by narsaw

Strange, I do see a "referred by" in Admin->Customers??, what version of zen cart are you using?

Can you post the exact link where you downloaded this contrib from?

---

this link It was updated 6/30

Anybody know if this contribution is compatible with 1.3.6 of ZenCart.

I've compared a couple of the files and there seems to be a large numer of differences.

Craig

Yes, there are a lot of files that have changed. I tried to merge them and was only partly successful. The log in form works now just fine, but I do not see what customers selected in the admin. I guess I still miss something.

Did anybody come up with an updated file set for 1.3.6? I can't figure this out myself. :(

This contribution was really what I need to see how my new customers find me. How else can one know how people that register really learned about us and how the found us? This contribution seems to be a small one but is incredibly useful.

I GOT IT!

customers.php had a line missing. Now everything seems to work fine in 1.3.6. I would ranger_lp to look over my merged files and then they could be released as the updated mod. He did the last release and knows it a lot better than me. Also I did not put any comments anywhere like "real" programmers do. :) but it is working, did I say I am happy!! :))