Piwigo.org

Jaime67 · 2023-08-10 14:37:07

Hello/Hi/Greetings,

After a Debian distro upgrade I can't access to Piwigo.
The only error message I could get (apart from a 503) is this

Warning: Attempt to read property "errno" on null in /var/www/html/piwigo/include/dblayer/functions_mysql.inc.php on line 839

This message appears twice. Then:

Piwigo encountered a non recoverable error

[mysql error]
No such file or directory

#1 my_error /var/www/html/piwigo/include/common.inc.php(122)
#2 include_once /var/www/html/piwigo/index.php(11)

I don't know how to give info about my piwigo I can't access to it at all (through browser I mean)

Any help? Thanks a lot.

Piwigo URL: http://jaimesuma.com/piwigo/

erAck · 2023-08-10 14:56:37

Sounds like your web server can't reach the mysql server or your mysql can't reach the actual database file(s).

Jaime67 · 2023-08-10 17:46:35

Hello.
Not experience at all with mysql services, any pointers to start reading/looking?
Thanks again.

Jaime67 · 2023-08-10 17:53:34

Alternatively... can I reinstall Piwigo without losing my albums?

kinmen · 2023-08-11 08:35:28

Make sure all mariadb / mysql packages are installed:

dpkg -l|grep mysql

Then make sure mysql is up and running:

service mysql status

Jaime67 · 2023-08-16 18:10:57

Hello.
It turns out that mysql client was installed but the server was not, after installing it Piwigo somehow is working again but the screen is filled with warning messages like:

Deprecated: Creation of dynamic property Smarty_Internal_Extension_Handler::$registerPlugin is deprecated in /var/www/html/piwigo/include/smarty/libs/sysplugins/smarty_internal_extension_handler.php on line 182

and many similar with "Deprecated:..." text.

Also some like this:
/var/www/html/piwigo/_data/templates_c/1hjw97b^2b83bfd1474fce8b2e2cf5052cafafd4d069e28d_0.file.gdthumb_thumb.tpl.php on line 41 crop">

I can't find the link to login as admin and try to do something else.

Any help is much appreciated.

Jaime67 · 2023-08-16 18:21:53

Edit: I can execute admin.php and I see that piwigo and extensions are correctly updated, but warnings are everywhere in the pages.

erAck · 2023-08-17 00:11:03

Either disable displaying deprecated and warnings messages (because it effectively may break functionality of a page even if nothing else is broken), in local config

$conf['show_php_errors_on_frontend'] = false;

or fine tune message classes to display, see [Forum, post 183126 by erAck in topic 31852] Menubar tags issue after 12.2.0 upgrade, or better, log to file instead.
See [Forum, post 180778 by erAck in topic 31258] Error Message.

If you can't see the login you may try to load yoursite/identification.php in your browser.

Jaime67 · 2023-08-17 19:15:45

Thanks a lot.
It seems that everything has returned to normal for now.
I finally adjusted message classes as stated in one of your links.
Being a total novice I created (as it didn't exit) piwigo/local/config/config.inc.php only with the $conf line, luckily I read in another message that the poster had forgotten to write <?php ... ?>

So for less experienced users in the future: the file local/config/config.inc.php shoud contain at least this:

Code:

<?php
$conf['show_php_errors'] = E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_WARNING;
?>

mikey45 · 2024-08-31 13:34:39

Thank you to PIWIGO forum and especially to erAck which I am indebted.
I had a similar episode a month ago when my TSO host updated their server spoiling- firstly the access to my website. The had a problem with webmail and outlook mail.
Thirdly Piwigo webpage wasn't opening. Instead it showed:
[mysql error 1044] access denied for user 'ppdyijp_piwi928'@'localhost' to database 'pamjamco_piwi928'
can connect to the server successfully but unable to search Mysql database.
#1 my_error /var/www/html/piwigo/include/common.inc.php(122)
#2 include_once /var/www/html/piwigo/index.php(11)
After hours of trying to solve, searching at Over Stack for coding problem.
Ultimately, the server support was need to tweak from their side rather than me.
Now it works perfectly now!
Thank you all

Last edited by mikey45 (2024-09-02 11:25:13)

Piwigo.org

Announcement

#1 2023-08-10 14:37:07

Mysql errors after Debian upgrade.

#2 2023-08-10 14:56:37

Re: Mysql errors after Debian upgrade.

#3 2023-08-10 17:46:35

Re: Mysql errors after Debian upgrade.

#4 2023-08-10 17:53:34

Re: Mysql errors after Debian upgrade.

#5 2023-08-11 08:35:28

Re: Mysql errors after Debian upgrade.

#6 2023-08-16 18:10:57

Re: Mysql errors after Debian upgrade.

#7 2023-08-16 18:21:53

Re: Mysql errors after Debian upgrade.

#8 2023-08-17 00:11:03

Re: Mysql errors after Debian upgrade.

#9 2023-08-17 19:15:45

Re: Mysql errors after Debian upgrade.

Code:

#10 2024-08-31 13:34:39

Re: Mysql errors after Debian upgrade.

Board footer