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

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

[gogolf]

Another what will appear to be a long thread of updates from this newbie trying to figure out why the customer's referral is not appearing in the Admin/Customers or the Admin/Reports/Customers Referral Report.

I went into the database table for customers_info and looked at the field name
customers_info_source_id and saw that for the five test customers I setup each had a value of "0".

I then edited four of the five test customers to have a value other than 0, such as "1". I then went back to the admin/customers and saw that the four customers now had a referral appearing (finally) under the TABLE_HEADING_REFERRED_BY and the one customer I did not edit had "none" which appears to be what "0" will do.

When I ran the Admin/Reports/Customer's Referral the report showed nothing.
However when I explored Admin/Extra's/Referral Sources what appeared was a count of each of the referral names. So at least now I know that the database will report something on the admin side but for some reason the referral is not being posted in the database when the customer account is created.