İptal Edildi

SQL errors in osCommerce! HELP!

Ok, I thouhgt I only had one mySQL error, but now I'm getting 2 of them. One both of my sites, I'm getting the following:

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 = '242'

And in addition to that, on another one of my sites, I'm getting the following:

CODE

1054 - Unknown column 'products_name' in 'field list'

select products_name from products_description where products_id = '318' and language_id = '1'

[TEP STOP]

I don't have a large budget, but I really need some help. If anyone could help me out, I'd appreciatie it!

Please note that I would prefer someone from the US to work on this project. Thanks.

Beceriler: PHP

Daha fazlasını görün: products manufacturers, need sql help, manufacturers products, help php, t-sql in, p sql, on sql, t-sql;, sql mysql, Sql code, some help, oscommerce help, manufacturers list, join them, php sql code, error code 1054 unknown column, field addition, php mysql error unknown column, sql select select, error code 1054 unknown column clause, unknown column language_id field list, 1054 unknown column select, sql select, 1054 php, 1054 unknown

İşveren Hakkında:
( 4 değerlendirme ) Palm Bay, United States

Proje NO: #81574

13 freelancers are bidding on average $34 for this job

wildCat

no problem, will be done in the during 1 hour

in 0 gün içinde30$ USD
(302 Değerlendirme)
8.4
hautu

I can fix it. regards

in 0 gün içinde30$ USD
(246 Değerlendirme)
7.6
willarin

Htllo please see PMB

in 0 gün içinde30$ USD
(30 Değerlendirme)
6.9
abstechnosoft

hi can do it right now. plz see PMB. Thanks

in 0 gün içinde30$ USD
(129 Değerlendirme)
7.1
flexsolution

Can be done. Please check PM for more detail

1 gün içinde 60$ USD
(8 Değerlendirme)
5.2
VladKuznetsov

Hello Sir. I can fix this SQL bug right now. Regards Zend Certified PHP Developer Vladimir Kuznetsov.

in 0 gün içinde30$ USD
(49 Değerlendirme)
4.9
ecommerce4u

I'm an oscommerce expert. I've recently fixed that bug for my client so it won't be a serious problem. Regards, Michael.

1 gün içinde 30$ USD
(11 Değerlendirme)
3.6
WaterlooCoder

think I've already got the solution to the first problem....the second SQL error is a little weirder.

1 gün içinde 50$ USD
(4 Değerlendirme)
3.2
oscommercestudio

Hi, you just helped out a friend of mine. So this is to say thank-you. (authorize advise)

1 gün içinde 30$ USD
(2 Değerlendirme)
2.6
eBuilder

We take pride in accommodating special project requests, responding rapidly to our clients' needs, and providing cost-effective, customized solutions. At eBuilder, we approach each implementation in the true spirit o Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
tnlsolutions

Dear Sir, Let me do it - I will provide you the best services. Thank you

in 0 gün içinde30$ USD
(0 Değerlendirme)
1.6
hiway

Please PM me the table structures. You will have the SQL corrected pronto. Thanks.

in 0 gün içinde35$ USD
(0 Değerlendirme)
2.9
nizarjilani

No comments.

in 0 gün içinde30$ USD
(1 Değerlendirme)
0.0