#1 2018-01-08 06:42:08


SQL Errors Post Upgrade

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/ 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/ on line 845

I have followed the instructions on and I still am not having any luck with any of the SQL statements the post states to execute.

Any help is appreciated.

Shane Baldacchino



Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate © 2002-2018 · Contact