Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

user_tracking' doesn't exist


MeMadMax

Recommended Posts

Hi,

 

I am getting an error?

 

Delete all info from IP-Address CONFIG_USER_TRACKING_EXCLUDED purge all records 



1146 - Table 'glasslin.user_tracking' doesn't exist



select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, session_id from user_tracking where time_entry > 1062978457 and time_entry < 1063064857 order by time_last_click desc



[TEP STOP]

 

ALSO... when I click on User Track Config I get the User Tracking Configuration bot there is nothing there to configure... where did I go wrong?

 

Thanks

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

Is this an old msg or a continuation of your previous error?

 

If a continuation ... there is a sql file that needs to be loaded into your MySQL database via phpMyAdmin to make the user_tracking table.

Link to comment
Share on other sites

Is this an old msg or a continuation of your previous error?

 

If a continuation ... there is a sql file that needs to be loaded into your MySQL database via phpMyAdmin to make the user_tracking table.

 

Hi,

 

Thank you, I did that... I think, I will try that again!

 

Thanks! :?

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,

 

Also... is that why I don't see anything in the Configuration window?

 

When I click on User Track Config I get the User Tracking Configuration window but there is nothing there to configure...

 

Thanks! :?

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

Click the Name User Tracking in the Left Column ... then click User Track Config underneath it ... then you should see the settings for the User Tracking configuration.

 

Also, I was not connecting to the function file in the catalog ... so in the Admin footer I used:

//  require(DIR_WS_FUNCTIONS . 'user_tracking.php');

 require(DIR_FS_CATALOG . DIR_WS_FUNCTIONS . 'user_tracking.php');

 if ( ADMIN_CONFIG_USER_TRACKING == 'true') { tep_update_user_tracking(); }

Link to comment
Share on other sites

Hi,

:?

Ok for the second time... Your SQL-query has been executed successfully

But I still get the same message from Admen.

So... rechecked the data base and I can't find any new tables... like user_tracking I would guess I am not doing something right?

 

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,

 

Thanks for your help... but it has some other problems, so I will put the backup in and start over... :wink:

 

Thanks!

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

Check and make sure that when you go to add the sql file that comes with User Tracking that you have selected the correct MySQL database to load it into ...

 

Another trick is to close all browser windows ... clear your cache then open your phpMyAdmin and now load the new sql file.

Link to comment
Share on other sites

Hi Linda,

 

I loaded the backup and that did not fix the problem, so where to look now...

 

Here is the error I get:

1054 - Unknown column 'pd.products_head_title_tag' in 'field list'



select pd.language_id, p.products_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_keywords_tag, pd.products_head_desc_tag, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_id = '29' and pd.products_id = '29' and pd.language_id ='1'



[TEP STOP]

 

Now I don't know if that was there before I started with last add-on or not... I clicked on one of the pic in the main window and that is what I received... Are we having fun now? :lol:

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,

 

Several day ago... I do have a backup befor that, but I would like to find the problem and fix it, if that can be done... :(

 

Thanks

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,

 

Several day ago... I do have a backup befor that, but I would like to find the problem and fix it, if that can be done...  :(  

 

Thanks

 

These are the sql commands for Header Tags Controller:

#

#HEADER TAGS CONTROLLER

ALTER TABLE products_description ADD products_head_title_tag varchar(64) NULL Default NULL AFTER products_viewed;

ALTER TABLE products_description ADD products_head_desc_tag BLOB NULL Default NULL AFTER products_head_title_tag;

ALTER TABLE products_description ADD products_head_keywords_tag BLOB NULL Default NULL AFTER products_head_desc_tag;

Link to comment
Share on other sites

Hi,

 

Well, I have to call it a night, time to put the twins to bed :roll:

 

But, do you know what file is called... I think the problem is in one of the files I changed for the "header tag" ?

 

Thanks!

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

Good Morning Linda,

 

Thank you for your help, I did alter the table and that fixed the problem!

:D

Thank you again!

:!:

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

Good Morning Linda,

 

Thank you for your help, I did alter the table and that fixed the problem!

:D

Thank you again!

:!:

 

Sure thing ... :D

 

When you see errors like that, look to see what field is missing from what table and then try to determin what add-on might have had that field in it.

 

That one was easier to spot as I wrote that. 8)

Link to comment
Share on other sites

Hi Linda,

 

Yes, it was late and I was not see much... thanks!

 

One more question:

In Admin, under Categories / Products, the Products Image, all Images have disappeared. But they are working fine every else? anyone have a clue why?

 

Thanks

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, it was late and I was not see much... thanks!

 

One more question:

In Admin, under Categories / Products, the Products Image, all Images have disappeared. But they are working fine every else? anyone have a clue why?

 

Thanks

 

Did you turn on the Limited Products Display and have Images setup not to show when turned on?

Link to comment
Share on other sites

Linds, not that I know of... "Limited Products Display" where is that located?

 

Did you turn on the Limited Products Display and have Images setup not to show when turned on?

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

Linds, not that I know of... "Limited Products Display" where is that located?

 

 

Did you turn on the Limited Products Display and have Images setup not to show when turned on?

 

Under the Configuration in Limited Products Display.

 

You can configue various fields not to display when it is turned on.

Link to comment
Share on other sites

Under the Configuration in Limited Products Display.

 

You can configue various fields not to display when it is turned on.

 

Linda, Then something is missing from my Admen menu... I can not find "Limited Products Display" anywhere in any of the Categories.

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

 

Under the Configuration in Limited Products Display.

 

You can configue various fields not to display when it is turned on.

 

Linda, Then something is missing from my Admen menu... I can not find "Limited Products Display" anywhere in any of the Categories.

 

Look in your left column ... click on Configuration ... the 3rd link from the bottom reads:

 

Limited Product Display

 

There is a setting on there for:

 

Limit Products Page Information - Current Status

 

See if that is set to True or False

Link to comment
Share on other sites

Look in your left column ... click on Configuration ... the 3rd link from the bottom reads:

 

Limited Product Display

 

There is a setting on there for:

 

Limit Products Page Information - Current Status

 

See if that is set to True or False

 

Not there... not anywhere, looks like the Cat In The Hat is at it again!

 

Where in the code can I find it... it is not on the menu?

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

Okay ... let's try this ...

 

When you say all images have disappeared ... do you mean when editing you have no place to add images ... or when clicked on a product, the image does not show on the right side?

Link to comment
Share on other sites

Okay ... let's try this ...

 

When you say all images have disappeared ... do you mean when editing you have no place to add images ... or when clicked on a product, the image does not show on the right side?

 

No images on right side, no flags for the country, but I do have button icons.

Why can I not find the Limited Products Display

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...