1054 error, tried 2 fixes, no go!

[Jebediah_Springfield]

hi all

 

i have tried 2 fixes on this site for the 1054 error, one was from the contribute page and another was in the forum.

 

however it hasnt made any different and i have no idea why

 

address is http://www.alterstitch.com.au/shop/index.php

 

error message is

 

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]

 

 

on a side note, i did look at a 3rd fix here

 

http://www.oscommerce.com/forums/index.php?sho...286&hl=1054

 

but i am not sure what file im ment to be looking at to change :(

 

-------------

 

im also getting a few areas in my admin area so if anyone wants to check it out please pm me and ill give you the login details.

 

thanks very much if you can help, if it takes you time to fix it ill pay you as well.

[Jebediah_Springfield]

woah i made some typo's in there, soz :blush:

[Jebediah_Springfield]

and if anyone is interested about helping fix up my admin part the error im getting is:

 

Warning: Cannot modify header information - headers already sent by (output started at /home/surf206/public_html/alterstitch/shop/admin/includes/classes/upload.php:1) in /home/surf206/public_html/alterstitch/shop/admin/includes/functions/general.php on line 22

[Jebediah_Springfield]

and if anyone is interested about helping fix up my admin part the error im getting is:

 

Warning: Cannot modify header information - headers already sent by (output started at /home/surf206/public_html/alterstitch/shop/admin/includes/classes/upload.php:1) in /home/surf206/public_html/alterstitch/shop/admin/includes/functions/general.php on line 22

 

this part is fixed :D

[♥geoffreywalton]

These links may be of use.

 

http://www.oscommerce.com/ext/update-20060817.txt

 

These threads might also be of use

 

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

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

http://www.oscommerce.com/forums/index.php?showtopic=179130