🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2021-09-19 02:10:25
- egordon99
- Member
- 2021-09-19
- 3
Site suddenly stopped working
Hello Piwigo'ers!
I have been using Piwigo for over ten years and it usually behaves :-)
Just recently started having problems. The homepage works fine but trying to browse to any album/etc gives the following error -
Code:
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /homepages/3/d92543379/htdocs/egp/gallery/include/dblayer/functions_mysqli.inc.php:925 Stack trace: #0 /homepages/3/d92543379/htdocs/egp/gallery/include/section_init.inc.php(317): query2array('\nSELECT DISTINC...', NULL, 'image_id') #1 /homepages/3/d92543379/htdocs/egp/gallery/index.php(12): include('/homepages/3/d9...') #2 {main} thrown in /homepages/3/d92543379/htdocs/egp/gallery/include/dblayer/functions_mysqli.inc.php on line 925Piwigo 11.5.0 Check for upgrade
Operating system: Linux
PHP: 7.4.23 (Show info) [2021-09-18 20:04:22]
MySQL: 5.7.33-log [2021-09-19 02:04:22]
Graphics Library: External ImageMagick 6.9.10-23
I am reasonably technical and can poke around a little in PHP but I am far from a MySQL expert. Any help is appreciated!
Piwigo URL: http://evangordonphotography.com/gallery/
Offline
#2 2021-09-19 12:05:39
- erAck
- Only trying to help
- 2015-09-06
- 2026
Re: Site suddenly stopped working
And what is causing the error is right above that error message, the mysql error 3065 line.
This is odd, because it looks like some old MySQL incompatibility crept in again, which was solved already 5 years ago. See [Forum, topic 26696] Many problems after mysql upgrade to 5.7.11, default for Fedora 24. Actually a result of this search.
This other search not restricted to the piwigo.org site also leads to https://stackoverflow.com/questions/368 … 7-with-sel suggesting you could set your MySQL server's sql_mode removing ONLY_FULL_GROUP_BY, which Piwigo tries to do in include/dblayer/functions_mysqli.inc.php line 68, which for some reason suddenly doesn't work for you and that's odd in itself of course.
Or your local/config/database.inc.php dblayer config does not say 'mysqli' but 'mysql' and your MySQL was updated recently from a very very old version < 5.7
Running Piwigo at https://erack.net/gallery/
Offline
#3 2021-09-19 14:12:17
- egordon99
- Member
- 2021-09-19
- 3
Re: Site suddenly stopped working
Thanks for the reply! Yeah, I was going down that sql_mode rabbit hole last night and I verified I had the fix where Piwigo tries to set the right mode.
The other site I run that is working is running the exact same versions of PHP/MySQL so I am confused.
Let me go make sure I'm using mysqli and not just mysql.
EDIT - Yeah, I'm using mysqli. I'm using IONOS (formerly 1and1) to host my site.
Cheers!
Last edited by egordon99 (2021-09-19 14:15:57)
Offline
#4 2021-09-19 23:57:52
- egordon99
- Member
- 2021-09-19
- 3
Re: Site suddenly stopped working
I gave up and just created a brand new database and Piwigo install at http://evangordonphotography.com/portfolio/
It was pretty easy to add ../gallery/galleries in the site manager and synchronize all the photos from the original site. I also could have setup a brand new install in the original gallery directory but I'm not tied to the original URL.
All the pictures are up in the new site so I'll just have to add some plugins//themes.
Offline