Announcement

#1 2021-11-17 02:08:03

BrianO10
Member
2021-11-17
3

Admin Interface Broken After Upgrade to 12.1.0

Hi Folks,
I just upgraded to 12.1.0 from 11.5 (I believe) and the Admin interface (all parts of it) results in the error shown below.  My website was working well before the upgrade.  The normal user interface (seeing the albums and photos) still works, but always throws this error when I try to access the Admin functions.  Any suggestions on how to recover?  I have a backup but would like to understand/fix this.
Thanks for any help you can provide,
Brian


Warning: Use of undefined constant LOUNGE_TABLE - assumed 'LOUNGE_TABLE' (this will throw an Error in a future version of PHP) in *****.com/Piwigo/admin/include/functions.php on line 3271



Warning:  [mysql error 1146] Table '******_db.LOUNGE_TABLE' doesn't exist

SELECT
    image_id
  FROM LOUNGE_TABLE
; in *******.com/Piwigo/include/dblayer/functions_mysqli.inc.php on line 864


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in *****.com/Piwigo/include/dblayer/functions_mysqli.inc.php:925 Stack trace: #0 *******.com/Piwigo/admin/include/functions.php(3273): query2array('\nSELECT\n ima...', NULL, 'image_id') #1 *****.com/Piwigo/admin.php(254): get_orphans() #2 {main} thrown in *****.com/Piwigo/include/dblayer/functions_mysqli.inc.php on line 925

Offline

 

#2 2021-11-17 02:15:40

BrianO10
Member
2021-11-17
3

Re: Admin Interface Broken After Upgrade to 12.1.0

Hi Folks,
Perhaps related to the Admin problem are the following errors that appear on my home page.  The errors are not present when looking at subalbums or photos.  Since I cannot access the Admin page to remove the PWG_Stuffs plugin, would it be worth trying to remove it manually by deleting the folder with it?  Might this be related at all to the upgrade problem or another problem on its own?
Thanks,
Brian

Notice: Trying to access array offset on value of type bool in *****.com/Piwigo/plugins/PWG_Stuffs/modules/FeaturedPhotos/main.inc.php on line 32

Warning: Cannot modify header information - headers already sent by (output started at *****.com/Piwigo/plugins/PWG_Stuffs/modules/FeaturedPhotos/main.inc.php:32) in *****.com/Piwigo/include/page_header.php on line 94

Offline

 

#3 2021-11-17 17:23:57

PEU
Member
Buenos Aires, Argentina
2017-02-12
100

Re: Admin Interface Broken After Upgrade to 12.1.0

follow instructions for manual update deleting everything but the folders in the instructions. This made my site visible again, then incompatible extensions should be disabled by default, do not force enable them or you will have to redo the whole procedure. This worked for me, twice :)

Offline

 

#4 2021-11-18 15:36:28

BrianO10
Member
2021-11-17
3

Re: Admin Interface Broken After Upgrade to 12.1.0

Thanks for your help, PEU.  I may give that a try.  I've seen a couple others use it with success.  Do you know what caused the problem?  Is it something in my installation (and others) or an issue with the upgrade?
Thanks again,
Brian

Offline

 

#5 2021-11-18 19:09:18

PEU
Member
Buenos Aires, Argentina
2017-02-12
100

Re: Admin Interface Broken After Upgrade to 12.1.0

I'm missing some plugins due to lack of upgrades and while trying to enable some of them the gallery went down, had to do the whole manual install but it worked every time, that's why I'm confident its not an install issue but something that is not compatible in your actual setup

Offline

 

#6 2021-11-19 04:36:54

russmcclay
Member
2017-08-24
28

Re: Admin Interface Broken After Upgrade to 12.1.0

Just upgraded to 12.1.0 from a working installation which was at the latest version working well.  System is CentOS, PHP 7.2.  After clicking the link in the notification email, it throws the error below. I did try to run upgrade_feed.php and upgrade.php again to no avail.  Other than the broken Admin functions (Tools, Configuration...), the gallery works fine.  Here's the error:

Warning: Use of undefined constant LOUNGE_TABLE - assumed 'LOUNGE_TABLE' (this will throw an Error in a future version of PHP) in /VirtualHost/photos.****.com/admin/include/functions.php on line 3271


Warning:  [mysql error 1146] Table 'piwigo-photos.LOUNGE_TABLE' doesn't exist

SELECT
    image_id
  FROM LOUNGE_TABLE
; in /VirtualHost/photos.****.com/include/dblayer/functions_mysqli.inc.php on line 864


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /VirtualHost/photos.****.com/include/dblayer/functions_mysqli.inc.php:925 Stack trace: #0 /VirtualHost/photos.****.com/admin/include/functions.php(3273): query2array('\nSELECT\n ima...', NULL, 'image_id') #1 /VirtualHost/photos.****.com/admin.php(254): get_orphans() #2 {main} thrown in /VirtualHost/photos.****.com/include/dblayer/functions_mysqli.inc.php on line 925

Offline

 

#7 2021-11-19 04:38:30

russmcclay
Member
2017-08-24
28

Re: Admin Interface Broken After Upgrade to 12.1.0

Hey Brian --

Just to say I have encountered the identical problem and I have posted my experience in this thread. 

So far no solution.

Russ

BrianO10 wrote:

Hi Folks,
I just upgraded to 12.1.0 from 11.5 (I believe) and the Admin interface (all parts of it) results in the error shown below.  My website was working well before the upgrade.  The normal user interface (seeing the albums and photos) still works, but always throws this error when I try to access the Admin functions.  Any suggestions on how to recover?  I have a backup but would like to understand/fix this.
Thanks for any help you can provide,
Brian


Warning: Use of undefined constant LOUNGE_TABLE - assumed 'LOUNGE_TABLE' (this will throw an Error in a future version of PHP) in *****.com/Piwigo/admin/include/functions.php on line 3271



Warning:  [mysql error 1146] Table '******_db.LOUNGE_TABLE' doesn't exist

SELECT
    image_id
  FROM LOUNGE_TABLE
; in *******.com/Piwigo/include/dblayer/functions_mysqli.inc.php on line 864


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in *****.com/Piwigo/include/dblayer/functions_mysqli.inc.php:925 Stack trace: #0 *******.com/Piwigo/admin/include/functions.php(3273): query2array('\nSELECT\n ima...', NULL, 'image_id') #1 *****.com/Piwigo/admin.php(254): get_orphans() #2 {main} thrown in *****.com/Piwigo/include/dblayer/functions_mysqli.inc.php on line 925

Offline

 

#8 2021-11-19 05:00:26

PEU
Member
Buenos Aires, Argentina
2017-02-12
100

Re: Admin Interface Broken After Upgrade to 12.1.0

You need to upgrade PHP to 7.4 methinks

Offline

 

#9 2021-11-20 03:33:53

russmcclay
Member
2017-08-24
28

Re: Admin Interface Broken After Upgrade to 12.1.0

PEU wrote:

You need to upgrade PHP to 7.4 methinks

According to the documentation:

Minimum Requirements

a webserver like Nginx or Apache
MySQL 5 (or the equivalent with MariaDB)
PHP 5.3 (recommended 7.0 or 7.1)

Offline

 

#10 2021-11-20 12:32:29

paulleslie
Member
2015-03-09
9

Re: Admin Interface Broken After Upgrade to 12.1.0

I have the same problem I think!

Here is my error message:

Warning:  [mysql error 1146] Table '*******.piwigo_lounge' doesn't exist

SELECT
    image_id
  FROM piwigo_lounge
; in /home/lesdu630/gallery.lesduke.com/include/dblayer/functions_mysqli.inc.php on line 847


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/lesdu630/gallery.lesduke.com/include/dblayer/functions_mysqli.inc.php:908 Stack trace: #0 /home/lesdu630/gallery.lesduke.com/admin/include/functions.php(3273): query2array('\nSELECT\n ima...', NULL, 'image_id') #1 /home/lesdu630/gallery.lesduke.com/admin.php(263): get_orphans() #2 {main} thrown in /home/lesdu630/gallery.lesduke.com/include/dblayer/functions_mysqli.inc.php on line 908

Also, I just switched to 7.4 - no change

Last edited by paulleslie (2021-11-20 12:38:37)

Offline

 

#11 2021-11-20 17:25:06

erAck
Only trying to help
2015-09-06
2019

Re: Admin Interface Broken After Upgrade to 12.1.0

paulleslie wrote:

I have the same problem I think!

That's not the same. One is the LOUNGE_TABLE constant being undefined, your's is the (already resolved constant) piwigo_lounge table not existing.

Try if [Forum, post 182050 by erAck in topic 31634] Admin-interface doesnt work after upgrade to 12.1 helps.


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

Offline

 

#12 2021-11-21 04:06:25

paulleslie
Member
2015-03-09
9

Re: Admin Interface Broken After Upgrade to 12.1.0

Hi - Sorry, but it looks like the same error: [mysql error 1146]

This is the same error for both.

Offline

 

#13 2021-11-21 12:08:59

erAck
Only trying to help
2015-09-06
2019

Re: Admin Interface Broken After Upgrade to 12.1.0

The error 1146 is the same because the table name passed in the SQL command does not exist.
The names passed and causes are different (though might be related).


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

Offline

 

#14 2021-11-21 18:16:01

paulleslie
Member
2015-03-09
9

Re: Admin Interface Broken After Upgrade to 12.1.0

Hey erAck,

Thanks for your patience! The fix worked and my site is running normally. Your time is very much appreciated!

Offline

 

#15 2021-11-23 04:28:48

LouiseC
Member
2021-11-23
5

Re: Admin Interface Broken After Upgrade to 12.1.0

Hi, this is my first time working with Piwigo. In reading the threads I think I have the same problem with the Admin interface and maybe more. After the upgrade I got 2 set of messages, the first is similar to what other people have and I contacted my host provider to ensure I was moved up to PHP 7.4. After that was done, I went back to see if I could get into Admin and was not able to, but was able to browse and view the gallery and did see warning messages for the plugin Meta. Problem is I'm still not able to get pass the Admin error messages.

Warning:  [mysql error 1146] Table 'toro1893_piwi343.piwiin_lounge' doesn't exist

SELECT
    image_id
  FROM piwiin_lounge
; in /home/toro1893/public_html/dir/include/dblayer/functions_mysqli.inc.php on line 847


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/toro1893/public_html/dir/include/dblayer/functions_mysqli.inc.php:908 Stack trace: #0 /home/toro1893/public_html/dir/admin/include/functions.php(3273): query2array('\nSELECT\n ima...', NULL, 'image_id') #1 /home/toro1893/public_html/dir/admin.php(263): get_orphans() #2 {main} thrown in /home/toro1893/public_html/dir/include/dblayer/functions_mysqli.inc.php on line 908

The 2nd set of messages I'm not sure if it related: here's part of it as it is very long:

Warning:  [mysql error 1146] Table 'toro1893_piwi343.piwiin_lounge' doesn't exist

SELECT
    image_id
  FROM piwiin_lounge
; in /home/toro1893/public_html/dir/include/dblayer/functions_mysqli.inc.php on line 847


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/toro1893/public_html/dir/include/dblayer/functions_mysqli.inc.php:908 Stack trace: #0 /home/toro1893/public_html/dir/admin/include/functions.php(3273): query2array('\nSELECT\n ima...', NULL, 'image_id') #1 /home/toro1893/public_html/dir/admin.php(263): get_orphans() #2 {main} thrown in /home/toro1893/public_html/dir/include/dblayer/functions_mysqli.inc.php on line 908

Please let me know what I need to do to make it working again. Appreciate your help...LouiseC

Offline

 

Board footer

Powered by FluxBB

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