Page 1 of 1

group by trader order by my_sum desc

Posted: Sat Feb 10, 2024 4:10 pm
by darkover
Захожу на :
/admin/?operation=trade_stats&redir=true&td=SE
Колонка Clicks IPs, первый IP в списке жамкаю, получаю пустое модельное окно. На хоум выбивает ошибку

Code: Select all

Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your
 MySQL server version for the right syntax to use near '?@"' group by trader order by my_sum desc' at line 2 
 (select trader, SUM(num) as my_sum, 
SUM(proxy) as total_proxy from ips WHERE ip = ''
Следующие ипишки жамкаю - все норм показывает

Re: group by trader order by my_sum desc

Posted: Sat Feb 10, 2024 4:45 pm
by admin
а какой там ип?
или админку и где кликать)

Re: group by trader order by my_sum desc

Posted: Sat Feb 10, 2024 7:09 pm
by darkover
admin wrote: Sat Feb 10, 2024 4:45 pm а какой там ип?
или админку и где кликать)
upd - не первый ip, точнее он уже не первый, и в Incoming IPs тож самое на эти ip, модальное окно пустое и ошибка на морде в админке
39.128.37.95
39.154.13.56
123.164.182.39
39.149.6.215
36.129.39.22
/admin/?operation=trade&sub=stats&subsub=stats_ips&no_script=true&redir=true&action=traders&ip=36.129.39.22
Core error: Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?%_' group by trader order by my_sum desc' at line 2 (select trader, SUM(num) as my_sum, SUM(proxy) as total_proxy from ips WHERE ip = ''

Core error: Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? 8' group by trader order by my_sum desc' at line 2 (select trader, SUM(num) as my_sum, SUM(proxy) as total_proxy from ips WHERE ip = ''

Core error: Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''{??'' group by trader order by my_sum desc' at line 2 (select trader, SUM(num) as my_sum, SUM(proxy) as total_proxy from ips WHERE ip = '{

Core error: Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '??' group by trader order by my_sum desc' at line 2 (select trader, SUM(num) as my_sum, SUM(proxy) as total_proxy from ips WHERE ip = ''

Core error: Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' group by trader order by my_sum desc' at line 2 (select trader, SUM(num) as my_sum, SUM(proxy) as total_proxy from ips WHERE ip = '$

Core error: Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '??' group by trader order by my_sum desc' at line 2 (select trader, SUM(num) as my_sum, SUM(proxy) as total_proxy from ips WHERE ip = ''

Re: group by trader order by my_sum desc

Posted: Sat Feb 10, 2024 7:38 pm
by admin
не знаю, скидывайте админку - проверимс)

Re: group by trader order by my_sum desc

Posted: Sun Feb 11, 2024 11:18 am
by darkover
admin wrote: Sat Feb 10, 2024 7:38 pm не знаю, скидывайте админку - проверимс)
Улетело в лс

Re: group by trader order by my_sum desc

Posted: Sun Feb 11, 2024 12:24 pm
by admin
спасибо, fixed