Project Detail

fix a OSC bug due to mysql 5.1  

fix a OSC bug due to mysql 5.1 is project number 144055
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: lestervan

Budget: $30-100

Created: 05/08/2007 at 22:29 EDT

Bid Count: 2

Average Bid:
$ 30

05/13/2007 at 22:29 EDT

Project Creator: phillystory
Employer Rating: 9.7826/109.7826/109.7826/109.7826/109.7826/109.7826/109.7826/109.7826/109.7826/109.7826/10 (46 reviews)

Bid On This Project
 

Description

After upgrade from mysql 4.1 to 5.1, the bug comes:

if click catalog, it will say:

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

The solution is already post at OSCOMMERCE official site:

http://www.oscommerce.com/community/bugs,3171

Please fix the bug for $30 thanks

Job Type
See more: bug, click, fix, mysql, osc, oscommerce, post, products

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

ahtsolutions

 

30

0 days

05-08-2007 22:35 EDT

9.8696/109.8696/109.8696/109.8696/109.8696/109.8696/109.8696/109.8696/109.8696/109.8696/10
(184 reviews)

we can do it now. Can you view PMB for details. AHT Group.

help

lestervan

 

30

1 day

05-08-2007 22:36 EDT

9.9737/109.9737/109.9737/109.9737/109.9737/109.9737/109.9737/109.9737/109.9737/109.9737/10
(38 reviews)

Hi, I can fix it for $30 and can start right now. THanks, lester.

help


    Bid on this Project