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

May 29, 2008

Hi I get the following error on my site, i know this is a compatible problem, but all the threads i have read have told me that i need to change a paragragh of coding in the index.php file, but if you look at my index.php coding below you will see that the coding to replace is not in my index.php file.

I have tried just to add the coding, but this just appears on my index page when i open the site.

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 = '59'

[TEP STOP]

<?php

/*

$Id: index.php,v 1.1 2005/08/11 17:37:59 hpdl Exp $

E-Commerce Solutions

Released under the GNU General Public License

*/

require('includes/application_top.php');

// the following cPath references come from application_top.php

$category_depth = 'top';

if (isset($cPath) && tep_not_null($cPath)) {

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$cateqories_products = tep_db_fetch_array($categories_products_query);

if ($cateqories_products['total'] > 0) {

$category_depth = 'products'; // display products

} else {

$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

$category_parent = tep_db_fetch_array($category_parent_query);

if ($category_parent['total'] > 0) {

$category_depth = 'nested'; // navigate through the categories

} else {

$category_depth = 'products'; // category has no products, but display the 'no products' message

}

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<tr>

<tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<img src="images/str_head.gif" width="9" height="5" hspace="2" vspace="1"/><span class="crimson">Welcome to Adorable Apparel. THIS IS A TEST SITE</span><br>

I would like to welcome you to Adorable Apparel. A one stop shop for all you Lingerie needs. Click on Products above to see our full product range available to purchase today.

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td><b>Special Events</b>, Apart from our normal product lines, we stock special lines for special annual events throughout the year:</td>

</tr>

<tr>

</tr>

<tr>

<li><a href="" class="crimson">Easter</a></li>

<li><a href="" class="crimson">Christmas</a></li>

<li><a href="" class="crimson">Halloween</a></li>

<li><a href="" class="crimson">St Patricks Day</a></li>

<li><a href="" class="crimson">Valentines Day</a></li></ul></td>

</tr>

</table>

</td>

</tr>

<tr>

</tr>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

FIMBLE · May 29, 2008

alter table orders_status add public_flag int DEFAULT '1';

Save the above in a text file, then insert it to your database. it should work OK.

Regards

Nic

May 29, 2008

alter table orders_status add public_flag int DEFAULT '1';

Save the above in a text file, then insert it to your database. it should work OK.

Regards

Nic

Did this but has no effect.

FIMBLE · May 29, 2008

Did this but has no effect.

Thats because it was the wrong one!! Sorry

go here

http://www.oscommerce.com/community/contributions,4654

Regards

Nic

May 29, 2008

Thats because it was the wrong one!! Sorry

go here

http://www.oscommerce.com/community/contributions,4654

Regards

Nic

Hi

I alread know about this contrib.

as my original question states

Hi I get the following error on my site, i know this is a compatible problem, but all the threads i have read have told me that i need to change a paragragh of coding in the index.php file, but if you look at my index.php coding below you will see that the coding to replace is not in my index.php file.

I have tried just to add the coding, but this just appears on my index page when i open the site.

i cannot change or amend a code that is not in my index.php file.

my index.php file content is included in this post

BryceJr · May 30, 2008

I compared your index.php to a stock osc index.php. You are missing big blocks of code.

You may want to ask the people who made your template where they relocated it.

May 30, 2008

I compared your index.php to a stock osc index.php. You are missing big blocks of code.

You may want to ask the people who made your template where they relocated it.

asked for their assitance before coming to forum and their reply is

Tony,

Though we provide customized versions of osCommerce, we are not the ones who wrote the original program. If you need to patch the software you may want to go to http://oscommerce.com where you can find upgrades, documentation, and forums that should be of help.

Best Regards,

Patrick Giever

Flash-Template-Design.com

Ticket Details

===================

Ticket ID: LKO-150685

Department: Support

Priority: Emergency

Status: On Hold

dallascaley · May 30, 2008

Looking through your code, my guess is that someone cut and pasted the output of the actual PHP file (what you would see if you clicked view page source on your browser) and then copied that as your original file. however there are some php functions still in the code so that makes me think that they went in after doing that and replaced some of their own code with the actual includes.

your index.php is more modified than it is original.

the solution would be to download the original oscommerce files and replace the index.php (then you can apply the php 5 fix that was mentioned earlier)

also, you will run into a problem if you are using a template. (or if you are using a very old version of OS commerce)

if this is the case (templates) then the code that you need to replace in the advanced_search_result.php will not be there, instead you will be able to find this code in a similarly named file in the templates directory, here is the filepath: templates/content/advanced_search_result.tpl.php.

at least this is how it was for me, and mine works now.

of course, before you do anything, i would back up any file that your changing, just in case.

-Dallas

asked for their assitance before coming to forum and their reply is

Tony,

Though we provide customized versions of osCommerce, we are not the ones who wrote the original program. If you need to patch the software you may want to go to http://oscommerce.com where you can find upgrades, documentation, and forums that should be of help.

Best Regards,

Patrick Giever

Flash-Template-Design.com

Ticket Details

===================

Ticket ID: LKO-150685

Department: Support

Priority: Emergency

Status: On Hold

May 30, 2008

Looking through your code, my guess is that someone cut and pasted the output of the actual PHP file (what you would see if you clicked view page source on your browser) and then copied that as your original file. however there are some php functions still in the code so that makes me think that they went in after doing that and replaced some of their own code with the actual includes.

your index.php is more modified than it is original.

the solution would be to download the original oscommerce files and replace the index.php (then you can apply the php 5 fix that was mentioned earlier)

also, you will run into a problem if you are using a template. (or if you are using a very old version of OS commerce)

if this is the case (templates) then the code that you need to replace in the advanced_search_result.php will not be there, instead you will be able to find this code in a similarly named file in the templates directory, here is the filepath: templates/content/advanced_search_result.tpl.php.

at least this is how it was for me, and mine works now.

of course, before you do anything, i would back up any file that your changing, just in case.

-Dallas

This site script is a full site. This was amongst a whole set of osc templates etc i purchased, all other osc setups are OK, it just seems that the auther of this site scriot has made the index.php file like an html file where all the written text on the home page is written in the index.php file, so when i do replace this with an original osc index.php file i am presented with a blank page apart from the header. look at easyas-abc (dot)co(dot)uk and you will see what i mean

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

Recommended Posts

Guest

FIMBLE

Guest

FIMBLE

Guest

BryceJr

Guest

dallascaley

Guest

Archived

Browse

Activity