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