Devam Ediyor

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

Beceriler: PHP, Web Sitesi Tasarımı

Daha fazlasını görün: 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

İşveren Hakkında:
( 57 değerlendirme ) Auckland, New Zealand

Proje NO: #118624

3 freelancers are bidding on average $100 for this 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

1 gün içinde 100$ USD
(166 Değerlendirme)

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

1 gün içinde 100$ USD
(5 Değerlendirme)

I can do it.

1 gün içinde 100$ USD
(0 Değerlendirme)