Browse and Moderate Logs -> Statistics Grouping - Event brings DB error:
![Screenshot from 2013-01-26 22:32:12.png Screenshot from 2013-01-26 22:32:12.png](https://www.dragonbyte-tech.com/data/attachments/2/2700-16c31c6c18d9bd9eb4d505d1e1e95b85.jpg)
![Screenshot from 2013-01-26 22:32:26.png Screenshot from 2013-01-26 22:32:26.png](https://www.dragonbyte-tech.com/data/attachments/2/2701-f50b500e9950133de6ea983b065617fd.jpg)
Ошибка базы данных в vBulletin 3.8.4:
Invalid SQL:
SELECT COUNT(*) AS total, SUM(IF(currencyid = 1, amount, 0)) AS total_1, SUM(IF(currencyid = 1 AND t.eventid = 1 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_0, SUM(IF(currencyid = 1 AND t.eventid = 2 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_1, SUM(IF(currencyid = 1 AND t.eventid = 3 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_2, SUM(IF(currencyid = 1 AND t.eventid = 4 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_3, SUM(IF(currencyid = 1 AND t.eventid = 5 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_4, SUM(IF(currencyid = 1 AND t.eventid = 6 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_5, SUM(IF(currencyid = 1 AND t.eventid = 7 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_6, SUM(IF(currencyid = 1 AND t.eventid = 8 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_7, SUM(IF(currencyid = 1 AND t.eventid = 9 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_8, SUM(IF(currencyid = 1 AND t.eventid = 10 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_9, SUM(IF(currencyid = 1 AND t.eventid = 11 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_10, SUM(IF(currencyid = 1 AND t.eventid = 12 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_11, SUM(IF(currencyid = 1 AND t.eventid = 13 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_12, SUM(IF(currencyid = 1 AND t.eventid = 14 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_13, SUM(IF(currencyid = 1 AND t.eventid = 15 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_14, SUM(IF(currencyid = 1 AND t.eventid = 16 AND timestamp >= 1358635500 AND timestamp < 1359232274, amount, 0)) AS stats_1_15 FROM credits_transaction WHERE status IN (1, 2) AND timestamp >= 1358635500 AND timestamp <= 1359232320;
Ошибка MySQL : Unknown column 't.eventid' in 'field list'
Номер ошибки : 1054
Дата запроса : Saturday, January 26th 2013 @ 08:33:14 PM
Дата ошибки : Saturday, January 26th 2013 @ 08:33:14 PM
Скрипт : Âõîä - GRFOZ.COM | Ãëàâíûé Ðóññêîÿçû÷íûé Ôîðóì î Çàðàáîòêå - vBulletin Ïàíåëü àäìèíèñòðàòîðà
Реферер : Âõîä - GRFOZ.COM | Ãëàâíûé Ðóññêîÿçû÷íûé Ôîðóì î Çàðàáîòêå - vBulletin Ïàíåëü àäìèíèñòðàòîðà
IP адрес : 46.33.232.134
Имя пользователя : GRFOZ.COM
Имя класса : vB_Database
Версия MySQL : 5.5.29-0ubuntu0.12.04.1
![Screenshot from 2013-01-26 22:32:12.png Screenshot from 2013-01-26 22:32:12.png](https://www.dragonbyte-tech.com/data/attachments/2/2700-16c31c6c18d9bd9eb4d505d1e1e95b85.jpg)
![Screenshot from 2013-01-26 22:32:26.png Screenshot from 2013-01-26 22:32:26.png](https://www.dragonbyte-tech.com/data/attachments/2/2701-f50b500e9950133de6ea983b065617fd.jpg)