Raised This Month: $12 Target: $400
 3% 

Problem Running Install.sql


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Zero_Kuro
Junior Member
Join Date: Dec 2015
Old 02-18-2017 , 18:43   Problem Running Install.sql
Reply With Quote #1

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
Zero_Kuro is offline
Veksi8
Junior Member
Join Date: Apr 2017
Old 04-12-2017 , 04:47   Re: Problem Running Install.sql
Reply With Quote #2

Same problem
Veksi8 is offline
Unbelievable
Senior Member
Join Date: Jan 2016
Old 04-12-2017 , 17:55   Re: Problem Running Install.sql
Reply With Quote #3

Try installing this version of hlstatsx its updated https://github.com/laam4/noxus
__________________
Unbelievable is offline
Veksi8
Junior Member
Join Date: Apr 2017
Old 04-12-2017 , 18:14   Re: Problem Running Install.sql
Reply With Quote #4

Quote:
Originally Posted by Unbelievable View Post
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.
Veksi8 is offline
d3m0n1ze
Junior Member
Join Date: Oct 2011
Location: CA
Old 04-16-2017 , 23:50   Re: Problem Running Install.sql
Reply With Quote #5

Quote:
Originally Posted by Veksi8 View Post
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.
d3m0n1ze is offline
Stresss
Junior Member
Join Date: Apr 2016
Old 01-03-2019 , 13:50   Re: Problem Running Install.sql
Reply With Quote #6

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;
Stresss is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:22.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode