Guest Posted January 24, 2016 Share Posted January 24, 2016 Hi I recently installed the above addon. However when I click on manufacturers in the web site I get this 1054 - Unknown column 'manufacturers_seo_description' in 'field list' select manufacturers_seo_description, manufacturers_seo_keywords from manufacturers_info where manufacturers_id = '35' and languages_id = '1' [TEP STOP] I have already inserted into DB the following. ALTER TABLE `reviews`ADD `is_testimonial` TINYINT( 1 ) NOT NULL DEFAULT '0'; ALTER TABLE `products_description`ADD `products_seo_title` VARCHAR( 128 ) NULL,ADD `products_seo_description` TEXT NULL,ADD `products_seo_keywords` VARCHAR( 128 ) NULL,ADD `products_mini_description` TEXT NULL; ALTER TABLE `categories_description`ADD `categories_description` TEXT NULL,ADD `categories_seo_title` VARCHAR( 128 ) NULL,ADD `categories_seo_description` TEXT NULL,ADD `categories_seo_keywords` VARCHAR( 128 ) NULL; ALTER TABLE `manufacturers`ADD `manufacturers_seo_title` VARCHAR( 128 ) NULL; ALTER TABLE `manufacturers_info`ADD `manufacturers_description` TEXT NULL,ADD `manufacturers_seo_description` TEXT NULL,ADD `manufacturers_seo_keywords` VARCHAR( 128 ) NULL; And to check I tried inserting again, and got the following message; SQL query: ALTER TABLE `products_description` ADD `products_seo_title` VARCHAR( 128 ) NULL ,ADD `products_seo_description` TEXT NULL ,ADD `products_seo_keywords` VARCHAR( 128 ) NULL ,ADD `products_mini_description` TEXT NULL ; MySQL said: Documentation#1060 - Duplicate column name 'products_seo_title' If I turn of Module>Header Tags>Manufacturer Meta the problem dissapears. What should I do to fix this prob. Im sure Ive installed correctly. Many thanks Grandpa Quote Link to comment Share on other sites More sharing options...
♥Dan Cole Posted January 25, 2016 Share Posted January 25, 2016 @@grandpaj John did you try turning on the module after running the query a second time....the error messages you posted seem to relate to the product_seo stuff and not the manufacturers_seo components....I'm wondering if it fixed it but you just don't realize it. Dan Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2016 Share Posted January 25, 2016 @@Dan Cole Hi Dan Thanks for your thoughts, tried as suggested but made no difference. Just wondering if I managed to somehow, somewhere, stuff up a .php file if that would create the above problem. The other thing is, how would I find and delete the above SQL, then try reinstallin again. Cheers Grandpa. Quote Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2016 Share Posted January 25, 2016 @@Dan Cole Hi Dan Don't ask me how, but I took a look at application top.php changed to an "old version" then reinstalled Manufacturers Meta then changed the application top.php back, now all seems to work. Lets hope its all good. Many thanks for your help. Grandpa Quote Link to comment Share on other sites More sharing options...
♥Dan Cole Posted January 25, 2016 Share Posted January 25, 2016 @@grandpaj John I won't pretend to understand any of that but I'm glad you got it working. :thumbsup: Dan Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
SpicyGirl Posted March 24, 2016 Share Posted March 24, 2016 I tried to install it but have already an error in the sql upload!! SQL-query: ALTER TABLE `categories_description`ADD `categories_description` TEXT NULL,ADD `categories_seo_title` VARCHAR( 128 ) NULL,ADD `categories_seo_description` TEXT NULL,ADD `categories_seo_keywords` VARCHAR( 128 ) NULL; MySQL meldt: #1060 - Duplicate column name 'categories_description' Installed a virgin osc234bs edge, nothing else & tried to made the sql changes. SQL-query: ALTER TABLE `categories_description`ADD `categories_description` TEXT NULL,ADD `categories_seo_title` VARCHAR( 128 ) NULL,ADD `categories_seo_description` TEXT NULL,ADD `categories_seo_keywords` VARCHAR( 128 ) NULL; MySQL message: #1060 - Duplicate column name 'categories_description' I'm running php 5.4.45 Quote Link to comment Share on other sites More sharing options...
♥Dan Cole Posted March 24, 2016 Share Posted March 24, 2016 Sounds like you already have the column 'categories_description' in your database....have a look at the table to see if you also have the other columns...if not you could change the sql query to. ALTER TABLE `categories_description`ADD `categories_seo_title` VARCHAR( 128 ) NULL,ADD `categories_seo_description` TEXT NULL,ADD `categories_seo_keywords` VARCHAR( 128 ) NULL; That should add the additional columns for you. Dan Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
burt Posted March 25, 2016 Share Posted March 25, 2016 I tried to install it but have already an error in the sql upload!! Edge contains code that makes addons incompatible. In any case, most of this addon is built into Edge, with the rest going in over the weekend. ArtcoInc and Tsimi 2 Quote Link to comment Share on other sites More sharing options...
SpicyGirl Posted March 26, 2016 Share Posted March 26, 2016 Edge contains code that makes addons incompatible. In any case, most of this addon is built into Edge, with the rest going in over the weekend. Well, good sake, did'n know EDGE makes addons incompatible!! How I did it as a newbie to integrate 27 addons in EDGE? All working properly (finally). Not easy as some addons prevent other addons to works properly or to get integrated. From A 2 Z the shop is working fine & smoot on small & xtra small devices. Looks professionally, the greatest innovation is that there no need to setup a mobile version of your shop. Now have to finish the layout Great work @@burt & Co I thank you all to made this possible & to them that have spend time to support me saludos Quote Link to comment Share on other sites More sharing options...
SpicyGirl Posted March 26, 2016 Share Posted March 26, 2016 Sounds like you already have the column 'categories_description' in your database....have a look at the table to see if you also have the other columns...if not you could change the sql query to. ALTER TABLE `categories_description` ADD `categories_seo_title` VARCHAR( 128 ) NULL, ADD `categories_seo_description` TEXT NULL, ADD `categories_seo_keywords` VARCHAR( 128 ) NULL; That should add the additional columns for you. Dan Hola @@Dan Cole seems me logic there categories & categories description. In every shop you will find that. I deleted that line, got other errors into the shop. I decide to quit & leave this addon. When It goes wrong with the first thing you have to do to integrate an addon & you dont get support, then it's over & out nice weekend Quote Link to comment Share on other sites More sharing options...
Omar_one Posted April 13, 2016 Share Posted April 13, 2016 Hello, When i create new product, there is filed ( Product Mini Description:Used in the "product list" in Category Pages.) is it mean that Product Mini Description will show in the products_listing? if it is, will show it in grid view also? thanks BR Omar Quote Get the latest Responsive osCommerce CE (community edition) here . Link to comment Share on other sites More sharing options...
burt Posted April 13, 2016 Share Posted April 13, 2016 This is post #5 in this thread: http://www.oscommerce.com/forums/topic/394978-seo-header-tags-reloaded-support/?p=1685206 Quote Link to comment Share on other sites More sharing options...
valquiria23 Posted May 20, 2016 Share Posted May 20, 2016 Dear @@burt Comparing the files that are included in the zip SEO Header Tags - Reloaded - 2016 04 07 and the last version of EDGE (Responsive-osCommerce-master) downloaded from : https://github.com/gburton/osCommerce-234-bootstrap/archive/master.zip I found that some files are missing, like: catalog\includes\modules\header_tags\ht_category_meta.php catalog\includes\modules\header_tags\ht_manufacturer_meta.php catalog\includes\modules\header_tags\ht_pages_meta.php that's okay ? Best regards Valqui Quote Community Oscommerce fan You'll find the latest osC community version here. Link to comment Share on other sites More sharing options...
Lary_an Posted May 23, 2016 Share Posted May 23, 2016 Hi, I have duplicate meta tags title and description on my index page. I can eliminate duplication by changing the code in the ....includes/modules/header_tags/ht_pages_title.php if ( (defined('META_SEO_TITLE')) && (strlen(META_SEO_TITLE) > 0) ) { $oscTemplate->setTitle(tep_output_string(META_SEO_TITLE) . ', ' . $oscTemplate->getTitle()); to if ( (defined('META_SEO_TITLE')) && (strlen(META_SEO_TITLE) > 0) ) { $oscTemplate->setTitle($oscTemplate->getTitle()); but i don't know if i would be doing the right thing, also it wouldn't solve my duplicate description problem. My version is 2.3.4.BS and i have SEO URL5 installed Please help!!!! Thanks. Quote Link to comment Share on other sites More sharing options...
burt Posted May 23, 2016 Share Posted May 23, 2016 that's okay ? Yes. Quote Link to comment Share on other sites More sharing options...
burt Posted May 23, 2016 Share Posted May 23, 2016 (edited) @@Lary_an So far as I recall, getTitle outputs the name of the shop, nothing more. So, you may have made changes to this. Do you know? Anyway, update to Edge version of this, as it is more tested. Edited May 23, 2016 by burt Quote Link to comment Share on other sites More sharing options...
Lary_an Posted May 23, 2016 Share Posted May 23, 2016 @@burt Thank you for quick reply. We started the upgrade to our shop on 02/09/16 with download of https://github.com/gburton/osCommerce-234-bootstrap/archive/master.zip (still confused if it was gold or edge - we took the version recommended in the forums) and there are a lot of addons already installed, so if we start another upgrade we have to start from scratch again. As far as i can tell we have not made any changes to getTitle - i don't know where getTitle is located, so can't be sure. Also how do i get rid of duplicate meta description in my index file? it look like this: <meta name="description" content="mysite.com my text description." /><meta name="description" content="mysite.com my text description." /> Thank you very much for your help. Quote Link to comment Share on other sites More sharing options...
burt Posted May 24, 2016 Share Posted May 24, 2016 No one has any real clue as to what you've done, so you'd need to work back through your changes until you find it corrects itself. Quote Link to comment Share on other sites More sharing options...
wild.lucifero Posted May 24, 2016 Share Posted May 24, 2016 Hello, I need help to understand how I have to fill the SEO Header Tags fields: "Products Title for SEO" : I usually leave it blank because it is the same of the "Product Name" "Product Mini Description": I usally write a (mini) description about the product; in same case it is the same of the "Product Name". "Product Meta Description for SEO": I usually write a description about the product, in same case it is the same of the "Product Description". "Product Meta Keywords for SEO": I usually write the keywords for SEO, but some Keys are not comma separated. For ex. I write "Engine mount" and NOT "Engine, mount". I never write any meta in all SEO's fields. Is everything right? For example: Product Name: ABS 64dp spur gear "Products Title for SEO" : "Product Mini Description": ABS 64dp spur gear. "Product Meta Description for SEO": 64dp spur gear made in ABS "Product Meta Keywords for SEO": 64dp, ABS spur gear, "trademark of the spur gear", "item code of the spur gear" Really many thanks in advanced. Ciao Quote Link to comment Share on other sites More sharing options...
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.