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

14 May 2006, 22:09

#1

martyndw2005

Zen Follower

Join Date:: Aug 2005
Posts:: 70
Plugin Contributions:: 0

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

http://www.zen-cart.com/downloads.php?do=file&id=90

[h=2]Can't get "referrals " mod working[/h]This is the error message" 1146 TABLE '[database_zc1.TABLE_SOURCES' does not exist

The error message shows up on the page where people register and it appears under how did you hear about us this should be a drop down menu

Checked databases we have zen_sources as a table

Please help

Regards
Martyn

website : www.beeunique.co.uk

We are not using the mod at the moment as when it is implemented it stops people creating new accounts due to the error.

Please let me know if you require more information to fix this.

All the tables in the database start zen_

15 May 2006, 19:35

#2

martyndw2005

Zen Follower

Join Date:: Aug 2005
Posts:: 70
Plugin Contributions:: 0

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

As a matter of interest has anyone got this mod working on zencart 1.2.6.

I can see the mod for 1.3. I have searched through the other posts on this. If someone has the sql and the files that work with 1.2.6 please let me know. I really want to get this working and it is driving me crazy.

Regards

Martyn

15 May 2006, 19:46

#3

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 1

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

you need to make sure that you have the extra_datafiles installed

you need to define TABLE_SOURCES

15 May 2006, 22:36

#4

martyndw2005

Zen Follower

Join Date:: Aug 2005
Posts:: 70
Plugin Contributions:: 0

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

Hi, Thanks for your help so far.

I have the options working now ie options can be selected from the drop down menu...

I seem to have a problem the selected data in sources or data entered in other_sources does not seem to go anywhere.

Any ideas where this data is ment to go? and how admin can be altered to show per customer the referals information.

Regards

Martyn

16 May 2006, 08:20

#5

martyndw2005

Zen Follower

Join Date:: Aug 2005
Posts:: 70
Plugin Contributions:: 0

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

I don't think I made myself clear in my last message. New customers can select the options , but when the new customer has been created the customers_heard_of_us_from field in zen_customers table is not updated i have tried this a few times.

Should this information be in zen_customers or another table?

Regards

Martyn

www.beeunique.co.uk

17 May 2006, 07:51

#6

martyndw2005

Zen Follower

Join Date:: Aug 2005
Posts:: 70
Plugin Contributions:: 0

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

Can anyone who has this mod working please let me know where the source and other source data goes in the database.

Regards

Martyn

www.beeunique.co.uk

30 Jun 2006, 19:42

#7

bryony

Zen Follower

Join Date:: Dec 2005
Posts:: 137
Plugin Contributions:: 0

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

Martyn,

Have you had any luck with this? I'm running 1.3.1 and thought it all installed correctly - the customers can still select where they heard of us (and I can administer the choices) but I don't get the information - on my old version of Zen it used to appear in the "Customers" section of Admin.

Anyone else?

06 Jul 2006, 20:05

#8

narsaw

New Zenner

Join Date:: May 2006
Posts:: 38
Plugin Contributions:: 0

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

Bryony:
Martyn,

Have you had any luck with this? I'm running 1.3.1 and thought it all installed correctly - the customers can still select where they heard of us (and I can administer the choices) but I don't get the information - on my old version of Zen it used to appear in the "Customers" section of Admin.

Anyone else?

Same problem here. Customers can select but the information is no where to be found.

Any resoultion?

06 Jul 2006, 21:27

#9

cherylkemp

Zen Follower

Join Date:: Mar 2006
Posts:: 179
Plugin Contributions:: 0

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

Bryony:
Martyn,

Have you had any luck with this? I'm running 1.3.1 and thought it all installed correctly - the customers can still select where they heard of us (and I can administer the choices) but I don't get the information - on my old version of Zen it used to appear in the "Customers" section of Admin.

Anyone else?

I just installed this a couple of days ago and it works fine...however the logged info shows up under extras/referral sources as well as in the customer section under "referred by" not sure if that will help you at all

06 Jul 2006, 21:52

#10

narsaw

New Zenner

Join Date:: May 2006
Posts:: 38
Plugin Contributions:: 0

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

cherylkemp:
I just installed this a couple of days ago and it works fine...however the logged info shows up under extras/referral sources as well as in the customer section under "referred by" not sure if that will help you at all

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?

06 Jul 2006, 22:38

#11

narsaw

New Zenner

Join Date:: May 2006
Posts:: 38
Plugin Contributions:: 0

Re: 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

07 Jul 2006, 00:47

#12

cherylkemp

Zen Follower

Join Date:: Mar 2006
Posts:: 179
Plugin Contributions:: 0

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

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.

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

07 Jul 2006, 02:27

#13

narsaw

New Zenner

Join Date:: May 2006
Posts:: 38
Plugin Contributions:: 0

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

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

Here is what is looks like:

****Giant image deleted****

07 Jul 2006, 14:42

#14

ranger_lp

Zen Follower

Join Date:: Feb 2004
Posts:: 269
Plugin Contributions:: 1

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

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.

07 Jul 2006, 15:09

#15

narsaw

New Zenner

Join Date:: May 2006
Posts:: 38
Plugin Contributions:: 0

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

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

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.

07 Jul 2006, 20:46

#16

narsaw

New Zenner

Join Date:: May 2006
Posts:: 38
Plugin Contributions:: 0

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

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

09 Jul 2006, 00:38

#17

cherylkemp

Zen Follower

Join Date:: Mar 2006
Posts:: 179
Plugin Contributions:: 0

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

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

28 Nov 2006, 14:54

#18

ces

Zen Follower

Join Date:: Nov 2004
Posts:: 199
Plugin Contributions:: 0

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

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

29 Nov 2006, 22:23

#19

mydanilo

Totally Zenned

Join Date:: Dec 2004
Posts:: 1,024
Plugin Contributions:: 0

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

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.

01 Dec 2006, 19:31

#20

mydanilo

Totally Zenned

Join Date:: Dec 2004
Posts:: 1,024
Plugin Contributions:: 0

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

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!! :))