Hello Everyone,


    Piwigo 2.9.2
    Operating system: Linux
    PHP: 7.0.22-0ubuntu0.16.04.1 (Show info) [2018-01-08 05:39:25]
    MySQL: 5.7.20-0ubuntu0.16.04.1 [2018-01-08 05:39:25]
    Graphics Library: GD 2.1.1


I have upgrade from an older version (2.7) to 2.9.2 as my server is now running PHP 7.
After going through the upgrade process I am getting SQL errors when I try and re-initalise the DB

:Warning:  [mysql error 1292] Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastmodified' at row 1
ALTER TABLE piwigo_categories ORDER BY id; in /var/www/webroot/pictures/include/dblayer/functions_mysqli.inc.php on line 845

and on the site



Warning:  [mysql error 1054] Unknown column 'last_visit' in 'field list'

UPDATE piwigo_user_infos
  SET last_visit = NOW(),
      lastmodified = lastmodified
  WHERE user_id = 1
in /var/www/webroot/pictures/include/dblayer/functions_mysqli.inc.php on line 845




I have followed the instructions on http://piwigo.org/forum/viewtopic.php?id=27923 and I still am not having any luck with any of the SQL statements the post states to execute.

Any help is appreciated.

Thanks
Shane Baldacchino