Announcement

#1 2017-07-21 14:39:37

Davids
Member
Basingstoke, UK
2010-02-04
72

[resolved] Fatal error during upgrade from 2.8 to 2.9.1

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

 

#2 2017-07-31 05:12:33

flop25
Piwigo Team
2006-07-06
7037

Re: [resolved] Fatal error during upgrade from 2.8 to 2.9.1

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2017-07-31 17:36:50

Davids
Member
Basingstoke, UK
2010-02-04
72

Re: [resolved] Fatal error during upgrade from 2.8 to 2.9.1

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

 

#4 2017-07-31 17:53:38

flop25
Piwigo Team
2006-07-06
7037

Re: [resolved] Fatal error during upgrade from 2.8 to 2.9.1

thank you and have a good day


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact