Em Andamento

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

Please note I ahve a budget of $30 for this

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

Habilidades: PHP, Design de Sites

Ver mais: 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

Acerca do Empregador:
( 57 comentários ) Auckland, New Zealand

ID do Projeto: #118624

3 freelancers estão ofertando em média $100 para este trabalho

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 em 1 dia
(166 Comentários)
7.5
Kikoo

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

$100 USD em 1 dia
(5 Comentários)
3.8
JanyYu

I can do it.

$100 USD em 1 dia
(0 Comentários)
0.0