Hi phantomracer,

Can you go in your database (with PhpMyAdmin or equivalent) and tell us your result for these SQL queries:

select * from piwigo_config where param = 'piwigo_db_version';

select * from piwigo_upgrade order by applied desc limit 5;

and what happens when you go on upgrade.php with your web browser?

I think the error says what the problem is. Just how to fix it... there is no column "Format_id".

Is the error in the program or the database table?


Field    Type    Null    Key    Default    Extra
id    int(10) unsigned    NO    PRI    NULL    auto_increment
date    date    NO         0000-00-00    
time    time    NO         00:00:00    
user_id    mediumint(8) unsigned    NO         0    
IP    varchar(15)    NO              
section    enum('categories','tags','search','list','favorite...    YES         NULL    
category_id    smallint(5)    YES         NULL    
tag_ids    varchar(50)    YES         NULL    
image_id    mediumint(8)    YES         NULL    
summarized    enum('true','false')    YES    MUL    false    
image_type    enum('picture','high','other')    YES         NULL

Actually, you should see in table piwigo_upgrade the upgrade 145 to 148. In upgrade 146, we add piwigo_history.format_id new column.

* open files 145 to 148 in install/db
* check what has been done in the database

You also need to check that changes in other upgrade scripts were applied (I mean 145, 146, 147 and 148)

phantomracer wrote:

seems to have fixed the problem.  of course it makes me wonder if anything else has failed to execute during the upgrades over the years.

If that was the case, you would have many other problems. You should consider past upgrades were fine :-)

Moving from Debian 6 to Ubuntu 16.04 and upgrading fron Piwigo 2.5.7 to 2.8.3 I had same few errors like this and simple pasting of ALTER query didn't work.

Looking around I found that post, correlated to my issue:
http://piwigo.org/forum/viewtopic.php?id=25158

After trying (but fail) to disable STRICT_TRANS_TABLES I resolved typing:

ALTER TABLE `piwigo_history` CHANGE `date` `date` DATE NULL DEFAULT NULL;

then successfully was able to insert

ALTER TABLE piwigo_history ADD COLUMN format_id int(11) unsigned DEFAULT NULL;
ALTER TABLE piwigo_history ADD COLUMN `auth_key_id` int(11) unsigned DEFAULT NULL;

Regards,
Mateusz

flop25 wrote:

but we are trying hard to comply with that Strict mode now by default on mysql 5.7

are we? (not me, actually ;-)