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.

Closed
(Selected Service Provider wincent)
Status: Closed
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
 
Artician LLC Featured
posted by artician
Budget: min $3000
 

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 9.96/109.96/109.96/109.96/109.96/109.96/109.96/109.96/109.96/109.96/10
(333 reviews)
Hi, please, check your PM
imszone
View PM Post PM
$ 50 0 days 10-30-2007 08:25 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(69 reviews)
Hi, please see PM.
wincent
View PM Post PM
$ 30 0 days 10-30-2007 08:48 9.81/109.81/109.81/109.81/109.81/109.81/109.81/109.81/109.81/109.81/10
(57 reviews)
can be done quickly.
exitsol
View PM Post PM
$ 30 0 days 10-30-2007 08:20 9.98/109.98/109.98/109.98/109.98/109.98/109.98/109.98/109.98/109.98/10
(55 reviews)
Lets get started.Pls see PMB
nknk
View PM Post PM
$ 30 1 day 10-30-2007 08:29 9.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/10
(50 reviews)
Hi. Can fix that. Please check PM.
Bid on This Project

 

[ Website Design ] [ GAF Top Users ] [ 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. Our mission is to find the best possible freelance workers at the best possible price. Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%. We have thousands of satisfied clients around the world. Deposit money and don't purchase until your project is completed. A freelancer is an independent worker, not on salary, hired instead on a project basis.

Buy services with help from our secure escrow system. GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects. Companies of any size have used our web services. Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start!

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