je rentre du boulot, je vais sur mon fofo et
Erreur générale
j'ai rien fait, ce matin avant de partir au taf tout était encore correct
voila l'erreur
code : Tout sélectionner
SQL ERROR [ mysqli ]
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 is okay [1104]
SQL
SELECT t.topic_id, t.topic_last_post_time, tt.mark_time as topic_mark_time, ft.mark_time as forum_mark_time FROM (phpbb_topics t) LEFT JOIN phpbb_topics_track tt ON (tt.user_id = 54 AND t.topic_id = tt.topic_id) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 54 AND t.forum_id = ft.forum_id) WHERE t.topic_last_post_time > 1609001909 AND ( (tt.mark_time IS NOT NULL AND t.topic_last_post_time > tt.mark_time) OR (tt.mark_time IS NULL AND ft.mark_time IS NOT NULL AND t.topic_last_post_time > ft.mark_time) OR (tt.mark_time IS NULL AND ft.mark_time IS NULL) ) AND t.topic_id NOT IN ('10', '18', '287', '290', '291', '292', '293', '286', '289', '288', '294', '298', '297') AND ((t.forum_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '20', '21', '22') OR (t.topic_visibility = 1 AND 1=0))) ORDER BY t.topic_last_post_time DESC, t.topic_last_post_id DESC LIMIT 25
mais l'erreur reste
