Announcement

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

baldacchino
Member
2018-01-08
1

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/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

Offline

 

Board footer

Powered by FluxBB

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