Hi
Started automatic upgrade to 2.9.1 from 2.8 and got the following error messages:
=== upgrade 150
Warning: [mysql error 1060] Duplicate column name 'history_id_from'
ALTER TABLE `piwigo_history_summary`
ADD COLUMN `history_id_from` int(10) unsigned default NULL,
ADD COLUMN `history_id_to` int(10) unsigned default NULL
; in (...)/include/dblayer/functions_mysqli.inc.php on line 845
Warning: [mysql error 1054] Unknown column 'summarized' in 'where clause'
SELECT
*
FROM piwigo_history
WHERE summarized = 'true'
ORDER BY id DESC
LIMIT 1
; in (...)/include/dblayer/functions_mysqli.inc.php on line 845
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in (...)/include/dblayer/functions_mysqli.inc.php:911
Stack trace:
#0 /(...)/install/db/150-database.php(47): query2array('\nSELECT\n *\n ...')
#1 /(...)/install/upgrade_2.8.0.php(109): include('/home1/antablog...')
#2 /(...)/upgrade.php(399): include('/home1/antablog...')
#3 {main}
thrown in /(...)/include/dblayer/functions_mysqli.inc.php on line 911
I am now blocked on upgrade page unable to either upgrade or return to admin. It appears to be a database error similar to other threads but more extensive. I have been forced to take the site off line. Help needed please.
Piwigo version: 2.8
PHP version: 5.4.43
MySQL version: 5.6.32
Piwigo URL: http://
Offline
Hello
As it's written "Unknown column 'summarized'" you have a missing column 'summarized' for the history table
but that column exist since 1.6.2 : [Github] Piwigo file install/upgrade_1.6.2.php@L76
you're not the first one reporting that problem but I really don't understand why since it's for 2.9.0 and the update 150, that the summarized table disappeared
to bypass the issue the issue comment the lines as mentioned in [Github] Piwigo issue #553
Offline
Hi,
I've commented out as per piwigo issue #553 and everything seems to have got back to normal and the upgrade completed. Hopefully this work around will not impact future upgrades.
Many thanks
Offline
thank you and have a good day
Offline