**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
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