Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

user_tracking' doesn't exist


MeMadMax

Recommended Posts

No images is usually a configure.php error.

 

Check if you are defining your root or using the script:

  define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

 

I use:

  define('DIR_FS_DOCUMENT_ROOT', '/home2/webmakr2/public_html'); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)

 

As to missing things ... when you installed everything ... what all did you use?

 

Limited Products Display is only available in SEC. You can look at your categories.php and see if you see any IF statements with LPD_ in the code.

Link to comment
Share on other sites

No I could not find LPD_ in the cod.

 

And define('DIR_FS_DOCUMENT_ROOT' is set:

 

define('DIR_FS_DOCUMENT_ROOT', '/home/glasslin/public_html/catalog/');

 

OK?

Jim

--------------------------------------------------------------------------

How can you tell when your out of invisible ink?

 

Of all the things I've lost, I miss my mind the most!

Link to comment
Share on other sites

Try using instead:

 

define('DIR_FS_DOCUMENT_ROOT', '/home/glasslin/public_html');

 

Strange... nothing changed, I removed the "catalog/" and it was still the same.

Jim

--------------------------------------------------------------------------

How can you tell when your out of invisible ink?

 

Of all the things I've lost, I miss my mind the most!

Link to comment
Share on other sites

Try using instead:

 

define('DIR_FS_DOCUMENT_ROOT', '/home/glasslin/public_html');

 

Strange... nothing changed, I removed the "catalog/" and it was still the same.

 

Click right on the area where the image should be ... I am assuming you have a broken picture there ... what is the path to the image?

Link to comment
Share on other sites

Click right on the area where the image should be ... I am assuming you have a broken picture there ... what is the path to the image?

 

/images/y_hi_31.gif

 

This is with catalog/ removed from the line of code

 

/images/y_hi_31.gif

same thing with catalog/ in the line of code

Now that is strange.... the file is: catalog/inculdes/configure.php.

 

That line is not in admin/inculdes/configure.php

Jim

--------------------------------------------------------------------------

How can you tell when your out of invisible ink?

 

Of all the things I've lost, I miss my mind the most!

Link to comment
Share on other sites

Thanks Linda!

 

I have it all working again, but there is a bug in something that I added. If I set the address to //www.dot.net then it works fine, if I change it to //www.dot.net/catalog then it can not find the the product photo or country flags, all other buttons and icons were ok (in admin) (this problem was not there on the original install) somewhere along the way something was changed that caused this

 

I changed the root so when "top" was clicked it would take you back to catalog/index.php

 

Here are the config (only part of the file) that work for me... admin/includes/configure.php

  define('HTTP_SERVER', 'http://www.dot.net'); // eg, http://localhost - should not be empty for productive servers

 define('HTTP_CATALOG_SERVER', 'http://www.dot.net');

 define('HTTPS_CATALOG_SERVER', 'https://www32.dot.com/~glasslin');

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

 define('DIR_FS_DOCUMENT_ROOT', '/home/glasslin/public_html/catalog/'); // where the pages are located on the server

 define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required

 define('DIR_FS_ADMIN', '/home/glasslin/public_html/catalog/admin/'); // absolute pate required

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

 define('DIR_FS_CATALOG', '/home/glasslin/public_html/catalog/'); // absolute path required

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

 define('DIR_WS_FLAGS', DIR_WS_IMAGES . 'flags/');

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

 

I will keep working on to find the bug I added somewhere along the line of code hacking...

 

Thanks for all your help!

Jim

Jim

--------------------------------------------------------------------------

How can you tell when your out of invisible ink?

 

Of all the things I've lost, I miss my mind the most!

Link to comment
Share on other sites

Hi Linda,

 

Yes and no... I fixed the problem I had, but I added a new product and it came back with this error:

 

1064 - You have an error in your SQL syntax near '02')' at line 1



insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '1b2cf447a16f10e32cf3afa1adaa9aea', '64.164.169.77', '1063384599', '1063384599', '/catalog/admin/categories.php?cPath=22_23', 'Marbles '02')

 

Bummer... can you help?

 

Jim

Jim

--------------------------------------------------------------------------

How can you tell when your out of invisible ink?

 

Of all the things I've lost, I miss my mind the most!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...