Problem Running Install.sql

[Zero_Kuro]

When I try to run the install file, I get an error

Preparing...
Importing install.sql...
ERROR 1265 (01000) at line 65: Data truncated for column 'for_PlayerPlayerActions' at row 1
Finished executing script
Operation failed with exitcode 1

[Veksi8]

Same problem

[Unbelievable]

Try installing this version of hlstatsx its updated https://github.com/laam4/noxus

[Veksi8]

Try installing this version of hlstatsx its updated https://github.com/laam4/noxus

Tried but got same error idk whats wrong :/
Everything started failing when I upgraded php 5.0 to php 7.1 unfortunately.

[d3m0n1ze]

Tried but got same error idk whats wrong :/
Everything started failing when I upgraded php 5.0 to php 7.1 unfortunately.

I was able to fix the SQL error (You must unset mysql strict mode) but it won't help much because the HLSTATSX script uses "mysql" instead of "mysqli" which was depreciated in PHP 7.x. You'll most likely have to downgrade to PHP 5.x for HLSTATSX to work.

[Stresss]

I know how to fix this issue.

I am using php 7.2.10 and I had the same problem, which is caused by wrong date format on table creation.

Fix:
open install.sql with editor or sth.
search and replace all 0000-00-00 with 1000-01-01
save and exit

with ubuntu:
go inside scripts directory
then use the install.sql with
mysql -p [NAME] -u[PASSWORD] [DATABASE] < install.sql

-or-
log into mysql using
mysql -u Name -p
use dbname;
source place/to/filedir/install.sql;