1054 - Unknown column 'p.products_id' in 'on clause' in the BEST SELLERS column

[adixfrancis]

Hi everyone.

 

I'm having trouble on my BEST SELLERS column.

I all ready change the script in the index.php relative to the "// show the products of a specified manufacturer

" and i fixed the products problem that i had, but on the BEST SELLERS column still remain, and this is what is shown on my main page:

 

 

Warning: mysql_query() [http://www.mysql.com/doc]: Unknown column 'p.products_id' in 'on clause' in .....

....\catalog\includes\functions\database.php on line 44

 

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

 

select p.products_image, pd.products_name, 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 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 = '61' order by p.products_date_added DESC limit 2

 

[TEP STOP]

 

 

By curiosity, when i try to make a search, it opens a white page whit this message:

 

Warning: mysql_query() [http://www.mysql.com/doc]: Data too long for column 'last_page_url' at row 1 in ....

....catalog\includes\functions\database.php on line 44

 

1406 - Data too long for column 'last_page_url' at row 1

 

update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '127.0.0.1', time_last_click = '1229102267', last_page_url = '/catalog/advanced_search_result.php?keywords=pajamas&x=39&y=14&categories_id=&inc_subcat=1&manufacturers_id=&pfrom=&pto=&dfrom=&dto=' where session_id = ''

 

[TEP STOP]

 

Warning: Unknown: 2 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0

 

Notice, this is common to both errors:

"catalog\includes\functions\database.php on line 44"

 

I'M running this on a PC with Apache 2.2 + PHP5 and i understand that this problems are made by the changes on PHP5

 

Anyone know how to fix this

I really need some help on this

 

Thanks in advance

[GemRock]

this question has been asked and answered 1054 times (someone even creates a contrib for it), hence the error code 1054.

Ken

[adixfrancis]

this question has been asked and answered 1054 times (someone even creates a contrib for it), hence the error code 1054.

Ken

 

i know this has been answered many times but as i said before, i all ready changed and used that contribution (http://www.oscommerce.com/community/contributions,4654)

and in fact did resolved the search and the products issue, but the thing is, the problem still remains in the best sellers column.

 

i do believe, this problem have the same kind of fix, but i just don't know where and how?

 

I'm new in oscommerce and in PHP so what could seems easy to you, as been hard to me,

i really do appreciate it, if you can explain to me how to fix this.

 

thank you Ken

 

Francisco

[adixfrancis]

all ready fixed