Guest Posted September 15, 2007 Posted September 15, 2007 Ultimate SEO URLs and Header Tags. basically stock admin/categories.php with both contributions merged. I did it before, but now I can't get it to merge for the life of me on a new installation. They both work, just the admin side isn't 100% due to categories.php. Thanks to anyone who can help.
elcidd Posted September 19, 2007 Posted September 19, 2007 I hae both of these contributions on my oscommerce, but when I try to go to admin->Catalog->Catagories/Product I get the following message: 1109 - Unknown table 'd' in field list select p.products_id, pd.products_name, d.products_seo_url, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name [TEP STOP] What can be causing this? Can anyone help with this one? Thanks Lionel
Jack_mcs Posted September 19, 2007 Posted September 19, 2007 The d.products_seo_url should be pd.products_seo_url 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.