How Did You Hear About Us - Not working!

Greetings, I recently installed the How Did You Hear About Us mod, now I have an unchanged zen cart install (latest) So it was a simple matter of running the sql commands and pasting in the files and away I go right?

Wrong :( At 1st I thought it was all working due to it all appeared correctly in the front page it would show the drop down box of our selectable types and then the submit would appear to work

It would create a new entry in customers_info table but the issue is with the customers_info_source_id. its ALWAYS 0. No matter what. Now I'm a c++ coder so this whole not being able to debug drives me nuts. Is there a way to debug this?

customers_info_source_id 	
 	0

the site is https://www.cushietushies.com.au

check the login it appears to work fine, but then the reports are all "unknown" which isn't all that useful.

I'm quite desperate as time is running out till its going to be very pertinent we have this working for upcomming competitions...

thanks in advance
Chris

I have a similar issue where it always reports that "Other" was selected.

I would like to get rid of the whole thing but there were no uninstall instructions supplied with the mod.

anyone? Is the author around?

Hi there
I don't know the mod at all, however from what you say it seems that the HTML select is not assigning the proper value. There would be a table in the DB that contains the select options and their IDs. Eg 0 = Unknown. To start debugging:

1. ensure that the the selected option is actually in the page request
   place die(var_dump($customers_info_source_id)) in the appropiate place in the code to see if the value changes as different selection
2. once step one is working ensure info gets written to DB

I had the same trouble, the cause for me was that the template file
/includes/modules/my_template/create_account.php was overriding the default /includes/modules/create_account.php
so the new referral sources were not being checked or inserted into the database.

note: if this applies to you, you shouldn't just copy the /includes/modules/create_account.php to /includes/modules/my_template/create_account.php because is it is very likely the latter has changes to it. you will need to merge the changes marked rmh into the override. if you don't know how, pay your web developer to do this!

emupilot:

I had the same trouble, the cause for me was that the template file
/includes/modules/my_template/create_account.php was overriding the default /includes/modules/create_account.php
so the new referral sources were not being checked or inserted into the database.

Got it working at last. Thanks. :smile:

Steven300:

I have a similar issue where it always reports that "Other" was selected.

I've tried all sorts to fix this but I'm getting nowhere fast. I have the same bug as above.

Does anyone out there know how to fix this?

Any help is greatly appreciated.

I just attempted to install this mod, and I'm getting the following error on the sign-up page:

1146 Table 'photoedi_zen.sources' doesn't exist
in:
[select sources_id, sources_name from sources order by sources_name] (You can also see a screen shot below)

I didn't run the SQL file. Would this be what is causing the issue? How can I resolve this?

holritzphotography:

I didn't run the SQL file. Would this be what is causing the issue?

Most definitely.

Steven300:

Most definitely.

Thanks!

I'm not a programmer and I'm on a Mac. :D Is there a specific way to handle the SQL file? I've just been using an FTP program to drag and drop files to add these mods to my Zen. What do I need to do with the SQL files?

And when I run into mods that work on the same file (orders.php for example), is there a good app that will allow me to combine code?

Thanks so much!

:)

holritzphotography:

What do I need to do with the SQL files?

Copy all of the code inside the SQL file
In your admin panel, go to Tools -> Install SQL Patches
Paste the code into the big text area
Hit the Send button

holritzphotography:

And when I run into mods that work on the same file (orders.php for example), is there a good app that will allow me to combine code?

Try BBEdit.