Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

User Tracking


disciple1

Recommended Posts

Hi,

 

I have searched and read numerous posts concerning the user tracking module but I didn't see anyone who had the same problem as I am having. I went through the instructions and everything seemed to go fine. When I tried to go to my admin page I got the following error:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

I was under the impression that the config file took care of specifying the database. It worked fine before the install and nothing was changed in the config file. So there must be something else I have either neglected to look at or done wrong. I went back and double and triple checked my steps according to the directions and am sure I followed the directions correctly.

 

Any help would be appreciated.

 

Thanks

 

Rick

All that is not eternal is eternally useless.

Link to comment
Share on other sites

first this post should go into one of the threads regarding this contribution in the contribution topic

 

with that said.....

 

the msg you are getting shows that you have not specified the db being used for tracking or you have overwritten the specification somewhere

 

did you install the tables into your db for user tracking?

Link to comment
Share on other sites

Sorry if this is in the wrong place. I wasn't sure whether to put it in the contribution section or not.

 

Yes, I installed the tables and when I look at the sql file I see that it is recording the visits.

 

the msg you are getting shows that you have not specified the db being used for tracking or you have overwritten the specification somewhere

 

Where is this specified? I tried to find it but could not.

 

Thanks for the help in this matter.

 

Rick

All that is not eternal is eternally useless.

Link to comment
Share on other sites

not a problem - someone will move it I'm sure 8)

 

when you installed user tracking, did you install the tables for it into your main db or did you create a new db for it?

 

if you used your main db then this is a strange one - is everything else in the admin section working correctly?

Link to comment
Share on other sites

ahhh - if you can't access any part of the admin section then you have something wrong in the config file - can you remove your user login and password and post the admin/includes/configuration.php file so we can take a look at it

Link to comment
Share on other sites

I haven't changed anything in the config file which is why I am somewhat confused. Here it is:

 

define('HTTP_SERVER', 'http://www.discipleshipresourcecenter.com'); // eg, http://localhost or - https://localhost should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://www.discipleshipresourcecenter.com');

define('HTTPS_CATALOG_SERVER', 'http://www.discipleshipresourcecenter.com');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home/virtual/site73/fst/var/www/html'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/joshua/'); // absolute path required

define('DIR_FS_ADMIN', '/home/virtual/site73/fst/var/www/html/joshua/'); // absolute pate required

define('DIR_WS_CATALOG', '/catalog/'); // absolute path required

define('DIR_FS_CATALOG', '/home/virtual/site73/fst/var/www/html/catalog/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'xxxxxxxxxxx');

define('DB_SERVER_PASSWORD', 'xxxxxxxxxxx');

define('DB_DATABASE', 'disciple_test');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

?>

All that is not eternal is eternally useless.

Link to comment
Share on other sites

the first thing I would change is

 

define('HTTP_SERVER', 'http://www.discipleshipresourcecenter.com'); // eg, http://localhost or - https://localhost should not be empty for productive servers

 

to

 

define('HTTP_SERVER', 'http://localhost'); // eg, http://localhost or - https://localhost should not be empty for productive servers

 

 

see if that one change makes a difference

Link to comment
Share on other sites

OK, I tried changing the following.

 

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

 

Instead of leaving it empty I changed it to 'mysql' I can now get to my admin functions and I see the User Tracking functions.

 

I will play around with them and let you know if there are any more problems.

 

Thanks for your help.

 

Rick

All that is not eternal is eternally useless.

Link to comment
Share on other sites

basically it is the default location and helps not to confuse things - its not that what you had was wrong, but depending on your hosting service it may or may not be wrong - localhost works 99.9% of the time

Link to comment
Share on other sites

OK New question.

 

It appears to be working but I am getting these errors.

 

Warning: Unable to access ../../catalog/includes/functions/user_tracking.php in /home/virtual/site73/fst/var/www/html/joshua/includes/footer.php on line 35

 

Fatal error: Failed opening required '../../catalog/includes/functions/user_tracking.php' (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site73/fst/var/www/html/joshua/includes/footer.php on line 35

 

 

I think this is because my admin (joshua) is not under my catalog directory. I am not sure what the required line should read.

 

Any ideas?

 

Thanks again

 

Rick

All that is not eternal is eternally useless.

Link to comment
Share on other sites

Well as I began to add some more products I did come across an error I have not been able to figure out AGAIN!! :x

 

Fatal error: Call to undefined function: tep_parse_category_path() in /home/virtual/site73/fst/var/www/html/catalog/includes/functions/user_tracking.php on line 47

 

I get this error when adding or previewing a new product.

All that is not eternal is eternally useless.

Link to comment
Share on other sites

that is defined in /includes/functions/general.php

 

make sure you havent overwritten something

 

 

////

// Parse and secure the cPath parameter values

function tep_parse_category_path($cPath) {

// make sure the category IDs are integers

$cPath_array = array_map('tep_string_to_int', explode('_', $cPath));

 

// make sure no duplicate category IDs exist which could lock the server in a loop

$tmp_array = array();

$n = sizeof($cPath_array);

for ($i=0; $i<$n; $i++) {

if (!in_array($cPath_array[$i], $tmp_array)) {

$tmp_array[] = $cPath_array[$i];

}

}

 

return $tmp_array;

}

 

////

Link to comment
Share on other sites

I thought I remembered seeing something similar in the contribution section on this and I found it.

 

I put the same thing in the catalog/includes/functions/user_tracking.php and it worked.

 

Should I change it and place the code in the general.php?

 

Thanks

 

Rick

All that is not eternal is eternally useless.

Link to comment
Share on other sites

OK, I have removed it from the user_tracking.php and found that it already was in the general.php. I am getting no errors on the admin side but when viewining my catalog I am getting this at the bottom of the page.

 

Fatal error: Cannot redeclare tep_string_to_int() in /home/virtual/site73/fst/var/www/html/catalog/includes/functions/user_tracking.php on line 62

 

I checked my Sql file and see that it is NOT recording the movement now.

 

Once again thanks in advance for you help.

 

Rick

All that is not eternal is eternally useless.

Link to comment
Share on other sites

at this point, if you have not made any changes to the code or layout, and have only installed a couple of contributions or mods I would start over again... it sounds like you have put things where they shouldnt be and so they are not getting called properly....

 

thats just what I would do :wink:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...