How Did You Hear About Us? mod

I see there is a giant, long thread about this mod with something like 28 pages of replies. I did read them. Still can't solve the problem so whether it is correct protocol or not I am starting a new thread about my problem. :)
I installed the mod "How Did You Hear About Us" from http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=186
No problems with install, no problems with getting it to show when customer creates an acct. Everything seems to be there and working fine. The issue is that the collected referral sources are not showing anywhere. Not on the admin>customer> CUSTOMER and not in Extra>Referral Sources.
Anyone have a solution to this? As far as I can tell I installed all the files correctly. The site is hoopclothes dot com, 1.3.9d.

Thanks for your help!

Yes, you should upgrade to 1.3.9h -there are many fixes that might help.:yes:

Yes, you should have posted in the mod's thread as the folks that developed/use it monitor the thread and can be of better help.:P

Yes, you should check the cache directory in the cart's root to see if there are any debug files that might give you a clue.:yes:

Thank you for your assistance Mr. dbltoe.
However, this does not solve my problem. I appreciate that upgrading a couple letters might solve a problem here or there, but for right now I would really rather just get the module working with 1.3.9d. I have heard this upgrade and it'll fix everything a few times in the past. Yet every problem I have ever had was solved without upgrading and instead with simple edits to the files.

I know I am not the only on with problems getting this mod to work. Does anyone have a solution that worked for them? Please? I did not post in the 28 page long thread as it was several years old and I was hoping that some new info. had come to light since that time. I have not found anything in the debug/cache files that gives me a clue.

The mod appears to be working as I said before. The how did you hear about us shows up in create acct., but the data is going no where. Everytime I create a new account I get another tick on Referral Sources>other no matter what I choose. When I double click other there are no other sources listed. Go figure?

Anyone RECENTLY get this mod to work? Thanks in advance!

And apparently from time to time, we type on the keyboard just to wear out the bumps on the F and J keys.:no:

There are safety and operational updates in the latest upgrades. If you are not concerned with safety....

You still have apparently not looked in the cache folder for a DEBUG file or you are keeping the results of your visit a secret.

Someone in the actual thread might have an answer or pertinent question like, "how did you install the .sql file?" The thread is for answers by those familiar with the mod.

Someone not familiar with the mod should not be expected to learn it to help you without being compensated for their time. Everyone here is a volunteer and monitor the areas in which they are willing and able to help. Posting elsewhere is like asking the plumber to fix your ceiling fan. Heaven forbid it runs backwards after the fix.:P

Ok dbltoe. I do tend to go through keyboards. ha! I will move my question to the old mod thread. Sorry to be a nuisance.

Of course I am concerned with security. I have fear of upgrading. I am nearly sure I would mess something else up doing that since as you can tell I know not a lot about what I am doing. And that those newly messed up things would take a lot longer than fixing the problem with this mod.

I don't know where to look for the debug file. I looked in the Cache file and there are a few files - myDEBUG-####s.log newest one is 5/11 which was before I installed this mod. There are also some files that start with zc_#####.sql
And I installed the sql through the Tools>install SQL patches and uploading the file.

Thank you for your assistance!

:shocking: There should be no .sql files in the cache directory.

Post the contents of the debug file here.

Ok. FYI I installed this mod on 5/20/11
DEBUG:
[23-Apr-2011 20:29:34] PHP Warning: filemtime() [<a href='function.filemtime'>function.filemtime</a>]: stat failed for /home2/hoopclot/public_html/cache/zc_3d63152cab3e001e45db0f8214ae796d.sql in /home2/hoopclot/public_html/includes/classes/cache.php on line 59
AND
[11-May-2011 06:56:47] PHP Warning: filemtime() [<a href='function.filemtime'>function.filemtime</a>]: stat failed for /home2/hoopclot/public_html/cache/zc_9b41e5ce79b3ea0cb51c3c6e45a797e8.sql in /home2/hoopclot/public_html/includes/classes/cache.php on line 59

Also those .sql files are both dated today ( I sure didn't put them there) and consist of long, long lines of things like this:
a:635:{i:0;a:2:{s:6:"cfgkey";s:10:"STORE_NAME";s:8:"cfgvalue";s:11:"Hoopclothes";}i:1;a:2:{s:6:"cfgkey";s:11:"STORE_OWNER";s:8:"cfgvalue";s:0:"";}i:2;a:2:{s:6:"cfgkey";s:13:"STORE_COUNTRY";s:8:"cfgvalue";s:3:"223";}i:3;a:2:{s:6:"cfgkey";s:10:"STORE_ZONE";s:8:"cfgvalue";s:2:"49";}i:4;a:2:{s:6:"cfgkey";s:22:"EXPECTED_PRODUCTS_SORT";s:8:"cfgvalue";s:4:"desc";}i:5;a:2:{s:6:"cfgkey";s:23:"EXPECTED_PRODUCTS_FIELD";s:8:"cfgvalue";s:13:"date_expected";}i:6;a:2:{s:6:"cfgkey";s:29:"USE_DEFAULT_LANGUAGE_CURRENCY";s:8:"cfgvalue";s:5:"false";}i:7;a:2:{s:6:"cfgkey";s:25:"LANGUAGE_DEFAULT_SELECTOR";s:8:"cfgvalue";s:7:"Default";}i:8;a:2:{s:6:"cfgkey";s:27:"SEARCH_ENGINE_FRIENDLY_URLS";s:8:"cfgvalue";s:5:"false";}i:9;a:2:{s:6:"cfgkey";s:12:"DISPLAY_CART";s:8:"cfgvalue";s:4:"true";}i:10;a:2:{s:6:"cfgkey";s:32:"ADVANCED_SEARCH_DEFAULT_OPERATOR";s:8:"cfgvalue";s:3:"and";}i:11;a:2:{s:6:"cfgkey";s:18:"STORE_NAME_ADDRESS";s:8:"cfgvalue";s:0:"";}i:12;a:2:{s:6:"cfgkey";s:11:"SHOW_COUNTS";s:8:"cfgvalue";s:4:"true";}i:13;a:2:{s:6:"cfgkey";s:18:"TAX_DECIMAL_PLACES";s:8:"cfgvalue";s:1:"0";}i:14;a:2:{s:6:"cfgkey";s:22:"DISPLAY_PRICE_WITH_TAX";s:8:"cfgvalue";s:5:"false";}i:15;a:2:{s:6:"cfgkey";s:28:"DISPLAY_PRICE_WITH_TAX_ADMIN";s:8:"cfgvalue";s:5:"false";}i:16;a:2:{s:6:"cfgkey";s:23:"STORE_PRODUCT_TAX_BASIS";s:8:"cfgvalue";s:8:"Shipping";}i:17;a:2:{s:6:"cfgkey";s:24:"STORE_SHIPPING_TAX_BASIS";s:8:"cfgvalue";s:8:"Shipping";}i:18;a:2:{s:6:"cfgkey";s:24:"STORE_TAX_DISPLAY_STATUS";s:8:"cfgvalue";s:1:"0";}i:19;a:2:{s:6:"cfgkey";s:23:"SHOW_SPLIT_TAX_CHECKOUT";s:8:"cfgvalue";s:5:"false";}i:20;a:2:{s:6:"cfgkey";s:21:"SESSION_TIMEOUT_ADMIN";s:8:"cfgvalue";s:4:"3600";}i:21;a:2:{s:6:"cfgkey";s:21:"GLOBAL_SET_TIME_LIMIT";s:8:"cfgvalue";s:2:"60";}i:22;a:2:{s:6:"cfgkey";s:29:"SHOW_VERSION_UPDATE_IN_HEADER";s:8:"cfgvalue";s:4:"true";}i:23;a:2:{s:6:"cfgkey";s:12:"STORE_STATUS";s:8:"cfgvalue";s:1:"0";}i:24;a:2:{s:6:"cfgkey";s:21:"DISPLAY_SERVER_UPTIME";s:8:"cfgvalue";s:4:"true";}i:25;a:

etc...

I came across this reply to a thread. Could this account for the sql files in your cache folder?

https://www.zen-cart.com/forum/showpost.php?p=858758&postcount=3

Yes, actually that could account for the sql files. I changed the configure files a while ago battling another issue. Since there aren't any .sql files older than today I guess its ok to leave them there.

I've got this installed on a few sites and I just installed it on an unmodified store with a straight upload. It works as it should, no problems. Perhaps your problem results from merging the files?

Hello - I am still trying to get this mod to work. I went through all the files and tried to find any issues with merging them. Didn't find any, doesn't mean the issue isn't there, just means I didn't see anything jump out at me. Quadruple checked that all the files were in the correct places AND successfully upgraded from to 1.3.9h. Still no dice.
Anyone?

Still can't get this mod working, but I had a random thought so figured I'd ask another question about it...
When you go to My Store>Configuration>Customer Details there is a setting for customer referral status. Mine is currently set to 0 (off). Should this be set to something else for this mod to function?

FYI I do have the Customer Details>Require Referral set to true right now.

so this mod still isn't working. My latest theory is that because I already have so many customers in the database with no referral source that the mod report is getting hung up and can't
generate its set since each customer doesn't have an answer. I am thinking the report needs to be rewritten to allow those customer blanks to be used by going into the database and manually fixing those blanks.
Does this sound at all logical? grasping at straws...

Well, I'm glad that I'm not the only one having these problems. It still stinks because its still not working.

This mod is something that should be in the base system. Its REALLY important to have this to know where your advertising dollars are being spent well.

I really hope that this is fixed!

Require Referral is set to true in my admin, however it still isn't actually required...I'm at a loss as to what's wrong. Everything else about this mod is working properly. We DO need this field to be required...

yeah!:

I see there is a giant, long thread about this mod with something like 28 pages of replies.

Where the heck is it?!?!?
I still can't get this to work and would love to find the support thread.