Dibatalkan

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.

Kemahiran: PHP

Lihat lebih lanjut: 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

Tentang Majikan:
( 4 ulasan ) Palm Bay, United States

ID Projek: #81574

13 pekerja bebas membida secara purata $34 untuk pekerjaan ini

wildCat

no problem, will be done in the during 1 hour

$30 USD dalam 0 hari
(302 Ulasan)
8.4
hautu

I can fix it. regards

$30 USD dalam 0 hari
(246 Ulasan)
7.6
willarin

Htllo please see PMB

$30 USD dalam 0 hari
(30 Ulasan)
6.9
abstechnosoft

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

$30 USD dalam 0 hari
(129 Ulasan)
7.1
flexsolution

Can be done. Please check PM for more detail

$60 USD dalam sehari
(8 Ulasan)
5.2
VladKuznetsov

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

$30 USD dalam 0 hari
(49 Ulasan)
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.

$30 USD dalam sehari
(11 Ulasan)
3.6
WaterlooCoder

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

$50 USD dalam sehari
(4 Ulasan)
3.2
oscommercestudio

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

$30 USD dalam sehari
(2 Ulasan)
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 Lagi

$30 USD dalam sehari
(0 Ulasan)
0.0
tnlsolutions

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

$30 USD dalam 0 hari
(0 Ulasan)
1.6
hiway

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

$35 USD dalam 0 hari
(0 Ulasan)
2.9
nizarjilani

No comments.

$30 USD dalam 0 hari
(1 Ulasan)
0.0