Announcement

#1 2020-11-09 10:36:55

casperse
Member
2020-11-08
12

Trouble shooting dead website?

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

 

#2 2020-11-09 20:34:05

executive
Member
2017-08-16
1214

Re: Trouble shooting dead website?

turn on logging to see what went wrong

$conf['enable_i_log'] = true;

Offline

 

#3 2020-11-10 09:34:45

casperse
Member
2020-11-08
12

Re: Trouble shooting dead website?

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

 

#4 2020-11-10 10:51:33

casperse
Member
2020-11-08
12

Re: Trouble shooting dead website?

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

 

#5 2020-11-10 11:13:26

casperse
Member
2020-11-08
12

Re: Trouble shooting dead website?

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

 

#6 2020-11-10 11:16:32

casperse
Member
2020-11-08
12

Re: Trouble shooting dead website?

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

 

#7 2020-11-10 11:27:21

erAck
Only trying to help
2015-09-06
2026

Re: Trouble shooting dead website?

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.


Running Piwigo at https://erack.net/gallery/

Offline

 

#8 2020-11-10 13:46:51

casperse
Member
2020-11-08
12

Re: Trouble shooting dead website?

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

 

#9 2020-11-10 16:07:06

casperse
Member
2020-11-08
12

Re: Trouble shooting dead website?

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

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact