Porsche032 Posted March 16, 2006 Posted March 16, 2006 hey guys i just installed headertags v 2.5.6 everything seems to be working fine except when i go to Fill tags from the admin area and click on Fill all tags i get 1146 - Table 'mysite.categories_description' doesn't exist select categories_name, categories_id, categories_htc_title_tag, categories_htc_desc_tag, categories_htc_keywords_tag, language_id from categories_description where language_id = '1' [TEP STOP] please someone tell me what file i have to edit or what i have to do to fix this. Thank you Quote
Jack_mcs Posted March 16, 2006 Posted March 16, 2006 It looks like your database changes didn't all take for some reason. There is a file named Update_header_categories_description.sql in the contribution. You shouldn't have to run it on a new install but it won't hurt if you do and it may fix the problem. Jack Quote 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
Porsche032 Posted March 16, 2006 Author Posted March 16, 2006 It looks like your database changes didn't all take for some reason. There is a file named Update_header_categories_description.sql in the contribution. You shouldn't have to run it on a new install but it won't hurt if you do and it may fix the problem. Jack Hi Jack, thanks for the quick response. I ran the update_header_categories_description.sql and it said error duplicate entry. I think the problem is that my database is setup with a osc_ in front of all my tables, my host did that and it always gives me problems. So whenever i add a contribution to the database i have to add an osc_ in front of them. So my header.sql looks like this and this is how i added it into the database. ALTER TABLE osc_products_description ADD products_head_title_tag VARCHAR(80) NULL; ALTER TABLE osc_products_description ADD products_head_desc_tag LONGTEXT NULL; ALTER TABLE osc_products_description ADD products_head_keywords_tag LONGTEXT NULL; ALTER TABLE osc_categories_description ADD categories_htc_title_tag VARCHAR(80) NULL; ALTER TABLE osc_categories_description ADD categories_htc_desc_tag LONGTEXT NULL; ALTER TABLE osc_categories_description ADD categories_htc_keywords_tag LONGTEXT NULL; ALTER TABLE osc_categories_description ADD categories_htc_description LONGTEXT NULL; I think im suppose to add an osc_ in front of categories_description somewhere so it could work, but im not sure where. Do you think thats the problem? Thanks again for your help Quote
Jack_mcs Posted March 16, 2006 Posted March 16, 2006 Header Tags uses the standard tables so as liong as they are defined properly in your database_tables.php file, it should work. You should go into phpmyadmin and make sure you have the header tags fields added properly. Jack Quote 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
Porsche032 Posted March 16, 2006 Author Posted March 16, 2006 Header Tags uses the standard tables so as liong as they are defined properly in your database_tables.php file, it should work. You should go into phpmyadmin and make sure you have the header tags fields added properly. Jack i checked my db from phpmyadmin but i dont know what im suppose to be looking for. I attached a pic of my db with table osc_categories_description. can you check it please =) Thanks alot. Quote
Jack_mcs Posted March 16, 2006 Posted March 16, 2006 he database entries are correct. However, the error you first mentioned says 'mysite.categories_description' doesn't existwhich is true. Your table is osc_categories_description, not categories_description. So you should look in your includes/database_tables.php and admin/includes/database_tables.php files to be sure you have an entry like[/code]define('TABLE_CATEGORIES_DESCRIPTION', 'osc_categories_description'); Quote 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
Porsche032 Posted March 16, 2006 Author Posted March 16, 2006 he database entries are correct. However, the error you first mentioned sayswhich is true. Your table is osc_categories_description, not categories_description. So you should look in your includes/database_tables.php and admin/includes/database_tables.php files to be sure you have an entry like[/code]define('TABLE_CATEGORIES_DESCRIPTION', 'osc_categories_description'); Jack i put osc_ into includes/database_tables.php and admin/includes/database_tables.phpdefine('TABLE_CATEGORIES_DESCRIPTION', DB_TABLE_PREFIX . 'osc_categories_description'); but nothing happened, i get the same error. I also addeddefine('TABLE_CATEGORIES_DESCRIPTION', 'osc_categories_description');at the end but that didnt work either. All the other tables in there dont have the osc_ in front of them either.do you think i may have to edit a file that came with the contribution with an osc_ in front of it? Quote
Porsche032 Posted March 16, 2006 Author Posted March 16, 2006 i put osc_ into includes/database_tables.php and admin/includes/database_tables.phpdefine('TABLE_CATEGORIES_DESCRIPTION', DB_TABLE_PREFIX . 'osc_categories_description'); but nothing happened, i get the same error. I also added define('TABLE_CATEGORIES_DESCRIPTION', 'osc_categories_description'); at the end but that didnt work either. All the other tables in there dont have the osc_ in front of them either. do you think i may have to edit a file that came with the contribution with an osc_ in front of it? Ok i got it, i had to add osc_ in front of all categories_description in header_tags_fill_tags.php. Thanks Jack :D Quote
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.