Errore query complessa

[stefano3804]

Ho questo errore e non capisco perche

SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.email

                    , e.body, e.extended
                    
                FROM
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                     LEFT JOIN serendipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 0
                            LEFT JOIN serendipity_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read' 
                                       AND acl_acc.artifact_type = 'category'
                                       AND acl_acc.artifact_id   = c.categoryid 
                                      )
                    WHERE isdraft = 'false' AND e.timestamp <= '1136401878' AND     (
                                 c.categoryid IS NULL 
                                 OR ( acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL 
                                      
                                    )
                               )
                    GROUP BY e.id
                    ORDER BY timestamp DESC
                     LIMIT 6

/ The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok

Chi la capisce ?

[Insaponata]

Secondo me da qualche parte devi mettere "SET SQL_BIG_SELECTS=1" oppure "SET SQL_MAX_JOIN_SIZE=#"

[stefano3804]

si ma dov ?

[stefano3804]

l'ho messo da phpmyadmin ma nulla

[stefano3804]

non ne vuole saper
ma non ha errore perche lo stesso script in locale funziona

come MAX_JOIN_SIZE ho 100000

[stefano3804]

che devo fare per uscirne ?

[stefano3804]

up