catalog/categories error

[Guest]

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]

[jpweber]

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.

[Guest]

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

[Guest]

NO GOOD

 

PLEASE HELP ME!!!!

[Guest]

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.

[Guest]

NO GOOD

 

PLEASE HELP ME!!!!

What php, mysql, osc versions are you using?

[Guest]

What php, mysql, osc versions are you using?

 

 

PHP version 5.2.1

 

MySQL version 5.0.27-standard-log

 

osCommerce 2.2-MS2

[jpweber]

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.

[jpweber]

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.

[Guest]

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'] . '/';

[unclefudgly]

having the exact same problem, but am at a loss as to how to fix it.

 

can someone explain which section in index.php needs replacing

 

thanks