SmartCJ Support Forum

Code: Select all

Mysql error:: 1104 (The SELECT would examine more than MAX_JOIN_SIZE rows; check                                                your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT i                                               s okay) (db_link) in query UPDATE rot_gallery_stats1 t, (SELECT gallery_id, dura                                               tion
                        FROM rot_gallery_stats1
                       WHERE duration != 0 ) t1
                           SET t.duration = t1.duration
                           WHERE t.duration = 0 and
                           t.gallery_id = t1.gallery_id. (domain.com) ....[