In Progress

oscommerce site giving 1054 - Unknown column Error

hey guys i switched my site to new web hosting provider and after i have uploaded teh site to new host. i was getting this error when i visit product category page

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

select distinct p.products_id, p.products_image, p.products_tax_class_id, [url removed, login to view] as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '5' and p.products_status = '1' and [url removed, login to view] = '1' order by rand() DESC limit 6


olny two things i could think of changed.

1) my older host had mysql v 4.1 and the newer one upgraded me to 5.0

also im having problems viewing my admin side. Like the files are not viewable.. i just see blank white page... may be i have entered the wrong path.

nways can some one please fix these issues for me.


Skills: PHP, Shopping Carts

See more: oscommerce error 1054, web site error, error on web page fix, search error 1054 unknown column ccategories_id clause oscommerce, desc limit 1054 oscommerce, 1054 error oscommerce, oscommerce 1054 unknown column, p v, error php, desc, Column, older, white order, php mysql error unknown column, 1054 unknown column select, 1054 php, limit product, categories site, blank admin page oscommerce, 1054 unknown, giving, 1054, 1054 unknown column admin clause, oscommerce php blank, page blank oscommerce

About the Employer:
( 37 reviews ) Niagara Falls, Canada

Project ID: #235754