Closed

OSC Debugging

My hosting provider did some server updates so my website has this error on frontpage.

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

Already worked on code in [url removed, login to view] and [url removed, login to view] but error is still there.

Need help!

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

select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, 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, p.products_tax_class_id, sp.product_id from products p, products_description pd, star_product sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '5'

[TEP STOP]

Skills:

See more: error code 1054 unknown column, error code 1054 unknown column clause, 1054 php, php debugging, 1054 unknown, 1054, need help debugging, unknown column php, unknown column clause 1054, debugging help, unknown website error, unknown column products_id clause advanced_search_result php, unknown column products_id clause, unknown column products_id, unknown column advanced_search_result php, unknown column, unknown clause, unknown, provider error, php unknown column clause, osc debugging, osc column, error unknown column products_id clause, error unknown column products_id clause, error osc

About the Employer:
( 0 reviews ) targoviste, Romania

Project ID: #252360

2 freelancers are bidding on average $45 for this job

phpmysql5

Can i help you, plz send me ur details, thank you.

$50 USD in 1 day
(0 Reviews)
0.0
creativmagic

sir we can solve your problem. Give a chance. Go to site for our work example [login to view URL]

$40 USD in 2 days
(0 Reviews)
0.0