Hallo,

mein Provider hat MySQL auf VErsion 8 upgedated, nun mag PIWGO nicht mehr :-(

Downgrade geht nicht, was kann ich tun?

Meldung
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 IS NULL OR groups REGEXP CONCAT("(^|,)",group_id,"(,|$)"))
  AND level <=' at line 7
SELECT DISTINCT id, title, permalink
FROM piwigo_additionalpages
LEFT JOIN piwigo_user_group
  ON user_id = 2
WHERE (lang IS NULL OR lang = "de_DE")
  AND (users IS NULL OR users LIKE "%guest%")
  AND (groups IS NULL OR groups REGEXP CONCAT("(^|,)",group_id,"(,|$)"))
  AND level <= 0
  AND pos >= 0
ORDER BY pos ASC

; in [...]/include/dblayer/functions_mysqli.inc.php on line 856
Codeblock in der Zeile:
function boolean_to_string($var)
{
  if (is_bool($var))
  {
    return $var ? 'true' : 'false';
  }
  else
  {
    return $var;
  }
}


Fatal error: Call to a member function fetch_assoc() on boolean in [...]/include/dblayer/functions_mysqli.inc.php on line 220
Codeblock in der Zeile:
function pwg_db_fetch_assoc($result)
{
  return $result->fetch_assoc();
}