MeMadMax Posted September 8, 2003 Posted September 8, 2003 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 Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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. Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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! :? Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 Just take your time ... it is not a horrible install ... just have to read the readme file slowly and take it in steps. :D Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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! :? Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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(); } Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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 Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 Hi, Thanks for your help... but it has some other problems, so I will put the backup in and start over... :wink: Thanks! Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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. Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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: Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 That code has to do with the Header Tags ... when did you load Header Tags? Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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 Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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; Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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! Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 Good Morning Linda, Thank you for your help, I did alter the table and that fixed the problem! :D Thank you again! :!: Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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) Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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 Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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? Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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? Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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. Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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. Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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 Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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? Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Ajeh Posted September 9, 2003 Posted September 9, 2003 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? Quote
MeMadMax Posted September 9, 2003 Author Posted September 9, 2003 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 Quote Jim -------------------------------------------------------------------------- How can you tell when your out of invisible ink? Of all the things I've lost, I miss my mind the most!
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.