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

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 offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (30 reviews)

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

Report Violation

Job Type

See more: error, fix, oscommerce, products

Messages Posted:0

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

PMB

0 days

01-04-2008 15:16 EST

9.9899/10
(395 reviews)

Hi, please, check your PM

value4u online

0 days

01-04-2008 15:39 EST

9.9422/10
(329 reviews)

Hi, please check my PM. Thanks you.

imotion offline

0 days

01-04-2008 15:06 EST

9.9179/10
(329 reviews)

Please check PMB...iMotion

pentium10 offline

0 days

01-04-2008 15:13 EST

9.9884/10
(259 reviews)

Professional work from professionals!

anode offline

1 day

01-04-2008 15:54 EST

9.9891/10
(184 reviews)

Please check PM. Thank you.

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.