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

[barrys]

OK, I hope someone can help me because I screwed up and did not do a backup before uploading the files

The module seems to be working fine BUT I now cannot pull up the customer and/or order lists. I get the following error:

Fatal error: Call to undefined function: zen_get_customers_address_book() in /.../customers.php on line 1125 (address edited for security)

This is the line:
$zc_address_book_count_list = zen_get_customers_address_book($customers->fields['customers_id']);

I get a similar fatal error in orders.php on line 819

This is the line:
<td class="dataTableContent" align="center"><?php echo (zen_get_orders_comments($orders->fields['orders_id']) == '' ? '' : zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', TEXT_COMMENTS_YES, 16, 16)); ?></td>

Any suggestions as to where I go from here??

[sutikah1]

I'm getting the following error:

1065 Query was empty
in:
[]

I know this is happening because a selection other than 'Other' was chosen from the dropdown and nothing was put in the 'Other' field. What I don't know is WHY this is happening. Anyone got any ideas?

[saplanet]

Hi all,

I installed:
Zen Cart™ Version: v1.3.8
Version: 1.3.8.a
Last Updated: Dec 30 2007
Author: CnTGifts


The "how do you hear about us" does appear on the log in page. However, the information the customers posts does not appear in Admin/customers or Admin/extras/referel sources. Admin/customers shows (referered by is --none--) and
Admin/extras/referel sources shows (other............2).Once i click on it, it disappears, nothing else happens. Also, even if i state that the referrals by customers is required, customers can still carry on without entering anything.


I did the following:
1) Unpack the zip file to a temporary directory on my hard drive.
2)Changed the name of the folder "YOUR-TEMPLATE" to my own templatename. This folder is found in the includes/templates folder.
3)Upload through FTP the includes and admin folders into my web server.
4)Run install_referrals.sql in Zen cart Install SQL patch.



I can't seem to figure out why its not fully functioning even though i follow exactly the instructions. Also read all the threads in here and somehow see some similar issues faced but still not able to figure out. Really need my fellow zenners assistance.

Mine was not working, cracked my brain, killed billions of brain cells, and read through many pages in this thread, I finally got it working, so I am posting this in case anyone is in the same situation as I was.

Cart: 1.38a
Mods added:
+ how do you hear from us
+ newsletter only mod

I realized that I did everything correct while installing the referrals mod, but the records are not showing in the admin>customers>customers; nor was it showing in the extra>referral source

I noticed that the installation pack (createaccount) wasn't really pointing to the right directory since I am running a customized template (apple_zen).

In included/modules/create_account.php, it's not overriding on my custom template directory on the server.

(if you are attempting what I did, please save the original file in a temp directory, in case it doesn't work for you, you can reinstate the original file)

My newsletter only mod file is, so it's already overridden with the newsletter only file, I do not want to override the current create account file (which may means my newsletter instruction only may be lost), I opened up the original referral create_account.php file and the copy in my apple_zen directory (create_account.php) and match the 2 files.

Do take note of the 'rmh' code throughout the file, copy and paste them into the original file.

Line 78:
//rmh referral start
$source = zen_db_prepare_input($_POST['source']);
if (isset($_POST['source_other'])) $source_other = zen_db_prepare_input($_POST['source_other']);
//rmh referral end

Line 239:
//rmh referral start
if ((REFERRAL_REQUIRED == 'true') && (is_numeric($source) == false)) {
$error = true;

$messageStack->add('create_account', ENTRY_SOURCE_ERROR);
}

if ((REFERRAL_REQUIRED == 'true') && (DISPLAY_REFERRAL_OTHER == 'true') &&($source == '9999') && (!zen_not_null($source_other)) ) {
$error = true;

$messageStack->add('create_account', ENTRY_SOURCE_OTHER_ERROR);
}
//rmh referral end

Line 320:
//rmh referral start
$query_insert= "insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . (int)$_SESSION['customer_id'] . "', '0', now(), '". (int)$source . "')";

$db->Execute($query_insert);

$db->Execute($sql);
if ($source == '9999') {
zen_db_perform(TABLE_SOURCES_OTHER, array('customers_id' => $_SESSION['customer_id'], 'sources_other_name' => $source_other));
}
// $sql = "insert into " . TABLE_CUSTOMERS_INFO . "
// (customers_info_id, customers_info_number_of_logons,
// customers_info_date_account_created)
// values ('" . (int)$_SESSION['customer_id'] . "', '0', now())";
//
// $db->Execute($sql);
//rmh referral end

For line 320, take note not to have duplicate instruction, otherwise, when you try to create a dummy account, and hit submit, you will get an error message of duplicate.

Now, I created 2 dummy account, one to select a preset 'saplanet blog' selection; one to select 'other' and specified in the text box, I am now able to see the records in the admin>customers>customers>; and also in the admin>extras>referrals source.

Hope this helps.

[saplanet]

just to mention, I am not an expert, so I don't know any smarter way, this is just what works for me, hence the sharing.

[Zlink]

Hey, I was not recorded data in the bbdd and therefore in the admin. In the admin leave as all others. Someone can help me? thank you very much at all...

[donostiarra123]

Hey, I think I've done everything right, but I get all the records as "other", does not record the option chosen by the customer always comes out "other". I have checked the databases and everything is correct. Help, please! Thank you

[Johns0114]

Hi there,
My head is fried from this now.
I follow saplanets steps and uploaded. Nothing has changed so I presume it was setup the same way in the first place.

So, none of my data is appearing in the admin. Right now in admin>extras>referral sources I have 33 'other' sources. When I click into it, there is no data it simply says 'Displaying 0 to 0 (of 0 referral sources)'!! Where's my data gone?

Any advice much appreciated.

Thanks a million

[get bucked]

Have a look in "referrals" rather than "referral sources".
"referral sources" seems to be for the original zencart referral code module.

[mydanilo]

I just installed 138a-rev2 and merged the files where needed.

All fields show on the register page, drop down can be selected. Form processes.

Admin:

In admin - customers I see the column Referred By but the selection that was made at registration is not showing up. It shows just --none-- but I did select a source at registration. Seems like it did not post to the db?

Also in Referral Sources no listing of the selected source. Referral has all the pre defined sources I set up.

Does anybody have an idea where I should start to look?

[Donn]

us
+ newsletter only mod

I realized that I did everything correct while installing the referrals mod, but the records are not showing in the admin>customers>customers; nor was it showing in the extra>referral source

I noticed that the installation pack (createaccount) wasn't really pointing to the right directory since I am running a customized template (apple_zen).

In included/modules/create_account.php, it's not overriding on my custom template directory on the server.

Great advice....! The issue I was having with ZC 1.3.8A and this module was solved.


I had been saving the edited 'create_account.php' file in the default folder, and not my custom template.

BUT---when I installed the captcha module last week, I placed THAT create_account.php file in the right folder. So, while captcha worked, neither the DOB pulldown or this module worked. )Because there was a filename in the override template folder with the asme name, ZC was IGNORING the changes I was making to the file in the default directory!)

Both DISPLAYED correctly, but did not pass any values or strings (corresponding to the new mods) to ZC.

The DOB pulldown displayed, but ZC kept telling me the data was not in the right format once I'd submit.

As for the Referrals module, everything displayed Ok on the user's side also, but nothing happened changed in the database once the create_account.php form was submitted.

In the admin, there was an option tomake the Referrals mandatory...

I also had two extra options in Extras - Referrals and Referral Sources.

Referrals was changeable via the admin, but when I'd click on Referral Sources, all I'd get is:

'Other' in one column , and a count of how many times 'other' was selected.

So...the override issue solved both modules having issues.

I hope that my description of what an override issue, (the create_account.php changes not being processed) looks like for both this module, as well as the DOB pull down menu.

Many thanks--I overlooked the obvious....
Have to start with more simple solutions.....