Module: vote
Class: CVote
File: /home/admin/web/rollcenter.ru/public_html/bitrix/modules/vote/classes/mysql/vote.php
Function: GetList
Line: 416
MySQL Query Error: SELECT 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, count(Q.ID) QUESTIONS, if(V.ACTIVE='N','red', if(now()<V.DATE_START, 'red', if (now()>V.DATE_END, 'red', 'green') ) ) 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) 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 ORDER BY V.ID desc [Got error 122 from storage engine]
|