Annulleret

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.

Færdigheder: PHP

Se mere: 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

Om arbejdsgiveren:
( 4 bedømmelser ) Palm Bay, United States

Projekt-ID: #81574

13 freelancere byder i gennemsnit $34 for dette job

wildCat

no problem, will be done in the during 1 hour

$30 USD in 0 dage
(302 bedømmelser)
8.4
hautu

I can fix it. regards

$30 USD in 0 dage
(246 bedømmelser)
7.6
willarin

Htllo please see PMB

$30 USD in 0 dage
(30 bedømmelser)
6.9
abstechnosoft

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

$30 USD in 0 dage
(129 bedømmelser)
7.1
flexsolution

Can be done. Please check PM for more detail

$60 USD på 1 dag
(8 bedømmelser)
5.2
VladKuznetsov

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

$30 USD in 0 dage
(49 bedømmelser)
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 på 1 dag
(11 bedømmelser)
3.6
WaterlooCoder

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

$50 USD på 1 dag
(4 bedømmelser)
3.2
oscommercestudio

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

$30 USD på 1 dag
(2 bedømmelser)
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 Mere

$30 USD på 1 dag
(0 bedømmelser)
0.0
tnlsolutions

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

$30 USD in 0 dage
(0 bedømmelser)
1.6
hiway

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

$35 USD in 0 dage
(0 bedømmelser)
2.9
nizarjilani

No comments.

$30 USD in 0 dage
(1 bedømmelse)
0.0