Announcement

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

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

Pat2309
Member
2014-09-03
21

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
6811

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
21

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
6811

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

 

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

Pat2309
Member
2014-09-03
21

Re: I can not go to aministration tab anymore

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

Offline

 

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

xxxcame
Member
2018-07-25
1

Re: I can not go to aministration tab anymore

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

Offline

 

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

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13159

Re: I can not go to aministration tab anymore

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 :-)


Latest blog post (May 3rd 2018) New subscription form

Offline

 

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

Pat2309
Member
2014-09-03
21

Re: I can not go to aministration tab anymore

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

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