GetAFreelancer.com - osCommerce

osCommerce - fix bug #1054

osCommerce - fix bug #1054 is project number 157723 posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed (Selected Service Provider)

Selected Providers: selected service provider hautu

Budget: $30-100

Created: 07/08/2007 at 7:06 EDT

Bidding Ends: 07/11/2007 at 7:06 EDT

Project Creator: lokust
Buyer Rating:
(17 reviews)

Description: I have noticed a small bug in my osCommerce shop after having moved a site to a new server which appears to have mysql 5 installed.

I get the following error when clicking on menu category links:

1054 - Unknown column 'p.products_id' in 'on clause'
select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '73' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

I believe this is something to do with the Ultimate SEO url contribution though I have applied the fixes noted in forums without success - I have now removed the fixes ( I am using Ultimate SEO Url's package: Ultimate_SEO_URLsv21da )

In apache error log I can see:

[Sat Jul 7 18:47:02 2007] [error] PHP Warning: Cannot modify header information - headers already sent by (output started at /path/to/includes/sts_display_output.php:164) in /path/to/includes/classes/seo.class.php on line 1995

Job Type:
PHP

Database: MySQL

Operating system: Linux

Bid count: 24

Average bid: N/A

Related project

Nonpublic project #300618 ^Featured ^Nonpublic

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
Bids are hidden by project creator. as the project creator or as one of the bidders to view bids.

[ Outsourcing Web Design ] [ Outsourcing ] [ Web Forms ]

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

Our mission is to find the best possible freelance workers at the best possible price. Outsourcing is hiring an outside organization to perform services such as information processing and applications development. It's easy, fun and very affordable to outsource your project with our site. A freelancer is an independent worker, not on salary, hired instead on a project basis. We provide a safe escrow environment and you don't release the money until project is completed.

If you never tried to contract work to another part of the world you have your chance today. Sign up free! Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start! Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world. 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.

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