Hello/Hi/Greetings,

I was upgrading my server to php v7.3 and so i decided to upgrade piwigo to the latest available 2.10.2 (it was needed else i will not work with php v7.3).

I had previously cloned the same VM, DB and filesystem and upgraded piwigo to v2.10 about one month ago, with no error and no problems, but now when i repeated the operations on another clone it upgraded without errors, but then it gives always

Warning:  [mysql error 1054] Unknown column 'format_id' in 'field list'

INSERT INTO piwigo_history
  (
    date,
    time,
    user_id,
    IP,
    section,
    category_id,
    image_id,
    image_type,
    format_id,
    auth_key_id,
    tag_ids
  )
  VALUES
  (
    CURRENT_DATE,
    CURRENT_TIME,
    2,
    '10.15.66.22',
    'categories',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  )
; in /XXXXXXX/include/dblayer/functions_mysqli.inc.php on line 856

In the httpd log i got this error

Apr 21 18:44:17 VMname httpd-VMname[3004]: [proxy_fcgi:error] [pid 3010] [cli
ent 10.15.66.22:51368] AH01071: Got error 'PHP message: PHP Warning:  [mysql error 1878] Temporary fil
e write failure.\n\nALTER TABLE `piwigo_history`\n  ADD COLUMN `format_id` int(11) unsigned DEFAULT NU
LL\n; in /XXXX/include/dblayer/functions_mysqli.inc.php on l
ine 856PHP message: PHP Warning:  [mysql error 1878] Temporary file write failure.\n\nALTER TABLE `piw
igo_history`\n  ADD COLUMN `auth_key_id` int(11) unsigned DEFAULT NULL\n; in /XXXX/include/dblayer/functions_mysqli.inc.php on line 856', referer: https://VMname/immagini/upgrade.php?language=it_IT

So i tried to give the command again

but mysql gives:

mysql> ALTER TABLE  piwigo_history  ADD COLUMN format_id int(11) unsigned DEFAULT NULL;
ERROR 1034 (HY000): Incorrect key file for table 'piwigo_history'; try to repair it
mysql>

i tried to repair and i got this

mysql> repair table piwigo_history;
+----------------------------------+--------+----------+---------------------------------------------------------+
| Table                            | Op     | Msg_type | Msg_text                                                |
+----------------------------------+--------+----------+---------------------------------------------------------+
| infn_new_immagini.piwigo_history | repair | note     | The storage engine for the table doesn't support repair |
+----------------------------------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

Latest 10 upgrades:

mysql> select * from piwigo_upgrade order by applied desc limit 10;
+-----+---------------------+--------------------------------------------------------------------------------------------------------------+
| id  | applied             | description                                                                                                  |
+-----+---------------------+--------------------------------------------------------------------------------------------------------------+
| 156 | 2020-04-21 18:44:16 | [migration from 2.9.0 to 2.10.2, 0.004 s] bug fixing, change column type for activity.occured_on             |
| 155 | 2020-04-21 18:44:16 | [migration from 2.9.0 to 2.10.2, 0.030 s] add columns session_idx+ip_address in activity table               |
| 154 | 2020-04-21 18:44:16 | [migration from 2.9.0 to 2.10.2, 0.015 s] add activity table                                                 |
| 153 | 2020-04-21 18:44:16 | [migration from 2.9.0 to 2.10.2, 0.003 s] Show date period of an album                                       |
| 152 | 2020-04-21 18:44:16 | [migration from 2.8.0 to 2.10.2, 84.403 s] add 5 parameters to show/hide icons (edit/caddie/repressentative) |
| 150 | 2020-04-21 18:42:52 | [migration from 2.8.0 to 2.10.2, 0.023 s] add history_id_from+history_id_to in history_summary table         |
| 148 | 2020-04-21 18:42:52 | [migration from 2.7.0 to 2.10.2, 15.227 s] add auth_key_id in history table                                  |
| 149 | 2020-04-21 18:42:52 | [migration from 2.8.0 to 2.10.2, 0.031 s] add last_visit+last_visit_from_history in user_infos table         |
| 151 | 2020-04-21 18:42:52 | [migration from 2.8.0 to 2.10.2, 0.004 s] add "picture_sizes_icon" and "index_sizes_icon" parameters         |
| 146 | 2020-04-21 18:42:37 | [migration from 2.7.0 to 2.10.2, 16.292 s] add format_id in history table                                    |
+-----+---------------------+--------------------------------------------------------------------------------------------------------------+
10 rows in set (0.00 sec)

the DB is on a Percona Xtradb Galera Cluster.

How can i recover from this error ?

thanks in advance

Claudio

Piwigo version 2.10.2
Php v7.3.16
Mysql v5.6.46-86

Last edited by soprano (2020-04-21 19:17:44)