Installation issue (digitalocean + serverpilot)

[Maverick]

Hi there guys, 

I wonder if anyone had ever an issue like this with installation

I was about to check something out quickly so I've set up a digitalocean with ubuntu 16 droplet and then connected it to servepilot where I made a database. 

So far so good but when I try to install processwire I get this

Test Database and Save Configuration

•  Database connection successful to pw2
•  Saved configuration to ./site/config.php
•  SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created'
•  SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created'
•  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pw2.modules' doesn't exist
•  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pw2.modules' doesn't exist
•  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pw2.modules' doesn't exist
•  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pw2.modules' doesn't exist

[Sergio]

Are you doing a fresh install? Tell us more.

[Maverick]

Yes completly fresh install, fresh database, standaard template 

edit

Im not using any domain though, so it uses IP instead but I think it shouldn't matter, should it?

[LostKobrakai]

Take a look at those: 

Mysql 5.7 changed the default value options for date fields. 

[Robin S]

FYI: there is a GitHub issue open for this problem.

[Maverick]

Not sure what it was, but

1. Version 3 installed without problems

2. Restart helped installation of 2.7

3. I tried to use php 5.5 5.6 and 7 (no difference in working, but 7 gives better performance)

[Jason Huck]

In case anyone finds this thread because they're deploying a project started in PW2.7 or older to a ServerPilot-managed container (in which case, just updating the schema isn't sufficient, as many records may have been created with invalid values), ServerPilot recommends creating a separate .cnf file to disable sql strict mode:

https://serverpilot.io/community/articles/how-to-disable-strict-mode-in-mysql-5-7.html

Don't just copy and paste that configuration, though. The specific items that need to be removed are NO_ZERO_IN_DATE and NO_ZERO_DATE.

Creating a separate .cnf file for your customizations will avoid them being overwritten by automated ServerPilot updates.