🌍
English
erAck wrote:
Sounds being related to the "related albums" feature problem [Forum, topic 31187] 11.x, related albums and performance issues.
Maybe, maybe not. As we don't use actually tags at all. When you remove the category, it seems to handle the entire database as one big album or something? (via creating those left and right arrows to move to next and previous images between every image in this huge site)
...or then again... related as all the other pictures in the site that have no tags? Maybe :D
edit: yeah it actually might be:
when I edited my my.cnf file to have under mysqld section:
# to limit max query time to 5 seconds in MariaDB
max_statement_time = 5
and tried to reload the same url, I got error
Warning: [mysql error 1969] Query execution was interrupted (max_statement_time exceeded)
SELECT
c.id,
c.uppercats,
count(*) AS counter
FROM image_category
INNER JOIN categories c ON category_id = id
WHERE image_id IN (413509,400218,400219,400217,400220,400221,438118,413945,413510,415044,398727,438120,438121,473734,473735,473736,473737,473738,473739,473740,473741,473742,473743,473744,473745,473746,473713,473714,473721,473722,473723,473724,473725,473726,473727,473728,473729,473715,473730,473731,473732,473733,473716,473717,473718,473719,473720,413188,413946,413473,415045,398728,413189,413474,413947,415046,398729,413190,473192,413475,413948,415048,398730,413191,413476,413949,415049,398731,413192,472275,413477,413950,415050,398732,413193,413478,413951,415051,398733,413194,413952,413479,415052,398734,472277,413195,413480,413953,415053,398735,413196,472270,444134,444143,447741,451869,455573,462159,464697,469088,477462,261388,273000,286508,290488,400575,417692,426809,431728,438432,443374,450238,451041,45 in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php on line 864
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php:228
Stack trace:
#0 /var/www/html/galerii/include/functions_category.inc.php(711): pwg_db_fetch_assoc(false)
#1 /var/www/html/galerii/include/functions_category.inc.php(723): get_common_categories(Array, NULL, Array)
#2 /var/www/html/galerii/include/menubar.inc.php(123): get_related_categories_menu(Array, Array)
#3 /var/www/html/galerii/include/menubar.inc.php(15): initialize_menu()
#4 /var/www/html/galerii/picture.php(1025): include('/var/www/html/g...')
#5 {main}
thrown in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php on line 228While on the subject... of displaying errors to web visitors? Piwigo, really?
I mean like I have in global php.ini display_errors = Off and yet somehow in Piwigo they are visible?? Where and why does Piwigo turn this ON?
Last edited by deemon (2021-05-07 23:34:07)
Offline