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

[DivaVocals]

Do you by any chance have other customers that signed up BEFORE you installed this mod? To try to recreate what you are seeing, I just created another account using "other" as the referral - and the one I created before this I chose google.

However, when I look at the "other" count - it is grouping ALL the customers that signed up prior to me installing this mod this morning into that category.... The "google" count is accurate. Does that make sense what I am saying?

Ahhhhh.... Yes this somewhat makes sense.. (though my previous customer count is "slightly" off by two) Dunno why I didn't think of this myself! Despite that this is somewhat inaccurate ya know??? Especially since you can drill into the the report to get the details behind "Other", you wouldn't necessarily KNOW this, nor would you want to HAVE to factor out prior everytime you ran this report.... Seems to me there should be a better way to handle existing customers.. In the meantime I will manually update the sources_other table with data to make the previous customers a tad more meaningful when drilling into the "Other" source details..

[DivaVocals]

I took a look at my customer_info table and figured out the customer count discrepancy. I updated the customer_info and sources_other tables and now the counts and reports reflect more accurate information.. (I created a generic "Other" source for all of the prior customers) I will make a note to myself that next time I use this contribution that I probably need to do it as part of a virgin install of Zen Cart so that the counts on the report are accurate from the very start..

[stellarweb]

Sounds like you have it all figured out!!

[Wadi73]

Hi, I have MySQL client version: 4.1.10 on phpMyAdmin - 2.9.0.2

I installed the sql patch for how_did_you_hear_about_us_1.3.6_beta, as I have zencart version Zen Cart 1.3.6

The error I get is below. I haven't a clue about sql, and I am not a programmer. Any way to resolve it?


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'), ', now())' at line 1
in:
[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());]

[stellarweb]

Try Changing your
'zen_cfg_select_option(array('true', 'false'), ', now()); to


'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

and see if that helps.

Hi, I have MySQL client version: 4.1.10 on phpMyAdmin - 2.9.0.2

I installed the sql patch for how_did_you_hear_about_us_1.3.6_beta, as I have zencart version Zen Cart 1.3.6

The error I get is below. I haven't a clue about sql, and I am not a programmer. Any way to resolve it?


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'), ', now())' at line 1
in:
[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());]

[Wadi73]

How do I do that?

[DivaVocals]

How do I do that?

You need to edit the contribution's SQL patch to include the suggested fix.. I am not a programmer either, but I do know from experience that if you are not familiar with your MySQL tools and/or if you do not know how to edit the SQL patch, then you will require assistance beyond the scope of this forum.. (Most of the team members assume/hope that you are at least familiar with how to use your MySQL tools)

From one newbie to another, my suggestion is that you read through this entire thread. There is a LOT of information in this thread.. (including a RECENT discussion of the very error you posted along with HOW to fix it) In general it's best to search through these forums first before posting a question. A lot of the answers are already here as others like you and me have run into similar issues.. HTH

[DivaVocals]

Sounds like you have it all figured out!!

I feel so smart now! Thanks for your help!!!

[Wadi73]

Hi DivaVocals,
Thanks for your suggestion. I did read through the thread before posting, but although I saw the suggested code replacement, it doesn't actually say where in the sql table it is needed. I can replace the code if I know exactly where it is e.g. in phpmyadmin, I am at the zencart database. I am assuming, maybe wrongly lol that the needed coding is under the table entitled "configuration", but that has loads of values.

[DivaVocals]

Hi DivaVocals,
Thanks for your suggestion. I did read through the thread before posting, but although I saw the suggested code replacement, it doesn't actually say where in the sql table it is needed. I can replace the code if I know exactly where it is e.g. in phpmyadmin, I am at the zencart database. I am assuming, maybe wrongly lol that the needed coding is under the table entitled "configuration", but that has loads of values.

You need to modify the SQL patch that is part of this contribution. (as per the suggestions in the previous posts) You can then either re-run the entire SQL patch again using the SQL patch tools or simply re-run the edited statements. Again you can use the SQL patch installer in the Zen Cart Admin or you can run these statements from your hosts SQL Admin tool. Or if you understand how to read the affected lines in the contribution SQL, you can use your MySQL tools to add the appropriate data to the configuration table..