Discuz! info: MySQL Query Error
Time: 2012-5-27 9:35am
Script: /viewthread.php
SQL: SELECT * FROM [Table]posts AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(pid) FROM [Table]posts)-(SELECT MIN(pid) FROM [Table]posts))+(SELECT MIN(pid) FROM [Table]posts)) AS pid) AS t2
WHERE t1.pid >= t2.pid AND t1.first = 1 AND t1.authorid='4' AND t1.fid='21' AND tid!='23439' ORDER BY t1.pid LIMIT 20
Error: Out of memory (Needed 1677720 bytes)
Errno.: 5