Hello/Hi/Greetings,

I have just rebuilt a server (non-production at moment) using Ubuntu 20.04.01. Unfortunately ( :) ) there seems to be a few issues when trying to use PHP 7.4. The two I have caught are:  Additional Pages and PWG Stuffs.

Piwigo version: Piwigo 2.10.2
PHP version: 7.4.8
MySQL version: 8.0.21
Ubuntu 20.04.01 LTS

Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups, level, permalink, standalone
FROM piwigo_additionalpages
WHERE id = 9' at line 1
SELECT id, title, lang, content, users, groups, level, permalink, standalone
FROM piwigo_additionalpages
WHERE id = 9; in /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/include/dblayer/functions_mysqli.inc.php on line 856


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/include/dblayer/functions_mysqli.inc.php:220 Stack trace: #0 /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/plugins/AdditionalPages/additional_page.php(39): pwg_db_fetch_assoc() #1 /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/plugins/AdditionalPages/main.inc.php(68): include('/home/soft-focu...') #2 /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/include/functions_plugins.inc.php(264): section_init_additional_page() #3 /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/include/section_init.inc.php(637): trigger_notify() #4 /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/index.php(12): include('/home/soft-focu...') #5 {main} thrown in /home/soft-focus-imagining/domains/gallery-adult.soft-focus-imagining.com/public_html/include/dblayer/functions_mysqli.inc.php on line 220



Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups, show_title, id_line, width
FROM piwigo_stuffs
LEFT JOIN piwigo_user_gr' at line 1

SELECT DISTINCT id, name, path, datas, groups, show_title, id_line, width
FROM piwigo_stuffs
LEFT JOIN piwigo_user_group
  ON user_id = 2
WHERE (users IS NULL OR users LIKE "%guest%")
  AND (groups IS NULL OR groups REGEXP CONCAT("(^|,)",group_id,"(,|$)"))
  AND level <= 0
  AND on_home = "true"
ORDER BY pos ASC
; in /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/include/dblayer/functions_mysqli.inc.php on line 856


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/include/dblayer/functions_mysqli.inc.php:220 Stack trace: #0 /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/plugins/PWG_Stuffs/class.inc.php(73): pwg_db_fetch_assoc() #1 /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/plugins/PWG_Stuffs/class.inc.php(35): stuffs->get_modules() #2 /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/plugins/PWG_Stuffs/main.inc.php(53): stuffs->__construct() #3 /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/include/functions_plugins.inc.php(264): load_stuffs() #4 /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/index.php(28): trigger_notify() #5 {main} thrown in /home/soft-focus-imagining/domains/gallery.soft-focus-imagining.com/public_html/include/dblayer/functions_mysqli.inc.php on line 220