Forums / All Other Contributions/Addons / Were You Referred to Us is not showing in admin customers

Were You Referred to Us is not showing in admin customers

Locked

Views: 2,115

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
31 May 2008, 9:52 AM
#1
oavs avatar

oavs

Totally Zenned

Join Date:
Jan 2006
Location:
Downunder - QLD - Gold Coast
Posts:
921
Plugin Contributions:
0

Were You Referred to Us is not showing in admin customers

Hi

I have uploaded twice and still can not get the admin/customers to show any of the referrals under 'Referred By' column.

Why?

I have updated the db as per required and can see that tables are created. Can some one please help?

Thanks in advance.

CREATE TABLE zen_sources (
sources_id int NOT NULL auto_increment,
sources_name varchar(64) NOT NULL,
PRIMARY KEY (sources_id),
KEY IDX_SOURCES_NAME (sources_name)
);

and

CREATE TABLE zen_sources_other (
customers_id int NOT NULL default '0',
sources_other_name varchar(64) NOT NULL,
PRIMARY KEY (customers_id)
);

I keep getting '#1062 - Duplicate entry 'DISPLAY_REFERRAL_OTHER' for key 2 ' when I insert it phpAdmin following ;

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

This one seems to be fine -
ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;

Downunder QLD

31 May 2008, 10:15 AM
#2
oavs avatar

oavs

Totally Zenned

Join Date:
Jan 2006
Location:
Downunder - QLD - Gold Coast
Posts:
921
Plugin Contributions:
0

Re: Were You Referred to Us is not showing in admin customers

Ok it seems to be fine now. Problem was I had the other zencart referral turned on whicjh was causing the problem.

Downunder QLD