In Bearbeitung

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

Fähigkeiten: PHP, Webdesign

Mehr darüber 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

Über den Arbeitgeber:
( 57 Bewertungen ) Auckland, New Zealand

Projekt-ID: #118624

3 Freelancer bieten im Durchschnitt $100 für diesen Job


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 Tag
(166 Bewertungen)

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

$100 USD in 1 Tag
(5 Bewertungen)

I can do it.

$100 USD in 1 Tag
(0 Bewertungen)