Module: vote
Class: CVote
File: /var/www/unizh/data/www/unizh.com.ua/bitrix/modules/vote/classes/mysql/vote.php
Function: GetList
Line: 246
MySQL Query Error: SELECT VV.*, C.TITLE as CHANNEL_TITLE, V.*, 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.CHANNEL_ID, V.ID, count(Q.ID) QUESTIONS, IF((C.VOTE_SINGLE = 'Y'), (IF(V.ID = VV.ACTIVE_VOTE_ID, 'green', 'red')), (IF(V.ACTIVE = 'Y' AND V.DATE_START <= NOW() AND NOW() <= V.DATE_END, 'green', 'red'))) LAMP 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) LEFT JOIN ( SELECT VVV.CHANNEL_ID, MAX(VVV.ID) AS ACTIVE_VOTE_ID FROM b_vote VVV, b_vote_channel CCC WHERE VVV.CHANNEL_ID = CCC.ID AND CCC.VOTE_SINGLE='Y' AND VVV.ACTIVE = 'Y' AND NOW() >= VVV.DATE_START AND VVV.DATE_END >= NOW() AND ( (CCC.ID='2' and CCC.ID is not null) ) GROUP BY VVV.CHANNEL_ID) VV ON (VV.CHANNEL_ID = V.CHANNEL_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.CHANNEL_ID, V.ID ) VV INNER JOIN b_vote_channel C ON (C.ID = VV.CHANNEL_ID) INNER JOIN b_vote V ON (V.ID = VV.ID) ORDER BY V.ID desc [Can't open file: './Unizh_bitrix_db/b_vote_channel.frm' (errno: 24)]
|