Project Detail

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

Fix 1054 - Unknown column 'p.products_id' in 'on clause' error is project number 210094
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: imotion

Budget: $30-100

Created: 01/04/2008 at 15:03 EST

Bid Count: 5

Average Bid:
$ 30

01/05/2008 at 15:03 EST

Project Creator: jellybabys
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (30 reviews)

Bid On This Project
 

Description

Hello

I have an error on my site, i fixed the ones in the categories that had the same error, but im still getting this error when i have a subcategory.

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

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status 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 = '81' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 12

[TEP STOP]

Must have good knowledge of oscommerce and programming.

Thanks

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

30

0 days

01-04-2008 15:16 EST

Hi, please, check your PM

help

 

30

0 days

01-04-2008 15:39 EST

Hi, please check my PM. Thanks you.

help

 

30

0 days

01-04-2008 15:06 EST

Please check PMB...iMotion

help

 

30

0 days

01-04-2008 15:13 EST

Professional work from professionals!

help

 

30

1 day

01-04-2008 15:54 EST

Please check PM. Thank you.

help


    Bid on this Project