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

[stellarweb]

UH OH!! You are WAY BAD for still being on 1.2.6 - you need to hack at your HEAD with that graphite shaft! giggle

Upgrading is not that bad.... just make sure you back up the site and database first - make sure your design files and modified files are all in a "custom" directory - and follow the instructions... you will do just fine!

Well know that I know I'm (cough) using version 1.2.6 WE know that the Referral mod won't work "easily". Thanks for the tips Stellar. It seems I have to either trade in my wood for a graphite shaft or hack away with 1.3.7.

[tatiana77]

Hello,

Fished around the forums and could not figure this out, and have noticed others with the same problem:

1) On Admin>Customers page, there is a "referred by" title, but nothing is showing up for all the customers, just --none--... is this just a '1st Discount coupon' issue, because if it is, this ain't workin for me either.

2) Admin>Extras>Referral Sources: Only item is "Other", and no matter what customer enters in the "How did you hear about us" field, the number will keep adding to this "Other" total, despite having several entries under Admin>Extras>Referrals

Here is my configuration:
Admin>Config>My Store>Display "Other" Referral option=true
Admin>Config>Customer Details>Require Referral=true
Admin>Config>Customer Details>Customers Referral Status=2
Admin>Extras>Referrals>AOL, Google, Magazine, Etc...
Admin>Extras>Referral Sources>Sources:'Other', Referred:4

-When I click on 'Other' it just says Displaying 0 to 0 (of 0 referral sources)" although I don't recall entering anything during test customer registration in the "Other" field, but my main issue is that there is no way to see totals of the "AOL, Google, Magazine etc" referrals.

Help??!!?

[gogolf]

I guess I have the same problem other users of the mod have run into:

I'm not seeing the referral posted when I view the Admin-Customer's screen, and the referral does not appear in the Reports-Customers Referral.

Inspecting my database in PHP I can see a field customers_referral in the customers table however there is nothing in the field for a record I created for a new customer.

Any suggestions?

[gogolf]

A newbie trying to get this to work:

I was looking at my tables in the database and noted a message in MyPHP (server is running version 4.4.4) that stated
UNIQUE and INDEX keys should not both be set for column `configuration_key

Looks like the attached picture:

Does this indicate something that needs to be changed in the tables to make the mod work?

[zilla]

I just did a clean install of the files that are currently in the downloads section to this site http://www.stellarsupplements.com/

I then copied and pasted the install_referrals.sql into the database in the admin section under tools/install sql patches... the code is pasted below.

The install went smoothly - and all worked well, with no changing of the files, so I am befuddled as to why you would have to change anything in the file in order to get it to work. I have installed this on several websites with the code intact, and it works fine on all of them.... BUT they were all on the same server with the same version of sql / php / etc running. Like you, I know enough sql to make me very dangerous so wondering if the problem is different versions of sql or php??

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

I've just installed using Stellarweb's code above... first to work for me! All seems well, apart from the fact that there is no mention of Referral within Admin... I know it'll be down to user error... but don't know where to begin, any ideas?

[zilla]

As I said... User error!!!
Re-uploaded all Admin files and all is now well!
You've gotta love thinking for yourself!

[gogolf]

As I said... User error!!!
Re-uploaded all Admin files and all is now well!
You've gotta love thinking for yourself!

Tried that.
Nothing appears below the Admin-Customers "TABLE_HEADING_REFERRED_BY"
after creating a new customer.

And, after the new customer placed an order I'm getting the following error
when trying to view the order through Admin-Customers-Orders:
Fatal error: Cannot redeclare class order in ........./admin/includes/classes/order.php on line 23

[zilla]

have you double checked that you've uploaded all the files to all the right places? Are you using the same SQL that I did because the one supplied with the mod didn't work for me.

[gogolf]

have you double checked that you've uploaded all the files to all the right places? Are you using the same SQL that I did because the one supplied with the mod didn't work for me.

I have tried several variations of the SQL mod regarding the "true" statements,
the "/" as well as the ',' issues. Evertime I run the SQL mod the message is the same as everyone else got ... the tables were already updated and can't do it again, unless that means that some of the SQL patch did not take place.

I'm using:
v1.3.7.1 [2007-07-11 19:10:46] (Fresh Installation)
Server OS: Linux 2.6.9-34.ELsmp
PHP Version: 4.4.4 (Zend: 1.3.0)
Database: MySQL 4.1.21-standard
PHP Version 4.4.4

Getting this mod to work for me is very important, you get to know where your customers are coming from. If there is another way to capture the same information other than this mod I'd give that a shot too.

[gogolf]

Update on trying to get the mod to work (refer to previous posts).
Last night deleted the new store and reinstalled it.
Installed the mod per its instructions.
Went into mysql
Went into myphpadm
Cut and pasted the sql patch and ran it.
Got the following error:
SQL query:

ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;

MySQL said: Documentation
#1060 - Duplicate column name 'customers_info_source_id'

Does this mean the table was already there and it should not have been?
Or, does this mean there is a problem with the install_referrals.sql ?

Again I have the same problem as before, if a new customer signs up to the store the referral does not appear under under TABLE_HEADING_REFERRED_BY when viewed from Admin/Customers, and nothing shows up when you run a referrals reports.

And if I look at the field in the database for the new customer, though all the other customer data is there, there is nothing in the referral... blank, zip, nada.

It seems like the referral is not being posted to the table or its field.