In Progress

osCommerce Error needs fixing

I have a problem showing at my site [url removed, login to view] and every other subcategory page, no products seem to be showing.

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

select count(p.products_id) as total 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 = '64'

[TEP STOP]

If I receive a good price for this work, I will use you whenever I need programming done, We have just started our web design business and require someone reliable and cost effective to work with us on future projects.

Many Thanks

John

Skills: PHP, Script Install, Shopping Carts

See more: web site error, web design specials, programming needs, programming error, products manufacturers, problem fixing, php programming books, manufacturers products, john price, good programming books, fixing problem, fixing my, programming books, cost problem, books programming, oscommerce web installation, error page design, 1054 unknown column select, 1054 php, subcategory, 1054 unknown, need fixing, 1054, oscommerce tep stop error, left installation

About the Employer:
( 1 review ) Bordon, United Kingdom

Project ID: #238354

Awarded to:

lestervan

Hi, if you check my reviews, I used to fix this bug many times. Thanks, Lester.

$30 USD in 0 days
(33 Reviews)
5.7

15 freelancers are bidding on average $31 for this job

value4u

Hi, I have very much experience with this problem. Thank you.

$30 USD in 0 days
(342 Reviews)
8.4
TakeReal

I can fix this problem today. I need FTP access to start now.

$30 USD in 1 day
(1295 Reviews)
7.5
LloydesignStudio

Hi sir ready to start. :) Lloyd

$30 USD in 1 day
(245 Reviews)
6.7
Pektsekye

i can do it,please check your pm

$30 USD in 1 day
(107 Reviews)
5.6
rajinfosolu

Dear Sir I have 6 years experience in php,mysql,smarty,oscommerce,ajax,javascript. I have experienced and expertise in these fields. Please view PM about My oscommerce projects. I will appreciate if you will pro More

$30 USD in 0 days
(66 Reviews)
6.5
exitsol

Lets get started

$30 USD in 0 days
(137 Reviews)
6.0
seolinkdesign

Can start right now. Regards

$30 USD in 1 day
(31 Reviews)
5.5
threeways

Please read my PM.

$50 USD in 1 day
(3 Reviews)
3.8
Identifier

dear sir please check my pm. regards hamed

$30 USD in 0 days
(11 Reviews)
3.9
gyanart

Dear Sir, Please see PMB

$30 USD in 1 day
(12 Reviews)
3.6
netdynamixza

Can complete this for you within 2 hours... Chris

$30 USD in 0 days
(1 Review)
1.2
belbek

I will do the job today

$30 USD in 0 days
(0 Reviews)
0.0
kaliwangansyah

I can fixing This Error!

$30 USD in 1 day
(0 Reviews)
0.0
ramkrishnasharda

It can be easily done, related with database problem.Kindly give details of your site :) Regards

$30 USD in 1 day
(0 Reviews)
0.0