[BUG] Update to piwigo 14 doesn't work about docker-piwigo HOT 10 CLOSED

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

from docker-piwigo.

Going to need application/php logs at a minimum to even start trying to troubleshoot what might be happening.

from docker-piwigo.

I pasted the application logs but I realize there's nothing interesting in them. How do I get php logs?

from docker-piwigo.

PHP error log:

[10-Dec-2023 02:00:12] NOTICE: fpm is running, pid 354
[10-Dec-2023 02:00:12] NOTICE: ready to handle connections
[12-Dec-2023 08:40:15] NOTICE: Terminating ...
[12-Dec-2023 08:40:16] NOTICE: exiting, bye-bye!
[12-Dec-2023 08:40:56] NOTICE: fpm is running, pid 290
[12-Dec-2023 08:40:56] NOTICE: ready to handle connections
[12-Dec-2023 09:14:00] NOTICE: Terminating ...
[12-Dec-2023 09:14:00] NOTICE: exiting, bye-bye!
[12-Dec-2023 09:14:26] NOTICE: fpm is running, pid 288
[12-Dec-2023 09:14:26] NOTICE: ready to handle connections
[12-Dec-2023 09:48:48] NOTICE: Terminating ...
[12-Dec-2023 09:48:48] NOTICE: exiting, bye-bye!
[12-Dec-2023 09:49:56] NOTICE: fpm is running, pid 290
[12-Dec-2023 09:49:56] NOTICE: ready to handle connections
[12-Dec-2023 10:26:06] NOTICE: Terminating ...
[12-Dec-2023 10:26:06] NOTICE: exiting, bye-bye!
[12-Dec-2023 10:26:32] NOTICE: fpm is running, pid 287
[12-Dec-2023 10:26:32] NOTICE: ready to handle connections

NGINX error log:

2023/12/12 10:26:38 [error] 315#315: *3 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos."
2023/12/12 10:26:41 [error] 314#314: *9 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:26:46 [error] 314#314: *11 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos."
2023/12/12 10:27:01 [error] 314#314: *15 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos."
2023/12/12 10:27:10 [error] 314#314: *17 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '99317' for key 'PRIMARY' in /app/www/public/include/dblayer/functions_mysqli.inc.php:132
Stack trace:
#0 /app/www/public/include/dblayer/functions_mysqli.inc.php(132): mysqli->query()
#1 /app/www/public/install/db/168-database.php(16): pwg_query()
#2 /app/www/public/install/upgrade_13.0.0.php(94): include('...')
#3 /app/www/public/upgrade.php(411): include('...')
#4 {main}
thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 132" while reading response header from upstream, client: 192.168.128.1, server: _, request: "POST /upgrade.php?language=en_GB HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://photos./upgrade.php"
2023/12/12 10:27:41 [error] 314#314: *21 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:28:41 [error] 314#314: *25 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:29:42 [error] 314#314: *29 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:30:08 [error] 314#314: *33 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "HEAD /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos."
2023/12/12 10:30:41 [error] 314#314: *37 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:31:41 [error] 315#315: *41 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:32:41 [error] 315#315: *45 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:33:41 [error] 315#315: *49 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:34:41 [error] 315#315: *53 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:35:41 [error] 315#315: *57 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:36:41 [error] 315#315: *61 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:37:41 [error] 315#315: *65 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:38:41 [error] 315#315: *69 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:39:41 [error] 316#316: *73 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:40:41 [error] 316#316: *77 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:41:41 [error] 316#316: *81 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:42:41 [error] 316#316: *85 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:43:41 [error] 316#316: *89 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"
2023/12/12 10:44:41 [error] 316#316: *93 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "RUN_UPGRADE_URL" in /config/www/_data/templates_c/p6jhns^b5737c8ac2ae3123d00bf282c8cb102315a6405c_0.file.upgrade.tpl.php on line 250" while reading response header from upstream, client: 192.168.128.1, server: _, request: "GET /upgrade.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "photos.", referrer: "https://"

from docker-piwigo.

Just did a test with 13.8, upgrading to 14.0

Seems to have worked fine. Have you checked your DB container logs to make sure there's nothing awry there?

from docker-piwigo.

Weird. Nothing at all in DB container logs unfortunately.

Nothing of note in the NGINX error log from above?

from docker-piwigo.

This looks like your actual issue

2023/12/12 10:27:10 [error] 314#314: *17 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '99317' for key 'PRIMARY' in /app/www/public/include/dblayer/functions_mysqli.inc.php:132
Stack trace:
#0 /app/www/public/include/dblayer/functions_mysqli.inc.php(132): mysqli->query()
https://github.com/linuxserver/docker-piwigo/issues/1 /app/www/public/install/db/168-database.php(16): pwg_query()
https://github.com/linuxserver/docker-piwigo/pull/2 /app/www/public/install/upgrade_13.0.0.php(94): include('...')
https://github.com/linuxserver/docker-piwigo/pull/3 /app/www/public/upgrade.php(411): include('...')
https://github.com/linuxserver/docker-piwigo/pull/4 {main}
thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 132" while reading response header from upstream, client: 192.168.128.1, server: _, request: "POST /upgrade.php?language=en_GB HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "[photos](https://photos/).", referrer: "photos./upgrade.php"

from docker-piwigo.

I agree, but how do I solve this?

from docker-piwigo.

You probably need to report it to the upstream project, it looks like a failed database migration issue and not something that can be fixed at a container level.

from docker-piwigo.

Ok thanks

from docker-piwigo.