In Progress

Fix error in OSCOMMERCE site

I have an OS commerce shopping site that was started many months ago. This may only be a case of updating OS files. Customer is now ready to resume the build. There is an error in the script and I need someone to find and fix it! :)

Error below:

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

select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '11'

[TEP STOP]

Skills: PHP, Shopping Carts

See more: updating resume, there fix it, the fix it, script resume, products manufacturers, manufacturers products, fix it site, fix it in, find resume, find manufacturers i, fix error 1054 unknown column pmanufacturers_id clause, error 0, where to find manufacturers, php fix error, fix error, find manufacturers, find and fix, error, error php, error in php script, need someone build site, 1054 unknown column select, 1054 php, someone fix, ready started

About the Employer:
( 12 reviews ) Plano, United States

Project ID: #218565

Awarded to:

hejian

I am the expert in such things. Let me complete your project quickly with a top quantity. Regards.

$30 USD in 0 days
(59 Reviews)
6.3

26 freelancers are bidding on average $38 for this job

cheapestandbest

i can fix this in an hour. payment after work is done. we are oscommerce certified devs.

$30 USD in 0 days
(676 Reviews)
8.9
hautu

Let me fix it for you. regards.

$30 USD in 0 days
(260 Reviews)
7.7
NickolaS

Hi, please, check your PM

$30 USD in 0 days
(340 Reviews)
7.5
pentium10

Professional work from professionals!

$30 USD in 0 days
(219 Reviews)
6.9
solutionD

Ready and excited.

$30 USD in 0 days
(79 Reviews)
6.7
drailean

hello, please check the PM

$30 USD in 0 days
(213 Reviews)
6.6
soniamit

let starts............... Regards soNia

$30 USD in 0 days
(189 Reviews)
6.6
Zeldaze

Can be fixed!

$30 USD in 0 days
(118 Reviews)
6.5
rajinfosolu

Dear Sir I have 6 years experience in php,mysql,smarty,oscommerce,ajax,javascript. Please view PM about my oscommerce projects. I will appreciate if you will provide this job to me. Regards Raj

$30 USD in 0 days
(64 Reviews)
6.5
anode

Ready to fix it right now. And I mean it :-)

$30 USD in 1 day
(131 Reviews)
6.3
jarvisliu

Good Day Sir Please See The Private Message for details thanks

$30 USD in 1 day
(38 Reviews)
5.7
Alexian

Hello. I'm an experienced web developer. I'm ready to begin work. Please check PM.

$30 USD in 0 days
(26 Reviews)
5.2
tamilsweet

Can fix it immediately...

$30 USD in 0 days
(30 Reviews)
4.4
scherfistv

Serious php/mysql programmer with 3 years experience would like to fix your site. If accepted I would need access to mysql or phpmyadmin. Have a nice day!

$30 USD in 0 days
(3 Reviews)
4.3
eshristi

pls see PMB!

$250 USD in 0 days
(13 Reviews)
3.8
frankendesigns

I can fix this as it applies to changes in PHP/MySQL on your server. Cheers, Adam

$30 USD in 1 day
(10 Reviews)
3.5
oshosting

This is a compatibility error in php. Your server will be on php5, where the oscommerce platform was based on php4. This error is quite easily fixed. Regards, Craig

$30 USD in 1 day
(2 Reviews)
3.5
bentaylor

Please check PMB.

$30 USD in 0 days
(5 Reviews)
3.4
Einnovator

Hi please check PMB

$30 USD in 1 day
(3 Reviews)
2.1
sunrise99

Hi, Easy to fix it. Let's start it at once. check pmB Best Regards,

$30 USD in 0 days
(2 Reviews)
1.6