2007-06-26, 01:25 PM
In AdminCP , When I tried to Modify / Delete Templates , Expand the Default Templates. It just show:
"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 SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Query: SELECT t.tid, t.title, t.sid, s.title as settitle, t2.tid as customtid FROM nct_templates t LEFT JOIN nct_templatesets s ON (t.sid=s.sid) LEFT JOIN nct_templates t2 ON (t.title=t2.title AND t2.sid='1') WHERE t.title LIKE '%edit%' ORDER BY t.title ASC"
I really don't know where is the problem. Please help me.
"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 SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Query: SELECT t.tid, t.title, t.sid, s.title as settitle, t2.tid as customtid FROM nct_templates t LEFT JOIN nct_templatesets s ON (t.sid=s.sid) LEFT JOIN nct_templates t2 ON (t.title=t2.title AND t2.sid='1') WHERE t.title LIKE '%edit%' ORDER BY t.title ASC"
I really don't know where is the problem. Please help me.