How Did You Hear About Us v1.0

[mark27uk3]

Hi Guys,

 

I am trying to install the above contrib, I have done it before but for the life of me I can not remember how to fix the errors I am getting.

 

If anyone can take the time and tell me where I am going wrong I would appreciate it.

 

The error I get when creating an account is:

 

1054 - Unknown column 'customers_info_source_id' in 'field list'

 

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('6', '0', now(), '3')

 

[TEP STOP]

 

And this is the error in admin when trying to view the referral reports:

 

Referral Sources 

 

No. Sources Referred 

1054 - Unknown column 'ci.customers_info_source_id' in 'on clause'

 

select count(*) as total from customers_info ci LEFT JOIN sources s ON s.sources_id = ci.customers_info_source_id

 

[TEP STOP]

 

 

This is the info from the database:

 

customers_info_id  int(11)  No  0               

  customers_info_date_of_last_logon  datetime  Yes  NULL               

  customers_info_number_of_logons  int(5)  Yes  NULL               

  customers_info_date_account_created  datetime  Yes  NULL               

  customers_info_date_account_last_modified  datetime  Yes  NULL               

  global_product_notifications  int(1)  Yes  0               

  customers_info_source_id  int(11)  No  0 

 

Please help solve this dilemma!

 

Mark

[Guest]

Just a stab in the dark, but it looks like you are querying the wrong database :P

 

Matti

[mark27uk3]

Hi Matti,

 

Thanks for the reply. I am sure I am querying the right database.

 

This is the sql code that needs inserting, will you have a look and see if there is anything wrong with it.

 

I have dropped the tables that have been inserted in the db.

 

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, 'osCommerce');

CREATE TABLE sources_other (
 customers_id int NOT NULL,
 sources_other_name varchar(64) NOT NULL,
 PRIMARY KEY (sources_other_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', 'tep_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', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now());

 

Thanks

 

Mark