oscommerce product attribute mysql error


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

Please note I ahve a budget of $30 for this

Sorry in a rush so forgetting things. Payment is by escrow released on completion

Kompetens: PHP, Webbdesign

Visa mer: snapshot design, product design customers, product database design, error 0, mysql 5.1, urgent mysql, test a website asap 3, 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

Om arbetsgivaren:
( 57 omdömen ) Auckland, New Zealand

Projekt-id: #118624

3 frilansare har i genomsnitt lagt bud på $100 för detta jobb


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 inom 1 dag
(166 omdömen)

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

$100 USD inom 1 dag
(5 omdömen)

I can do it.

$100 USD inom 1 dag
(0 omdömen)