В работе

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

Квалификация: PHP, Дизайн сайтов

Показать больше 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

О работодателе:
( 57 отзыв(-а, -ов) ) Auckland, New Zealand

ID проекта: #118624

3 фрилансеров(-а) в среднем готовы выполнить эту работу за $100

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 за 1 день
(166 отзывов(-а))
7.5
Kikoo

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

$100 USD за 1 день
(5 отзывов(-а))
3.8
JanyYu

I can do it.

$100 USD за 1 день
(0 отзывов(-а))
0.0