AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   HLstatsX:CE (https://forums.alliedmods.net/forumdisplay.php?f=156)
-   -   Problem Running Install.sql (https://forums.alliedmods.net/showthread.php?t=294051)

Zero_Kuro 02-18-2017 18:43

Problem Running Install.sql
 
When I try to run the install file, I get an error

Code:

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 04-12-2017 04:47

Re: Problem Running Install.sql
 
Same problem

Unbelievable 04-12-2017 17:55

Re: Problem Running Install.sql
 
Try installing this version of hlstatsx its updated https://github.com/laam4/noxus

Veksi8 04-12-2017 18:14

Re: Problem Running Install.sql
 
Quote:

Originally Posted by Unbelievable (Post 2511642)
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 04-16-2017 23:50

Re: Problem Running Install.sql
 
Quote:

Originally Posted by Veksi8 (Post 2511650)
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 01-03-2019 13:50

Re: Problem Running Install.sql
 
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;


All times are GMT -4. The time now is 11:09.

Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.