Question Browse and Moderate Logs - db error

[khurtsiya]

Browse and Moderate Logs -> Statistics Grouping - Event brings DB error:

Ошибка базы данных в 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

 

[Darkwaltz4]

I have hotfixed the product file which you can download from your member area at dbtech.

You only need to upload the patched /admincp/credits_admin.php file to fix the error.

 

[khurtsiya]

Again error, but now when selecting first option in that multiselect:

Ошибка базы данных в vBulletin 3.8.4:

Invalid SQL:
SELECT COUNT(*) AS total, SUM(IF(currencyid = 1, amount, 0)) AS total_1, SUM(IF(currencyid = 1 AND u.usergroupid = 4 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_0, SUM(IF(currencyid = 1 AND u.usergroupid = 6 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_1, SUM(IF(currencyid = 1 AND u.usergroupid = 8 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_2, SUM(IF(currencyid = 1 AND u.usergroupid = 2 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_3, SUM(IF(currencyid = 1 AND u.usergroupid = 10 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_4, SUM(IF(currencyid = 1 AND u.usergroupid = 7 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_5, SUM(IF(currencyid = 1 AND u.usergroupid = 1 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_6, SUM(IF(currencyid = 1 AND u.usergroupid = 3 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_7, SUM(IF(currencyid = 1 AND u.usergroupid = 5 AND timestamp >= 1358898751 AND timestamp < 1359637190, amount, 0)) AS stats_1_8 FROM credits_transaction AS t WHERE status IN (1, 2) AND timestamp >= 1358898720 AND timestamp <= 1359637200;

Ошибка MySQL : Unknown column 'u.usergroupid' in 'field list'
Номер ошибки : 1054
Дата запроса : Thursday, January 31st 2013 @ 01:00:03 PM
Дата ошибки : Thursday, January 31st 2013 @ 01:00:03 PM
Скрипт : Âõîä - GRFOZ.COM | Ãëàâíûé Ðóññêîÿçû÷íûé Ôîðóì î Çàðàáîòêå - vBulletin Ïàíåëü àäìèíèñòðàòîðà
Реферер : Âõîä - GRFOZ.COM | Ãëàâíûé Ðóññêîÿçû÷íûé Ôîðóì î Çàðàáîòêå - vBulletin Ïàíåëü àäìèíèñòðàòîðà
IP адрес : 46.33.232.134
Имя пользователя : GRFOZ.COM
Имя класса : vB_Database
Версия MySQL : 5.5.29-0ubuntu0.12.04.1

 

[Darkwaltz4]

Repeat the steps from my previous post again, to get the hotfix with the patch for that one too

 

[khurtsiya]

Thanks!

 

[khurtsiya]

New error.

When clicking on username.

Ошибка базы данных в vBulletin 3.8.4:

Invalid SQL:
SELECT COUNT(*) AS total, SUM(IF(currencyid = 1, amount, 0)) AS total_1, SUM(IF(currencyid = 1 AND timestamp >= 1359053912 AND timestamp < 1359792985, amount, 0)) AS stats_1_0 FROM credits_transaction AS t LEFT JOIN user AS u ON (t.userid = u.userid) WHERE status IN (1, 2) AND timestamp >= 1357583460 AND timestamp <= 1359793530 AND userid = 1;

Ошибка MySQL : Column 'userid' in where clause is ambiguous
Номер ошибки : 1052
Дата запроса : Saturday, February 2nd 2013 @ 08:25:30 AM
Дата ошибки : Saturday, February 2nd 2013 @ 08:25:30 AM
Скрипт : Âõîä - GRFOZ.COM | Ãëàâíûé Ðóññêîÿçû÷íûé Ôîðóì î Çàðàáîòêå - vBulletin Ïàíåëü àäìèíèñòðàòîðà
Реферер : Âõîä - GRFOZ.COM | Ãëàâíûé Ðóññêîÿçû÷íûé Ôîðóì î Çàðàáîòêå - vBulletin Ïàíåëü àäìèíèñòðàòîðà
IP адрес : 46.33.232.134
Имя пользователя : GRFOZ.COM
Имя класса : vB_Database
Версия MySQL : 5.5.29-0ubuntu0.12.04.1

 

[Fillip H.]

I can't reproduce that, but I've added a potential workaround to /admincp/credits_admin.php

 

[khurtsiya]

Not helped...

 

[Fillip H.]

Then I'll need you to re-send me FTP and AdminCP details with a link to the page where this issue can be reproduced

 

[khurtsiya]

Sent via PM