Hi All
I just installed Piwigo yesterday and did allot of installation of the recommended plugins
Everything was running fine and I have been transferring images during the night
This morning I did a synch and it froze, after 1 hour I rebooted the DB & Piwigo and the server didn't come up again?
I then went to my backup, and I could see I had one from 4 a clock night time
Restores the Piwigo to see if that would help it didn't...
I then restored the MariaDB and still the same
Now I am relucted to start over again if its "so fragile" only had 5-600 images uploaded
Any input or some guide to find out what broke Piwigo?
It was so fast and so impressive, would be sad to abended this great tool!
Environment detail:
Styresystem: Linux
PHP: 7.3.24 (Vis info) [2020-11-08 22:22:00]
MySQL: 5.5.5-10.4.16-MariaDB-1:10.4.16+maria~bionic-log [2020-11-08 22:22:00]
Grafikbibliotek: ImageMagick 7.0.10-25
Offline
turn on logging to see what went wrong
$conf['enable_i_log'] = true;
Offline
Thanks so much for replying to my post!
Is this setting true in some PHP conf file?
I am still trying to rollback and I got a little further....
Maybe to many pictures trying to do the synch...
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /config/www/gallery/admin/site_update.php on line 537
Offline
Okay I find that I could ectend the PHP memeory limit here:
\dockers\piwigo\php\php-local.ini
Adding:
; Edit this file to override php.ini directives and restart the container
date.timezone = Europe/Paris
memory_limit=1024M
And now it can synch again!
Offline
Update now I got further... changes some filenames all Green and then tried the sync
I got a : 504 Gateway Time-out
And a new gallery called temp? with some of the pictures?
Is this created by Piwigo before placing them in the correct gallery?
Right now I am just uploading all my pictures to the:
/config/www/gallery/galleries/ internal docker path --> Photos/
Extending the PHP memory did help anyway to extend the timeout value?
Offline
Release 1.7.0 of PhpWebGallery turn off this restriction displaying an intermediate page before fateful max_execution_time. This page will be reloaded (after many seconds) until file listing.xml is complete.
$conf['max_execution_time'] = (5*ini_get('max_execution_time'))/6;
It's maximum time between the script start and the intermediate page display.
Default value is 5/6 of server max execution time.
It SHOULD NOT be modified without assking for advice.
It SHOULD be part of server time.
It MUST NOT be equal to 0.
Ok I am asking for advice :-)
Offline
You probably need to increase the PHP max_execution_time value, either in your host's php.ini or Apache config's php_value max_execution_time, or even in .htaccess of your Piwigo directory if your setup allows to fiddle with it there.
Offline
Yes I found the PHP file in the docker path and set it to 300 sec.
Here for other people running docker on Unraid: \appdata\piwigo\php\php-local.ini adding this line:
memory_limit=1024M
max_execution_time=300
And then I got this new error:
arning: [mysql error 1062] Duplicate entry '293' for key 'PRIMARY'
INSERT INTO `piwigo_categories`
(`id`,`dir`,`name`,`site_id`,`id_uppercat`,`uppercats`,`commentable`,`visible`,`status`,`rank`,`global_rank`)
VALUES('293','2020-11','2020-11','1','285','32,285,293','true','true','private','8','7.18.8')
, ('294','2020-10','2020-10','1','285','32,285,294','true','true','private','9','7.18.9')
, ('295','2020-09','2020-09','1','285','32,285,295','true','true','private','10','7.18.10')
, ('296','2020-08','2020-08','1','285','32,285,296','true','true','private','11','7.18.11') in /config/www/gallery/include/dblayer/functions_mysqli.inc.php on line 856
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 4
SELECT id
FROM piwigo_images
WHERE storage_category_id IN (
)
; in /config/www/gallery/include/dblayer/functions_mysqli.inc.php on line 856
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /config/www/gallery/include/dblayer/functions_mysqli.inc.php:917 Stack trace: #0 /config/www/gallery/admin/include/functions.php(71): query2array('\nSELECT id\n FR...', NULL, 'id') #1 /config/www/gallery/admin/site_update.php(445): delete_categories(Array) #2 /config/www/gallery/admin.php(309): include('/config/www/gal...') #3 {main} thrown in /config/www/gallery/include/dblayer/functions_mysqli.inc.php on line 917
Offline
Keep getting a timeout even with a PHP set to 300sec = 5min
I was trying to move away from my Synology DS Photo db it has +120K Pictures with videoes
And now I am stuck doing Synch that keeps timing out?
I even tried doing a year by year synch in Piwigo but that also timed out?
Please let me know if Piwigo isn't built for this kind of photo album size!
Because with multiple devices this will just keep getting bigger :-)
Offline