Announcement

  •  » Engine
  •  » I can not go to aministration tab anymore

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

Pat2309
Member
2014-09-03
18

I can not go to aministration tab anymore

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

Offline

 

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

flop25
Piwigo Team
2006-07-06
6801

Re: I can not go to aministration tab anymore

Hello
You notify our founder who should be interested in this


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

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

Pat2309
Member
2014-09-03
18

Re: I can not go to aministration tab anymore

Hi flop25,

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

Greetings,

Pat2309

Offline

 

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

flop25
Piwigo Team
2006-07-06
6801

Re: I can not go to aministration tab anymore

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 
  •  » Engine
  •  » I can not go to aministration tab anymore

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2018 · Contact