Error 1054 Oscommerce
1 more downloads) If you get this message it is probably due to your server upgrading to php5 or MySQL5. You get the message when you try a search on your site. The new OSC from around Sept-Oct 2006 or so, doesn't have this problem. You just need to change one section in index.php and one in advance search_result.php. Very simple Good Luck! Ozstar Legend: DownloadReport Expand All / Collapse All How to Fix the 1054 error in any file ACE99 9 Sep 2008 The following file is a "how to" guide on fixing the 1054 error in any file in your store. Some heavily modified stores will require that you fix the code by hand in index.php. In addition, you may have additional files that need to be fixed if you have contribs installed such as Article Manager, Price Breaks contrib, SEO URLs and more. This file does not show where to fix all the problems in each file, rather is teaches you how to fix the problem (which is very simple) and then guides you where you should look to fix your store. Error Message - 1054 - Unknown column 'p.products_id' in 'on clause' ozstar 11 Nov 2006 If you get this message it is probably due to your server upgrading to php5 or MySQL5. You get the message when you try a search on your site. The new OSC from around Sept-Oct 2006 or so, doesn't have this problem. You just need to change one section in index.php and one in advance search_result.php. Very simple Good Luck! Ozstar Copyright © 2000-2016 osCommerce. All rights reserved.Webmaster: Harald Ponce de Leon (Impressum)
- Unknown column 'p.newsdesk_id' in 'on clause' Article After upgrading MySQL version customers may see something like following error: 1054 - Unknown column 'p.newsdesk_id' in 'on clause' select count(p.newsdesk_id) as total from newsdesk_description pd, newsdesk p left join manufacturers m on p.newsdesk_id = m.manufacturers_id, newsdesk_to_categories p2c left join specials s on p.newsdesk_id = s.products_id where p.newsdesk_status = '1' and p.newsdesk_id = p2c.newsdesk_id and pd.newsdesk_id = p2c.newsdesk_id and pd.language_id = '4' and p2c.categories_id = '18' Solution from OS Commerce More general discussion of the problem Rate This Article How useful was this article? Recently Updated Articles How to add a Facebook Like or Recommend button in CloudSiteHow to add a Facebook Like or Recommend http://addons.oscommerce.com/info/4654 button in CloudSiteHow to add a gallery in CloudSiteHow to add a gallery in CloudSiteHow to add a Heading or H1 tag in CloudSiteHow to add a Heading or H1 tag in CloudSite Free Online Business Training Get more out of Google AdWords Optimise your website for Search Engines Use Social Media to generate more customers 'Like' us on Facebook to get access to FREE Online Business Training! Recommended Articles How http://www.register365.com/support/702-oscommerce_error_1054_-_unknown_column_pnewsdesk_id_in_on_clause.html to setup a POP3 account on iPhone/iPad/iPhone5 How to reset your Online Control Panel Password Where can I find my FTP details / Change FTP password? Changing your domains DNS Settings Changing the Nameservers for a domain name Creating an Email Address How to reset your Email Password How to set up a POP3 account in Mac Mail How to set up a POP3 account in Microsoft Outlook 2010 Assign Hosting using a Multi Domain Hosting Package Download our Quick Start Guides Your Online Control Panel Managing Domain Names Managing Emails Hosting Your Domain Renewals More Info Network Status & Updates More Info Video & Tutorials More Info Support Tickets Log a ticket! More Info FTP LOCK Protect yourself from Hackers! More Info Our Company About Us Contact Us Sell Your Portfolio Read Our Blog Useful Links Online Control Panel WebMail Login Network Status Terms & Conditions Create Account Set up a Register365.com account and get access to a hub of resources and special offers. Need Help Call us, or Log a Support ticket Visit our Support Centre FREE Business Training Call us on: 01 5255768 +44 (0) 1905 342340 Facebook Twitter Google+ Youtube Prices are quoted both exclusive and inclusive of VAT. All purchases are charged with VAT and you w
Management Learn error 1054 More WordPress Services WordPress Hosting Superior WordPress Performance Learn More WordPress Themes Best Free WordPress Designs Learn More WordPress error 1054 oscommerce Tutorial Step-by-step WordPress Guide Learn More More Links: WordPress Plugins About WordPress WordPress FAQ WordPress Services Joomla Services Joomla Hosting Superior Joomla Performance Learn More Joomla Templates Best Free Joomla Designs Learn More Joomla Tutorial Step-by-step Joomla Guide Learn More More Links: Joomla Extensions About Joomla Joomla FAQ Joomla Services Our Technology Datacenters Miscelanea Debido al cambio de sintaxis en las nuevas versiones de MySQL algunas partes del OsCommerce dejan de funcionar. En este caso son las categorías y en ocasiones las búsquedas. Las subcategorías en OsCommerce funcionan como búsquedas avanzadas de las categorías. Por casualidad, este problema solo afecta a las búsquedas avanzadas y no a las normales. El error es el siguiente: select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = ‘1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ‘3′ and p2c.categories_id = ‘24′ [TEP STOP] La solución pasa por editar dos archivos del OsCommerce siguiendo los pasos que vienen a continuación: PASO 1: Abre el archivo catalog/index.php (si no existe el directorio catalog, es el index del public_html) y se cambia todo este bloque: // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = ‘1′ and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = ‘" . (int)$HTTP_GET_VARS['manufacturers_id'] . "‘ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ‘" . (int)$languages_id . "‘ and p2c.categories_id = ‘" . (int