Piwigo.org

Pat2309 · 2018-05-20 11:20:16

Hello/Hi/Greetings,

here is a problem I've had for the second time. I have a photogallery that is big (76000 photos). After uploading some photos I can not go to the Administration tabs anymore. I get following error:

----------------------------------------------------------------------------------
Warning: [mysql error 1104] The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

SELECT
id
FROM piwigo_images
LEFT JOIN piwigo_image_category ON id = image_id
WHERE category_id is null
ORDER BY id ASC
; in /customers/6/0/7/pix4u.one/httpd.www/CBB/include/dblayer/functions_mysqli.inc.php on line 845
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /customers/6/0/7/pix4u.one/httpd.www/CBB/include/dblayer/functions_mysqli.inc.php:906 Stack trace: #0 /customers/6/0/7/pix4u.one/httpd.www/CBB/admin/include/functions.php(3012): query2array('\nSELECT\n id\n...', NULL, 'id') #1 /customers/6/0/7/pix4u.one/httpd.www/CBB/admin.php(254): get_orphans() #2 {main} thrown in /customers/6/0/7/pix4u.one/httpd.www/CBB/include/dblayer/functions_mysqli.inc.php on line 906
---------------------------------------------------------------------------------------------------------

Does anyone know a solution. I don't want to restart the gallery anymore. I don't want to leave Piwigo, but if I can not fix this, I don't see any other solution!

Pat

flop25 · 2018-05-20 14:09:40

Hello
You notify our founder who should be interested in this

Pat2309 · 2018-05-25 20:02:37

Hi flop25,

can i get in contact with him, or will he read this?

Greetings,

Pat2309

flop25 · 2018-05-25 20:21:46

sorry sorry my mistake
"I notify"
i've already notified Plg

Pat2309 · 2018-07-14 16:14:05

Unf I didn't hear anything new. I can't update or do anything anymore... Any suggestions? If not, I'm afraid I'll have to remove Piwigo and look for something else...

Grtz,

Pat

xxxcame · 2018-07-25 02:17:46

Hi, it's great sound to follow up the support and encouragement. Will bookmark.

plg · 2018-07-25 10:16:58

Hi Pat2309,

As the error message suggests, this is a database setting issue. Piwigo code is no really the right place to configure the database. You should contact your web hosting provider with this error message and see how they can modifiy their configuration.

Even if 76k photos is starting to be "a lot", it is far from being what Piwigo can handle. For example, on Piwigo.com, we have many users with more than 500k photos, and it runs perfectly :-)

Pat2309 · 2018-08-05 16:47:05

Hi plg,

thanks for the reply. I will take contact with my web hosting. If they can not help I might just wait for the 3.0 version and start all over.

I was always supersatisfied with Piwigo and really don't feel like changing.

Best regards,

Pat2309

Pat2309 · 2018-09-02 19:55:18

Finally I found the answer. I had to go to the database via phpMyAdmin and OPTIMIZE and/or REPAIR the Database. That solved the problem!

Super, now I'm back on track!

Pat

Piwigo.org

Announcement

#1 2018-05-20 11:20:16

[resolved] I can not go to aministration tab anymore

#2 2018-05-20 14:09:40

Re: [resolved] I can not go to aministration tab anymore

#3 2018-05-25 20:02:37

Re: [resolved] I can not go to aministration tab anymore

#4 2018-05-25 20:21:46

Re: [resolved] I can not go to aministration tab anymore

#5 2018-07-14 16:14:05

Re: [resolved] I can not go to aministration tab anymore

#6 2018-07-25 02:17:46

Re: [resolved] I can not go to aministration tab anymore

#7 2018-07-25 10:16:58

Re: [resolved] I can not go to aministration tab anymore

#8 2018-08-05 16:47:05

Re: [resolved] I can not go to aministration tab anymore

#9 2018-09-02 19:55:18

Re: [resolved] I can not go to aministration tab anymore

Board footer