problems installing "how did you hear about us" mo

[Dumb_Question]

I have ms2max 1.7 installed and was trying to install "how did you hear about us"

I am having problems on both admin and frontend side.

On admin side, I dont see the anything under customers except " referrals" when i update code on admin/includes/boxes/customer.php

Here is the code

<?php
/*
$Id: customers.php,v 1.16 2003/07/09 01:18:53 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2002 osCommerce

Released under the GNU General Public License
*/
?>
<!-- customers //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();

$heading[] = array('text' => BOX_HEADING_CUSTOMERS,
'link' => tep_href_link(FILENAME_CUSTOMERS, 'selected_box=customers'));

if ($selected_box == 'customers') {
$contents[] = array('text' =>
//Admin begin
// '<a href="' . tep_href_link(FILENAME_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_CUSTOMERS . '</a><br>' .
// '<a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a>');
'<a href="' . tep_href_link(FILENAME_REFERRALS, '', 'NONSSL') . '"
class="menuBoxContentLink">' . BOX_CUSTOMERS_REFERRALS . '</a>'); //rmh referrals
tep_admin_files_boxes(FILENAME_CUSTOMERS, BOX_CUSTOMERS_CUSTOMERS) .
tep_admin_files_boxes(FILENAME_ORDERS, BOX_CUSTOMERS_ORDERS) .
tep_admin_files_boxes(FILENAME_REFERRALS, BOX_CUSTOMERS_REFERRALS).
tep_admin_files_boxes(FILENAME_PAYPAL_IPN, BOX_CUSTOMERS_PAYPAL_IPN);
//Admin end
}

$box = new box;
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- customers_eof //-->

and on the frontend side I get parse error when i update the create_account .php

This is the portion of the code that causes the error parse error

<!-- //rmh referral start -->
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td class="main"><b><?php echo CATEGORY_SOURCE; ?></b></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_SOURCE; ?></td>
<td class="main"><?php echo tep_get_source_list('source', (DISPLAY_REFERRAL_OTHER == 'true' ? true : false)) . ' ' . (tep_not_null(ENTRY_SOURCE_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_TEXT . '</span>': ''); ?></td>
</tr>
<?php
if (DISPLAY_REFERRAL_OTHER == 'true') {
?>
<tr>
<td class="main"><?php echo ENTRY_SOURCE_OTHER; ?></td>
<td class="main"><?php echo tep_draw_input_field('source_other') . ' ' . (tep_not_null(ENTRY_SOURCE_OTHER_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_OTHER_TEXT . '</span>': ''); ?></td>
</tr>
<?php
}
?>
</table></td>
</tr>
</table></td>
</tr>
<!-- //rmh referral end -->.

any ideas what is going on?

Thanks

[modMan7]

Did you update the Mysql changes as well as the php side?

[Dumb_Question]

I re installed it. Now evrything looks fine on the catlog side but in admin when i click on the referrals I get this
'The requested URL ------/admin/FILENAME_REFERRALS was not found on this serve"

[Dumb_Question]

And I did check, that file is present on the server!

[michael_s]

FILENAME_REFERRALS means you have not added the define for FILENAME_REFERRALS in /admin/includes/filenames.php

[Dumb_Question]

Thanks msasek...

Now when I click on it I get this error,

1146 - Table 'database_name.TABLE_SOURCES' doesn't exist

select count(*) as total from TABLE_SOURCES

I have already uploaded the sql table

[michael_s]

Let me be more clear. Whenever you see an ALL_CAPS text like TABLE_SOURCES or FILENAME_REFERRALS it means that you have not defined it properly. You need to tell osC what exactly TABLE_SOURCES is. You need to add that define to your database_tables.php file.

Come on now, use that gray matter!

[Dumb_Question]

Thanks...msasek...that worked like charm.

You are a true savior.

[seandon01]

I installed the contribution "How did you hear about us" to my max 1.7 store. (im 99% positive i did it correctly)-

in the admin panel - customers - referrals, and reports - refferal sources i get a "Access Denied
No Right Permission Access
Please contact your Web Administrator to request
more access or if you found any problem."

Please help.. thank you in advance