GetAFreelancer.com - fix a OSC bug due to mysql 5.1

fix a OSC bug due to mysql 5.1

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

Closed
(Selected Service Provider lestervan)

Status: Closed

Budget: $30-100

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

Bidding Ends: 05/13/2007 at 22:29 EDT

Project Creator: phillystory
Buyer Rating:
(41 reviews)

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:

Database: MySQL

Operating system: Linux

Bid count: 2

Average bid: $ 30

Messages Posted: 0

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

Service Providers

PMB

Bid

Delivery Within

Time of Bid

Provider Rating

ahtsolutions

$ 30

0 days

05-08-2007 22:35

(61 reviews)

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

lestervan

$ 30

1 day

05-08-2007 22:36

(38 reviews)

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

[ Website Design ] [ Secure Forms ] [ Post Project Free ] [ Outsourcing Web Design ] [ Freelance ]

What is GetAFreelancer.com? ( Read about the company )

GetAFreelancer.com is one of the largest sites of its kind. We have earned a good reputation and you can trust us. Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today! It's easy, fun and very affordable to outsource your project with our site. Companies of any size have used our web services. Outsourcing is hiring an outside organization to perform services such as information processing and applications development.

Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%. Outsource projects and save a lot of money. Getting affordable freelance work, freelance programming and custom web design done for your website has never been easier. A freelancer is an independent worker, not on salary, hired instead on a project basis.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.