Warning: fopen(/var/www/admin/data/www/iwomen.ru/logs/sql_error.log) [function.fopen]: failed to open stream: Отказано в доступе in /var/www/admin/data/www/iwomen.ru/classes/modules/sys_logger/Logger.class.php on line 262
SQL Error: Error writing file '/tmp/MYQLrYrn' (Errcode: 28) at /var/www/admin/data/www/iwomen.ru/classes/modules/topic/mapper/Topic.mapper.class.php line 460
Array
(
[code] => 3
[message] => Error writing file '/tmp/MYQLrYrn' (Errcode: 28)
[query] =>
SELECT
t_fast.*,
tc.*,
u.user_login as user_login,
IF(tv.topic_id IS NULL,0,1) as user_is_vote,
tv.vote_delta as user_vote_delta,
IF(tqv.topic_id IS NULL,0,1) as user_question_is_vote,
bu.is_moderator as user_is_blog_moderator,
bu.is_administrator as user_is_blog_administrator,
IF(tr.comment_count_last IS NULL,t_fast.topic_count_comment,t_fast.topic_count_comment-tr.comment_count_last) as count_comment_new,
IF(ft.topic_id IS NULL,0,1) as topic_is_favourite
FROM (
SELECT
t.*,
b.blog_title as blog_title,
b.blog_type as blog_type,
b.blog_url as blog_url,
b.user_owner_id as blog_owner_id
FROM
prefix_topic as t,
prefix_blog as b
WHERE
1=1
AND t.topic_publish = 1 AND ( t.topic_rating >= -5 ) AND b.blog_type in ('personal')
AND
t.blog_id=b.blog_id
ORDER by t.topic_date_add desc
LIMIT 0, 50
) as t_fast
JOIN prefix_user AS u ON t_fast.user_id=u.user_id
LEFT JOIN (
SELECT
topic_id,
vote_delta
FROM prefix_topic_vote
WHERE user_voter_id = -1
) AS tv ON t_fast.topic_id=tv.topic_id
LEFT JOIN (
SELECT
topic_id
FROM prefix_favourite_topic
WHERE user_id = -1
) AS ft ON t_fast.topic_id=ft.topic_id
LEFT JOIN (
SELECT
topic_id,
comment_count_last
FROM prefix_topic_read
WHERE user_id = -1
) AS tr ON t_fast.topic_id=tr.topic_id
LEFT JOIN (
SELECT
topic_id
FROM prefix_topic_question_vote
WHERE user_voter_id = -1
) AS tqv ON t_fast.topic_id=tqv.topic_id
LEFT JOIN (
SELECT
is_moderator,
is_administrator,
blog_id
FROM prefix_blog_user
WHERE user_id = -1
) AS bu ON t_fast.blog_id=bu.blog_id
JOIN prefix_topic_content AS tc ON t_fast.topic_id=tc.topic_id
order by t_fast.topic_date_add desc
;
[context] => /var/www/admin/data/www/iwomen.ru/classes/modules/topic/mapper/Topic.mapper.class.php line 460
)