Jump to content
Sign in to follow this  
MeMadMax

user_tracking' doesn't exist

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!

Share this post


Link to post
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.

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites

Just take your time ... it is not a horrible install ... just have to read the readme file slowly and take it in steps. :D

Share this post


Link to post
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!

Share this post


Link to post
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(); }

Share this post


Link to post
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!

Share this post


Link to post
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!

Share this post


Link to post
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.

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites

That code has to do with the Header Tags ... when did you load Header Tags?

Share this post


Link to post
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!

Share this post


Link to post
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;

Share this post


Link to post
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!

Share this post


Link to post
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!

Share this post


Link to post
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)

Share this post


Link to post
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!

Share this post


Link to post
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?

Share this post


Link to post
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!

Share this post


Link to post
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.

Share this post


Link to post
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!

Share this post


Link to post
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

Share this post


Link to post
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!

Share this post


Link to post
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?

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×