great work so far. Thank you for your effort. We are running a phpBB 3.0 board for > 5 years using your Smartfeed MOD. Quite some of our users rely on it. Now we want to move to 3.1 and set up a test environment for that.
Testing Smartfeed 3.0.2 RC 1 I am unable to get it running. Our forum has nearly 20.000 posts in > 1000 threads, > 3000 users. We are using a copy of the original database for testing. Mysql 5.5.46, PHP 5.5.9, Apache 2.4.7.
The issue: When generating a feed URL and testing it, I get (after quite some time) an SQL error "SQL ERROR [ mysqli ] - Incorrect key file for table '/var/tmp/#sql_3a4_0.MYI'; try to repair it ". After some research I found that mysql is generating huge temporary files - and my harddrive is running out of space. So I increased the space available, but it still does not help. 30 GB of space are eaten up by temp files before SQL throws the error.
PHPmyadmin shows that this SQL query is causing the problem:
Code: Select all
SELECT f . * , t . * , p . * , u . * , tt.mark_time AS topic_mark_time, ft.mark_time AS forum_mark_time
CROSS JOIN phpbb_topics t
CROSS JOIN phpbb_posts p
CROSS JOIN phpbb_users u
LEFT JOIN phpbb_topics_track tt ON ( t.topic_id = tt.topic_id )
LEFT JOIN phpbb_forums_track ft ON ( f.forum_id = ft.forum_id )
WHERE f.forum_id = t.forum_id
AND t.topic_id = p.topic_id
AND p.poster_id = u.user_id
AND p.post_time >1451035402
IN ( 9, '17' )
AND p.post_visibility =1
ORDER BY t.topic_last_post_time DESC , p.post_time
Searching the net I found hints that the ORDER BY parameter can cause mysql to behave like mentioned when trying to order big sized data.
By the way: No matter how low I set parameters like max. number of posts in feed or time limit: As soon as only one single post would be included in the feed, I run into the problem.
Would be a great help if you could check how to solve the issue.