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

[martyndw2005]

http://www.zen-cart.com/downloads.php?do=file&id=90

Can't get "referrals " mod working

This is the error message" 1146 TABLE '[database_zc1.TABLE_SOURCES' does not exist

The error message shows up on the page where people register and it appears under how did you hear about us this should be a drop down menu

Checked databases we have zen_sources as a table

Please help

Regards
Martyn

website : www.beeunique.co.uk

We are not using the mod at the moment as when it is implemented it stops people creating new accounts due to the error.

Please let me know if you require more information to fix this.

All the tables in the database start zen_

[martyndw2005]

As a matter of interest has anyone got this mod working on zencart 1.2.6.

I can see the mod for 1.3. I have searched through the other posts on this. If someone has the sql and the files that work with 1.2.6 please let me know. I really want to get this working and it is driving me crazy.


Regards

Martyn

[Merlinpa1969]

you need to make sure that you have the extra_datafiles installed

you need to define TABLE_SOURCES

[martyndw2005]

Hi, Thanks for your help so far.

I have the options working now ie options can be selected from the drop down menu...

I seem to have a problem the selected data in sources or data entered in other_sources does not seem to go anywhere.

Any ideas where this data is ment to go? and how admin can be altered to show per customer the referals information.


Regards

Martyn

[martyndw2005]

I don't think I made myself clear in my last message. New customers can select the options , but when the new customer has been created the customers_heard_of_us_from field in zen_customers table is not updated i have tried this a few times.

Should this information be in zen_customers or another table?

Regards

Martyn

www.beeunique.co.uk

[martyndw2005]

Can anyone who has this mod working please let me know where the source and other source data goes in the database.

Regards

Martyn

www.beeunique.co.uk

[Bryony]

Martyn,

Have you had any luck with this? I'm running 1.3.1 and thought it all installed correctly - the customers can still select where they heard of us (and I can administer the choices) but I don't get the information - on my old version of Zen it used to appear in the "Customers" section of Admin.

Anyone else?

[narsaw]

Martyn,

Have you had any luck with this? I'm running 1.3.1 and thought it all installed correctly - the customers can still select where they heard of us (and I can administer the choices) but I don't get the information - on my old version of Zen it used to appear in the "Customers" section of Admin.

Anyone else?

Same problem here. Customers can select but the information is no where to be found.

Any resoultion?

[cherylkemp]

Martyn,

Have you had any luck with this? I'm running 1.3.1 and thought it all installed correctly - the customers can still select where they heard of us (and I can administer the choices) but I don't get the information - on my old version of Zen it used to appear in the "Customers" section of Admin.

Anyone else?

I just installed this a couple of days ago and it works fine...however the logged info shows up under extras/referral sources as well as in the customer section under "referred by" not sure if that will help you at all

[narsaw]

I just installed this a couple of days ago and it works fine...however the logged info shows up under extras/referral sources as well as in the customer section under "referred by" not sure if that will help you at all

Strange, I do see a "referred by" in Admin->Customers??, what version of zen cart are you using?

Can you post the exact link where you downloaded this contrib from?