Installation Errors

[davidson....@edumail.vic.gov.au]

Trying to set this up on a Server 2008R2 box. I've got latest 5.3 php and MYSQL installed.

I've configured the config and database files and now get the install page come up.

However when I click Submit after entering all the necessary details, I get this error:

An Error Was Encountered

Error Number: 1364

Field 'name' doesn't have a default value

INSERT INTO school (school_id) VALUES (0)

If I try to access the site again, I get the login screen but I get a couple of additional php errors

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/login.php

Line Number: 23

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/login.php

Line Number: 35

My login details won't work either. I've checked permissions on the site directory and database and all seem to be fine. Not sure what I'm doing wrong.

[Craig A Rodway]

Hello Matthew

I think I've found the cause of this problem to be MySQL being run in strict mode.

The install script is trying to insert a nearly-empty record to begin with (with the intention to update later), but the table needs certain fields to be completed. Some installations of MySQL will allow this to proceed, while some won't.

My suggestion for you, is to update the classroombookings.sql file in the root of the classroombookings folder with a fixed version at this URL:

https://gist.github.com/craigrodway/ebad662cc6966829fb57#file-classroombookings-sql-L115-L126

You can either change just the highlighted section of SQL statements in your file with the ones in the above link, or replace the whole file - whichever is going to be easier for you. Then run the installation page again by visiting classroombookings/index.php/install.

Hope that works for you.

Craig.