I am attempting to make a new install of Zoph 0.9.5 in a new linux machine running Kubuntu 16.04. I want to base this install off the data on another machine running Zoph 0.9.0. In the new machine I created a MySQL DB and imported the .sql from the old 0.9.0 machine. I placed a zoph.ini in the new machine at /etc. I put a fresh set of 0.9.5 files at the Apache web root from a fresh zoph-0.9.5.zip file.

I successively ran the zoph_update-0.9.1.sql and the zoph_update-0.9.2.sql on the DB from the old 0.9.0 install. When I tried to do the zoph_update-0.9.3.sql update, I got an error >> ALTER TABLE zoph_people ADD COLUMN createdby int(11) NOT NULL DEFAULT 1 Error Code: 1292. Incorrect date value: '0000-00-00' for column 'dob' at row 105.

Conclusion >> zoph_update-0.9.3.sql will not run if there is a date of '0000-00-00' for column 'dob'. I have modified the date and now the zoph_update-0.9.3.sql will run but perhaps you want to fix this so others will not have the same problem.

Ray