Jump to content

Installation issue (digitalocean + serverpilot)


Maverick
 Share

Recommended Posts

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
Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

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.

  • Like 2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...