stanleymog Posted December 27, 2006 Posted December 27, 2006 Hi there, I have installed the header tags installation which Jackmc kindly contributed but have had a couple of problems, one I have overcome this evening but after nearly 3 hours of looking today and many hours before xmas I cannot find the answer to it! The problem is in admin/manufacturers.php and I get the following error: 1054 - Unknown column 'mi.manufacturers_htc_title_tag' in 'field list' select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, mi.manufacturers_htc_title_tag from manufacturers m LEFT JOIN manufacturers_info mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = '1' order by m.manufacturers_name limit 0, 20 [TEP STOP] After having a similer problem with my admin/categories.php I thought the problem would be in this bit of code: //BOC HTC $manufacturers_query_raw = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, mi.manufacturers_htc_title_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = '".$languages_id ."' order by m.manufacturers_name"; //EOC HTC But what do i alter, i do try to solve problems myself but this has got me stumped so any advice would be appreciated and i am sorry if there are any spelling mistakes, I have square eyyes!
Jack_mcs Posted December 27, 2006 Posted December 27, 2006 The error is saying that the code can't find the entry it needs in the database. If you haven't ran installed the database changes, that is the problem. If this is an upgrade from an earlier version of Header Tags, then you need to run the manufacturers update sql file. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
stanleymog Posted December 27, 2006 Author Posted December 27, 2006 The error is saying that the code can't find the entry it needs in the database. If you haven't ran installed the database changes, that is the problem. If this is an upgrade from an earlier version of Header Tags, then you need to run the manufacturers update sql file. Jack Thanks Jack, I missed one file out, now its all working fine. Thank you very much :D :thumbsup:
apurba_soft Posted April 1, 2009 Posted April 1, 2009 Manufacturers 1054 - Unknown column 'mi.manufacturers_htc_title_tag' in 'field list' select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, mi.manufacturers_htc_title_tag from manufacturers m LEFT JOIN manufacturers_info mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = '1' order by m.manufacturers_name limit 0, 2000 Please help me................
ricksteruk2005 Posted April 1, 2009 Posted April 1, 2009 again either you have not installed the mod correctly like missed out the SQL file that needs running or you are using PHP5 and require a fix on the LEFT JOIN statement I dont help with templates (thats what the seller is for) th search function will often help, when it dont try this in google. site:http://www.oscommerce.com/forums then your search word
acstudios Posted November 24, 2009 Posted November 24, 2009 I have just installed everything to spec but have the same type issues: 1. 1054 - Unknown column 'title_tag' in 'field list' select products_name, products_description, title_tag, desc_tag, keywords_tag from products_description where products_id = '167' and language_id = '1' [TEP STOP] 2. In the admin I have a similar message: 1054 - Unknown column 'pd.title_tag' in 'field list' select p.products_id, p.manufacturers_id, pd.products_name, pd.title_tag, pd.desc_tag, pd.keywords_tag, p.manufacturers_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' limit 0, 9 [TEP STOP] I saw something about uploading a sql file, but I dont see anything like that in the package. Any help would be great, thanks!
acstudios Posted November 24, 2009 Posted November 24, 2009 I wanted to add that the category meta tags work just fine in the admin and on the public site.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.