Service
select m.*,
UNIX_TIMESTAMP(m.create_date) as create_date,
UNIX_TIMESTAMP(m.change_date) as change_date,
u.username,
u.user_from,
um.longitude
from market m join phpbb_users u on m.board_user_id = u.user_id
left join phpbb_map_mod_user um on u.user_id = um.user_id
where UNIX_TIMESTAMP(create_date) > 1228419911
group by m.board_user_id
order by rand()
limit 5
Got error 28 from table handler
/index.php
Could not obtain topic information
DEBUG MODE
SQL Error : 3 Error writing file '/tmp/MY7SGRfc' (Errcode: 28)
SELECT t.*, u.username, u.user_id, u.user_color, u2.username as user2, u2.user_id as id2, u2.user_color user_color2, p.post_id, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.forum_id = 1 AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND t.topic_type <> 2 ORDER BY t.topic_type DESC, t.topic_last_post_id DESC LIMIT 0, 20
Line : 509
File : viewforum.php