View Single Post
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