GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Error on OSCommerce website

   Click here to post similar project

Error on OSCommerce website is project number 190809 posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider wincent
Budget: $30-100
Created: 10/30/2007 at 8:12 EDT
Bidding Ends: 11/04/2007 at 8:12 EST
Project Creator: DmDepot View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(9 reviews)
Description: Following error message present on every page of the catalog:

___________________________________________________________________
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '139' and opa.orders_id = opb.orders_id and opb.products_id != '139' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6
_____________________________________________________________________

Looking for the professional to remove this error.
Additional files submitted:
untitled.JPG
Report violation
Job Type:
  • PHP
  • Script Installation
Database: MySQL
Operating system: (None)
Bid count: 5
Average bid: $ 34

 

Related project
 
Nonpublic project #324703 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
NickolaS
View PM Post PM
$ 30 0 days 10-30-2007 08:28 EDT 9.99/109.99/109.99/109.99/109.99/109.99/109.99/109.99/109.99/109.99/10
(341 reviews)
Hi, please, check your PM
imszone
View PM Post PM
$ 50 0 days 10-30-2007 08:25 EDT 9.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/10
(88 reviews)
Hi, please see PM.
nknk
View PM Post PM
$ 30 1 day 10-30-2007 08:29 EDT 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(70 reviews)
Hi. Can fix that. Please check PM.
wincent
View PM Post PM
$ 30 0 days 10-30-2007 08:48 EDT 9.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/10
(65 reviews)
can be done quickly.
exitsol
View PM Post PM
$ 30 0 days 10-30-2007 08:20 EDT 9.98/109.98/109.98/109.98/109.98/109.98/109.98/109.98/109.98/109.98/10
(61 reviews)
Lets get started.Pls see PMB
Bid on This Project

 

[ Freelance ] [ Post Project Free ] [ Outsourcing ] [ View All Projects ]

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

Our escrow feature is developed to protect both buyers and sellers. If you never tried to contract work to another part of the world you have your chance today. Sign up free! Deposit money and don't purchase until your project is completed.

Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your 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. We provide a safe escrow environment and you don't release the money until project is completed. We have thousands of satisfied clients around the world.

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