Piwigo.org

macstrat · 2023-08-21 05:29:57

Hello/Hi/Greetings,

I use the piwigo hosting, adn recieved a fatal error when trying to load the site, I was doing some site maintience, moving albums around, and now i cannot access my site at all.

Error is Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/piwigo_master_13/include/functions_category.inc.php on line 549

(Copy here your environment details, found on your Piwigo page [Administration > Tools > Maintenance])

Piwigo URL: https://cardscans.piwigo.com/

plg · 2023-08-21 10:55:35

Indeed, there is a problem in the album hierarchy.

Code:

> select id, id_uppercat, uppercats from categories where id in (1216,1785);
+------+-------------+-----------+
| id   | id_uppercat | uppercats |
+------+-------------+-----------+
| 1216 |        1785 | 1785,1216 |
| 1785 |        1216 | 1785      |
+------+-------------+-----------+

Which means that album 1216 is child of 1785 and album 1785 is child of 1216 => infinite loop.

I made sure this was the only mistake in the database with this other query:

Code:

> select id, id_uppercat, uppercats from categories where   id_uppercat is not null and uppercats not like '%,%';
+------+-------------+-----------+
| id   | id_uppercat | uppercats |
+------+-------------+-----------+
| 1785 |        1216 | 1785      |
+------+-------------+-----------+
1 row in set (0.00 sec)

Fine. It seems to be the only one. I fix it manually:

Code:

> update categories set id_uppercat = null where id=1785;

You're good to go.

macstrat · 2023-08-21 14:59:24

thank you. When I was doing the albums, I had moved an album to the wrong folder, and then when i tried to move it back again it flipped out. this makes perfect sense. thank you

Piwigo.org

Announcement

#1 2023-08-21 05:29:57

Fatal Error on Hosted Site

#2 2023-08-21 10:55:35

Re: Fatal Error on Hosted Site

Code:

Code:

Code:

#3 2023-08-21 14:59:24

Re: Fatal Error on Hosted Site

Board footer