Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

catalog/categories error


Guest

Recommended Posts

On my website, when you click on a category all you get is this error message

 

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

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 = '1' and p2c.categories_id = '96'

 

[TEP STOP]

Link to comment
Share on other sites

On my website, when you click on a category all you get is this error message

1054 - Unknown column 'p.products_id' in 'on clause'

 

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 = '1' and p2c.categories_id = '96'

 

[TEP STOP]

 

If you're using PHP5 as opposed to PHP 4.x, then take a look at this, download it, and follow the simple readme instructions; it'll take 2 minutes max: http://www.oscommerce.com/community/contributions,4654

 

If that doesn't completely due the trick, or it's not a PHP5 issue, then have a look at this posting.

 

Good luck.

Jason

 

Simple 1-2-3 Intructions on how to get, install and configure SSL

 

The Google Sandbox explained

 

Simple to follow instructions on how to change the look of your OSC

 

How To Make A Horrible OSC Website

 

my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP

 

my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...

Link to comment
Share on other sites

If you're using PHP5 as opposed to PHP 4.x, then take a look at this, download it, and follow the simple readme instructions; it'll take 2 minutes max: http://www.oscommerce.com/community/contributions,4654

 

If that doesn't completely due the trick, or it's not a PHP5 issue, then have a look at this posting.

 

Good luck.

 

 

I no longer have a webmaster and I am a little rusty. Hoow do I get to the pages that are mentioned. I didn't see the download. What am I missing?

Thanks...Teddy

Link to comment
Share on other sites

I no longer have a webmaster and I am a little rusty. Hoow do I get to the pages that are mentioned. I didn't see the download. What am I missing?

Thanks...Teddy

The download is the icon to the right of screen that looks vaguely like an open envelope.

Click on the underlined test to get to the pages.

Link to comment
Share on other sites

PHP version 5.2.1

 

MySQL version 5.0.27-standard-log

 

osCommerce 2.2-MS2

 

Well then you have your answer. On my first posting, now that we know it's a php5.x issue, just follow those instructions.

Jason

 

Simple 1-2-3 Intructions on how to get, install and configure SSL

 

The Google Sandbox explained

 

Simple to follow instructions on how to change the look of your OSC

 

How To Make A Horrible OSC Website

 

my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP

 

my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...

Link to comment
Share on other sites

Well then you have your answer. On my first posting, now that we know it's a php5.x issue, just follow those instructions.

 

Download a PHP editor (I use PHP Editor 2007, but there are several, and everyone has their own preference .... Crimson Editor, etc., or whatever), and open up your root directory folder (public_html, catalog, whatever it is). Find index.php and make the according changes, and then find advanced_search_results and make the according changes.

 

Save the files (after making copies of them just in case you screwed up, and then upload them to the root directory on your server. Good luck.

Jason

 

Simple 1-2-3 Intructions on how to get, install and configure SSL

 

The Google Sandbox explained

 

Simple to follow instructions on how to change the look of your OSC

 

How To Make A Horrible OSC Website

 

my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP

 

my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...

Link to comment
Share on other sites

Download a PHP editor (I use PHP Editor 2007, but there are several, and everyone has their own preference .... Crimson Editor, etc., or whatever), and open up your root directory folder (public_html, catalog, whatever it is). Find index.php and make the according changes, and then find advanced_search_results and make the according changes.

 

Save the files (after making copies of them just in case you screwed up, and then upload them to the root directory on your server. Good luck.

 

Hi downloaded the contribution

 

in the index.php files cant find

 

// determine the page directory

 

if (!isset($_GET['main_page']) || !cp_not_null($_GET['main_page'])) $_GET['main_page'] = 'index';

 

if (MISSING_PAGE_CHECK == 'true') {

if (!is_dir(DIR_WS_MODULES . 'pages/' . $_GET['main_page'])) $_GET['main_page'] = 'index';

}

 

$current_page = $_GET['main_page'];

 

$current_page_base = $current_page;

$code_page_directory = DIR_WS_MODULES . 'pages/' . $current_page_base;

$page_directory = $code_page_directory;

 

$language_page_directory = DIR_WS_LANGUAGES . $_SESSION['language'] . '/';

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...