Piwigo.org

nerdnils · 2024-10-28 05:39:16

Hi there,

I am really trying to update to 15.0. But after initialising it, it did not continue after "=== upgrade 173".
When returning, it shows the update screen again https://piwigo.org/plugins/piwigo-piwig … mage-3.jpg only with from 14.0.0 to 15.0.0 (I swear I had 14.5.0 before) and when clicking on the upgrade, it just shows a white screen and the text:
=== upgrade 173

Nothing else happens, no reload not anything. Further analyzing shows the server returns http 500 in the background when delivering that text.

So I tried to manually update it using https://piwigo.org/guides/update/manual but this changes absolutely nothing. I can not get back into my installation and it stays in that update mode forever.

How to fix my installation?

Last edited by nerdnils (2024-10-28 17:46:44)

plg · 2024-10-28 10:14:46

Hi nerdnils,

We need you to go in your database manager and tell us what's the last lines in your piwigo_upgrade table.

Then we also need to see the structure of your piwigo_history table: what type is the "IP" column?

nerdnils · 2024-10-28 16:42:55

Thank you for looking into it plg!
I don't own a database manager, but I guess the queries directly in mariadb-shell suffice :)

"IP" is a varchar(15)

MariaDB [piwigo]> DESCRIBE piwigo_history;
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| date | date | NO | | 1970-01-01 | |
| time | time | NO | | 00:00:00 | |
| user_id | mediumint(8) unsigned | NO | | 0 | |
| IP | varchar(15) | NO | | | |
| section | enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats','most_commented','add_photos','collections','memories-1-year-ago','additional_page','edit_photos','download') | YES | | NULL | |
| category_id | smallint(5) | YES | | NULL | |
| search_id | int(10) unsigned | YES | | NULL | |
| tag_ids | varchar(50) | YES | | NULL | |
| image_id | mediumint(8) | YES | | NULL | |
| image_type | enum('picture','high','other') | YES | | NULL | |
| format_id | int(11) unsigned | YES | | NULL | |
| auth_key_id | int(11) unsigned | YES | | NULL | |
| is_slideshow | enum('true','false') | NO | | false | |
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+------------+----------------+
14 rows in set (0,002 sec)

Last lines in piwigo_upgrade according to 'SELECT * FROM piwigo_upgrade ORDER BY applied;'

| 162 | 2021-11-14 11:32:05 | [migration from 11.0.0 to 12.1.0, 0.008 s] change activity.performed_by for logout |
| 161 | 2021-11-14 11:32:05 | [migration from 11.0.0 to 12.1.0, 0.003 s] remove doubled activities on tag addition |
| 160 | 2021-11-14 11:32:05 | [migration from 11.0.0 to 12.1.0, 0.007 s] add lounge table |
| 163 | 2022-11-19 15:02:31 | [migration from 12.0.0 to 13.2.0, 0.011 s] add user_infos.preferences |
| 164 | 2022-11-19 15:02:32 | [migration from 12.0.0 to 13.2.0, 0.738 s] Create dedicated user agent column for activity. |
| 167 | 2024-01-05 17:38:57 | [migration from 13.0.0 to 14.1.0, 0.003 s] add config parameters to display "search in this set" action and button |
| 166 | 2024-01-05 17:38:57 | [migration from 13.0.0 to 14.1.0, 0.007 s] Create new columns for search (search_uuid, created_on, user_idx, forked_from). |
| 165 | 2024-01-05 17:38:57 | [migration from 13.0.0 to 14.1.0, 0.003 s] Add more options to email_admin_on_new_user |
| 168 | 2024-01-05 17:38:58 | [migration from 13.0.0 to 14.1.0, 0.070 s] Create new column search_id in visits history table. |
| 169 | 2024-01-05 17:38:58 | [migration from 13.0.0 to 14.1.0, 0.009 s] Delete old column search.last_seen, never really used. |
| 170 | 2024-01-05 17:38:58 | [migration from 13.0.0 to 14.1.0, 0.002 s] add config parameter to handle duplicate on upload |
| 171 | 2024-10-27 09:25:26 | [migration from 14.0.0 to 15.0.0, 0.002 s] convert file configuration setting webmaster_id to database |
| 172 | 2024-10-27 09:25:26 | [migration from 14.0.0 to 15.0.0, 0.018 s] reduce sessions.id length to 50 chars |
+-----+---------------------+----------------------------------------------------------------------------------------------------------------------------+

Please let me know if you need any further information :)

Last edited by nerdnils (2024-10-28 16:45:29)

plg · 2024-10-28 17:07:11

In upgrade 173, Piwigo tries to change the type of column IP from varchar(15) to char(39. Can you try to manually perform:

Code:

ALTER TABLE `piwigo_history` CHANGE `IP` `IP` char(39) NOT NULL default '';

nerdnils · 2024-10-28 17:43:33

MariaDB [piwigo]> ALTER TABLE `piwigo_history` CHANGE `IP` `IP` char(39) NOT NULL default '';
ERROR 1194 (HY000): Table 'piwigo_history' is marked as crashed and should be repaired

so... Roger that!

$ mysqlcheck -uroot -p --repair --all-databases

Again:
MariaDB [piwigo]> ALTER TABLE `piwigo_history` CHANGE `IP` `IP` char(39) NOT NULL default '';
Query OK, 8426 rows affected (0,072 sec)
Records: 8426 Duplicates: 0 Warnings: 0

Webpage still shows upgrade... but the update runs fine this time! Fixed. Some extensions seem not to work (yet) but that is to be expected after updating

Thanks a log plg!

plg · 2024-10-28 18:49:41

Perfect. Nothing to fix in Piwigo :-D

Piwigo.org

Announcement

#1 2024-10-28 05:39:16

[solved] Update to 15.0 impossible

#2 2024-10-28 10:14:46

Re: [solved] Update to 15.0 impossible

#3 2024-10-28 16:42:55

Re: [solved] Update to 15.0 impossible

#4 2024-10-28 17:07:11

Re: [solved] Update to 15.0 impossible

Code:

#5 2024-10-28 17:43:33

Re: [solved] Update to 15.0 impossible

#6 2024-10-28 18:49:41

Re: [solved] Update to 15.0 impossible

Board footer