Наша деятельность
Элемент не найден
Module: vote
Class: CVote
File: /var/www/bitrix/data/www/acadprava.ru/bitrix/modules/vote/classes/mysql/vote.php
Function: GetList
Line: 209
MySQL Query Error:
SELECT VV.*, C.TITLE as CHANNEL_TITLE, C.ACTIVE as CHANNEL_ACTIVE,
C.HIDDEN as CHANNEL_HIDDEN, V.*,
CASE WHEN (C.ACTIVE = 'Y' AND V.ACTIVE = 'Y' AND V.DATE_START <= NOW() AND NOW() <= V.DATE_END)
THEN IF (C.VOTE_SINGLE != 'Y', 'green', 'yellow')
ELSE 'red'
END AS LAMP,
DATE_FORMAT(V.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') TIMESTAMP_X,
DATE_FORMAT(V.DATE_START, '%d.%m.%Y %H:%i:%s') DATE_START,
DATE_FORMAT(V.DATE_END, '%d.%m.%Y %H:%i:%s') DATE_END,
UNIX_TIMESTAMP(V.DATE_END) - UNIX_TIMESTAMP(V.DATE_START) PERIOD
FROM (
SELECT V.ID, COUNT(Q.ID) QUESTIONS
FROM b_vote V
INNER JOIN b_vote_channel C ON (C.ID=V.CHANNEL_ID)
LEFT JOIN b_vote_question Q ON (Q.VOTE_ID=V.ID)
WHERE (1=1
AND
(
(
(V.CHANNEL_ID='2' and V.CHANNEL_ID is not null)
)
)
AND
(
(V.ACTIVE='Y' and now()>=V.DATE_START and now()<=V.DATE_END)
)
)
GROUP BY V.ID
) VV
INNER JOIN b_vote V ON (V.ID = VV.ID)
INNER JOIN b_vote_channel C ON (C.ID = V.CHANNEL_ID) ORDER BY V.ID desc [Disk full (/var/tmp/#sql_4d89_1); waiting for someone to free some space...]
|