Tracking Tool Problem

[crichw]

I install the customer tracking tool yesterday and I thought that it was working correctly but when I looked this morning I noticed that it says 0 hits, which I know to be incorrect because I had almost 100 hits on a search engine.

I get tracking results from admin clicks, just not getting customer hits. Not sure if I did this correctly??

tpl_footer.php:

<div id="siteinfoIP"><?php echo TEXT_YOUR_IP_ADDRESS . ' ' . $_SERVER['REMOTE_ADDR']; ?></div>
<?php
}
?>
<!--eof-ip address display -->
<!--bof-banner #5 display -->
<?php
if (SHOW_BANNERS_GROUP_SET5 != '' && $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SET5)) {
if ($banner->RecordCount() > 0) {
?>
<div id="bannerFive" class="banners"><?php echo zen_display_banner('static', $banner); ?></div>
<?php
}
}
?>
<!--eof-banner #5 display -->
<!--bof- site copyright display -->
<div id="siteinfoLegal" class="legalCopyright"><?php echo FOOTER_TEXT_BODY; ?></div>
<p align="center"><script language="Javascript"
<!--eof- site copyright display -->
?
<?php
} // flag_disable_footer
><?php if (ZEN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?>

Footer.php:

// check and display zen cart version and history version in footer
$current_sinfo = PROJECT_VERSION_NAME . ' v' . PROJECT_VERSION_MAJOR . '.' . PROJECT_VERSION_MINOR . '/';
$check_hist_query = "SELECT * from " . TABLE_PROJECT_VERSION . " WHERE project_version_key = 'Zen-Cart Database' ORDER BY project_version_date_applied DESC LIMIT 1";
$check_hist_details = $db->Execute($check_hist_query);
if (!$check_hist_details->EOF) {
$current_sinfo .= 'v' . $check_hist_details->fields['project_version_major'] . '.' . $check_hist_details->fields['project_version_minor'];
if (zen_not_null($check_hist_details->fields['project_version_patch'])) $sinfo .= '&nbsp;&nbsp;Patch: ' . $check_hist_details->fields['project_version_patch'];
if (zen_not_null($check_hist_details->fields['project_version_date_applied'])) $sinfo .= ' &nbsp;&nbsp;[' . $check_hist_details->fields['project_version_date_applied'] . '] ';
if (zen_not_null($check_hist_details->fields['project_version_comment'])) $sinfo .= ' &nbsp;&nbsp;(' . $check_hist_details->fields['project_version_comment'] . ')';
}
?>
<table border="0" width="100%" cellspacing="10" cellpadding="10">
<tr>
<td align="center" class="smallText" height="100" valign="bottom"><a href="" target="_blank"><img src="images/small_zen_logo.gif" alt="Zen Cart:: the art of e-commerce" border="0"></a><br /><br />E-Commerce Engine Copyright &copy; 2003-<?php echo date('Y'); ?> <a href="" target="_blank">Zen Cart&trade;</a><br /><?php echo '<a href="' . zen_href_link(FILENAME_SERVER_INFO) . '">' . $current_sinfo . '</a>'; ?></td>
</tr>
</table><?php if (ADMIN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?>

[TShooters]

Did you run the sql patch that came with it?

[crichw]

Yes i ran the sql patch also.

[crichw]

Should I reinstall the sql file again? Not sure why this is not working.

[TShooters]

I would, and thru phpMyAdmin. This is User Tracking, correct? As I recall,
I did this after it didn't work for me the first time after running the sql via Admin.
Good idea to backup your DB first.

[crichw]

Could I use filezilla to upload the file not sure how to use phpmyadmin?

Where would the file get uploaded to?

Thanks

[TShooters]

The sql patch creates a table in your database. So, no...it can't be uploaded
via FTP. You would need to access your cpanel, go to MySQL, and (on mine)
entry to phpMyAdmin is at the bottom of the MySQL page.

How did you run the sql patch before? Thru Zen Cart's Admin? We are talking
the User Tracking contribution?