group by trader order by my_sum desc

Post Reply
darkover
Posts: 1574
Joined: Sat Apr 13, 2013 8:59 pm

group by trader order by my_sum desc

Post 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 = ''
Следующие ипишки жамкаю - все норм показывает
Last edited by darkover on Sat Feb 10, 2024 7:05 pm, edited 2 times in total.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: group by trader order by my_sum desc

Post by admin »

а какой там ип?
или админку и где кликать)
Don't forget to run script update
darkover
Posts: 1574
Joined: Sat Apr 13, 2013 8:59 pm

Re: group by trader order by my_sum desc

Post 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 = ''
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: group by trader order by my_sum desc

Post by admin »

не знаю, скидывайте админку - проверимс)
Don't forget to run script update
darkover
Posts: 1574
Joined: Sat Apr 13, 2013 8:59 pm

Re: group by trader order by my_sum desc

Post by darkover »

admin wrote: Sat Feb 10, 2024 7:38 pm не знаю, скидывайте админку - проверимс)
Улетело в лс
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: group by trader order by my_sum desc

Post by admin »

спасибо, fixed
Don't forget to run script update
Post Reply