ianric Posted December 4, 2010 Share Posted December 4, 2010 Hi This is a basic SQL problem but it's related to Header Tags 3.2.5 and it's also baffling. Everything has been installed and working for a few months but now I need to add some custom text to the products_head_keywords_tag field. I need to append the same 5 keywords to 1400 products so rather than do each individually, I went into PHPmyadmin and exported the products_description table to excel. So... my excel sheet is finished and I have a txt file with the SQL statements. It runs in PHPmyadmin with no errors, I look at the table and my new keywords are there. The problem is that my product pages don't pick up the new info. The info is there in PHPmyadmin and also in my Admin section. I've tried update products_description set products_head_keywords_tag=concat(products_head_keywords_tag,' keyword, keyword') where product_id=;etc etc and update products_description set products_head_keywords_tag=existing values for products_head_keywords_tag, keyword, keyword'; Both these work on my local test site with XAMPP but NOT on my LIVE site. The baffling thing is that if I edit and update the products in my Admin panel, without changing anything, they are then shown in the source of my product pages. Obviously, i've cleared the cache, rebooted, tried with Firefox but they are still not shown.Even more baffling is that I backed up my LIVE database, restored it locally, ran my SQL with no errors, tried a few product pages and Yippee my new keywords are there. Restored back to my LIVE site and... Nope, they're not shown. Again, they are shown in my Admin panel and in PHPmyadmin and again if I edit and update the products in my Admin panel, without changing anything, they are then shown in the source of my product pages. As a test I tried update products_description set products_description='liwurfdhwwoafhgrfdv oliergjo t543563aerdf' where product_id=;etc etc That WORKS first time, locally and live. Why is it just the header tags? Hope someone can put me out of my misery Ian Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.