|
29
|
30
|
1
|
2
|
3
|
4
|
5
|
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
|
27
|
28
|
29
|
30
|
31
|
1
|
2
|
Module: vote
Class: CVote
File: /home/bitrix/www/bitrix/modules/vote/classes/mysql/vote.php
Function: GetList
Line: 208
MySQL Query Error:
SELECT VV.*, C.TITLE as CHANNEL_TITLE, C.ACTIVE as CHANNEL_ACTIVE,
C.HIDDEN as CHANNEL_HIDDEN, V.*, V.KEEP_IP_SEC as DELAY, 'S' as DELAY_TYPE,
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='1' 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 [[1] Can't create/write to file '/tmp/#sql_3ec3_1.MAI' (Errcode: 28)]
DB query error.
Please try later.
|
|
