Windows znote search player error

[lopez65]

string(100) "SELECT SUM(`value`) AS `sum` FROM `player_storage` WHERE `key` LIKE '30___' AND `player_id`=(int)172"
(query - SQL error)
Type: select_single (select single row from database)

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'int)172' at line 1

I was looking at several posts but added a thousand tables and I can not find someone to explain.

look: nemesis.ddns.net

 

[WibbenZ]

string(100) "SELECT SUM(`value`) AS `sum` FROM `player_storage` WHERE `key` LIKE '30___' AND `player_id`=(int)172"
(query - SQL error)
Type: select_single (select single row from database)

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'int)172' at line 1

I was looking at several posts but added a thousand tables and I can not find someone to explain.

look: nemesis.ddns.net

Maybe 30___?
Try to replace it with 30

 

[lopez65]

if thanks, that's why it's hard to see it with how easy it seems

 

[WibbenZ]

if thanks, that's why it's hard to see it with how easy it seems

Did it fix it?

 

[StreamSide]

maybe its cus of mariaDb and int conversion (maybe im wrong) test w/o the int or maybe reading some mariadb books