In Progress

oscommerce product attribute mysql error

**URGENT**

I have a customers site going live in several hours but we have hit an error when we go into admin / product attributes. We get the following error:

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 pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id from products_options_values pov left join products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '1' order by pov.products_options_values_id

I guess this is a mysql 5 problem as the webhost is php / mysql 5 and my test sever has mysql / php 4 The oscommerce version is MS2.2 latest snapshot

I need this done ASAP I can send over the database if required

Skills: PHP, Website Design

See more: snapshot design, product design customers, product database design, error 0, urgent mysql, test website asap, snapshot, sever, product test, mysql, mysql test, mysql error, mysql admin, error, error php, attribute, admin error, mysql attributes, website error, mysql check, error database problem, check attribute, examine, product attributes php mysql, mysql product database

About the Employer:
( 57 reviews ) Auckland, New Zealand

Project ID: #118624

3 freelancers are bidding on average $100 for this job

globaltechnosys

Hi! I am really interested in taking up the project. I have the requisite experience and the expertise to complete this project with success. Please view my PM for details. Thanks. Regards. GLOBAL SOFT

$100 USD in 1 day
(166 Reviews)
7.5
Kikoo

Hi! we are interested in your [url removed, login to view] have the required experience. Thanks. kikoo

$100 USD in 1 day
(5 Reviews)
3.8
JanyYu

I can do it.

$100 USD in 1 day
(0 Reviews)
0.0