OSCommerce Error 1054
Project ID:
462852Project Type:
FixedBudget:
$30-$250 USD
Project Description:
We just transferred our web site which is an OScommerce site to another domain. All works good except for when we try to view sub-categories within a main category we get error 1054 as outlined below. We have read that this is an easy fix an has to do with PhP 5 versus PhP. We need this fixed asap. :-)ERROR WE GET:
1054 - Unknown column 'p.products_id' in 'on clause'
select count(*) 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 = '47'
[TEP STOP]
Skills required:
PHP, SQL
Public Clarification Board
Awarded Bids
All Bids ()
saiSoftIndia
|
saiSoftIndia
From India
Gold Member
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
Ready to fix yor problem
mrroberto
|
mrroberto
From Lithuania
Gold Member
Offline
|
Freelancer Orientation (80%, 97th percentile)
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
hi, i can help you. i am expert with osc.
quick pro help. ftp and escrow required.
webofsolutions
|
webofsolutions
From India
Gold Member
Online
|
US English Level 1 (%, 31st percentile)
General Freelancer Orientation (85%, 95th percentile)
$30
in 0 days
over 2 years ago
please check pm.
webizzie
|
webizzie
From United States
Offline
|
General Freelancer Orientation (85%, 95th percentile)
$30
in 1 day
over 2 years ago
see pmb for details
TakeReal
|
TakeReal
From Russian Federation
Offline
|
Foundation Freelancer.co.uk Member
HTML Level 1 (93%, 99th percentile)
JavaScript Level 1 (88%, 94th percentile)
ASP Level 1 (75%, 94th percentile)
SQL Level 1 (90%, 85th percentile)
General Freelancer Orientation (85%, 95th percentile)
Foundation EUFreelance.com Member
$30
in 1 day
over 2 years ago
I can fix your oscommerce. I need FTP access.
soniamit
|
soniamit
From India
Gold Member
Offline
|
General Freelancer Orientation (80%, 90th percentile)
$30
in 0 days
over 2 years ago
let starts........ regards soNia
Ready to fix this right away. Thank you.
sinisa
|
sinisa
From Serbia and Montenegro
Gold Member
Online
|
Foundation EUFreelance.com Member
$30
in 2 days
over 2 years ago
Hi, i am interested.
richammond
|
richammond
From United Kingdom
Offline
|
US English Level 1 (%, 72nd percentile)
Freelancer Orientation (80%, 97th percentile)
HTML Level 1 (70%, 60th percentile)
Employer Orientation (80%, 99th percentile)
General Freelancer Orientation (90%, 98th percentile)
$30
in 0 days
over 2 years ago
lets start!!
tipstersoft
|
|
tipstersoft
From India
Offline
|
General Freelancer Orientation (80%, 90th percentile)
$30
in 0 days
over 2 years ago
lets start..please check pm
misulica
|
|
misulica
From Romania
Offline
|
Freelancer Orientation (75%, 94th percentile)
General Freelancer Orientation (90%, 98th percentile)
Foundation EUFreelance.com Member
$60
in 0 days
over 2 years ago
Ready to start
Hi,
Please check PM.
Thanks
It can be done. please check PMB.
gnbizco
|
gnbizco
From India
Offline
|
Freelancer Orientation (80%, 97th percentile)
Freemarket.com Foundation Merchant
General Freelancer Orientation (75%, 81st percentile)
$30
in 0 days
over 2 years ago
Hello, We can fix this in 20 min and can pay us $20 for this.We have fixed this many times.Look forward to hear from you.Thankyou
Hello, I am ready to start on this right away. Please see my PM. Best regards
Hi,
Plz see pmb for details
shajibs
|
shajibs
From Bangladesh
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
i can do it. thanks
Dear Sir,
We can fix the problem. Please check the PMB for details.
Thanks
DesertShip Team
mtamoor
|
|
mtamoor
From Czech Republic
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
Sir
I am an experienced oscommerce developer and i can fix the problem on your site in a day. But if your site has many additional modifications done it might take a bit longer.
Regards.
adthecoder
|
|
adthecoder
From India
Offline
|
Foundation LimeExchange Member
$30
in 0 days
over 2 years ago
i am a osc expert
adonisprogrammer
|
|
adonisprogrammer
From India
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
we check your PMB for further details
crysteltech2008
|
|
crysteltech2008
From India
Offline
|
Foundation EUFreelance.com Member
$30
in 1 day
over 2 years ago
Let's get it done right away.
sudrosario
|
|
sudrosario
From India
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$30
in 1 day
over 2 years ago
These projects have been accomplished with an accuracy 99.9% as we have in-house quality control dept. and software and r&d dept to full fill the needs of the specification of the projects