( ! ) 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 /var/www/html/SandBox/galerie-running/include/dblayer/functions_mysqli.inc.php on line 845
Call Stack
#
Time
Memory
Function
Location
1
0.0001
356664
{main}(  )
.../index.php:0
2
0.0719
1063304
trigger_notify( $event = 'loc_begin_index' )
.../index.php:93
3
0.0719
1063680
load_stuffs(  )
.../functions_plugins.inc.php:282
4
0.0722
1066248
stuffs->__construct(  )
.../main.inc.php:53
5
0.0729
1066816
stuffs->get_modules(  )
.../class.inc.php:35
6
0.0729
1067200
pwg_query( $query = '\r\nSELECT DISTINCT id, name, path, datas, groups, show_title, id_line, width\r\nFROM piwigo_stuffs\r\nLEFT JOIN piwigo_user_group\r\n  ON user_id = 2\r\nWHERE (users IS NULL OR users LIKE "%guest%")\r\n  AND (groups IS NULL OR groups REGEXP CONCAT("(^|,)",group_id,"(,|$)"))\r\n  AND level <= 0\r\n  AND on_home = "true"\r\nORDER BY pos ASC\r\n;' )
.../class.inc.php:71
7
0.0732
1067248
my_error( $header = '\r\nSELECT DISTINCT id, name, path, datas, groups, show_title, id_line, width\r\nFROM piwigo_stuffs\r\nLEFT JOIN piwigo_user_group\r\n  ON user_id = 2\r\nWHERE (users IS NULL OR users LIKE "%guest%")\r\n  AND (groups IS NULL OR groups REGEXP CONCAT("(^|,)",group_id,"(,|$)"))\r\n  AND level <= 0\r\n  AND on_home = "true"\r\nORDER BY pos ASC\r\n;', $die = FALSE )
.../functions_mysqli.inc.php:147
8
0.0732
1067888
trigger_error
( '[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\r\nFROM piwigo_stuffs\r\nLEFT JOIN piwigo_user_gr\' at line 1\n\r\nSELECT DISTINCT id, name, path, datas, groups, show_title, id_line, width\r\nFROM piwigo_stuffs\r\nLEFT JOIN piwigo_user_group\r\n  ON user_id = 2\r\nWHERE (users IS NULL OR users LIKE "%guest%")\r\n  AND (groups IS NULL OR groups REGEXP CONCAT("(^|,)",gr...', 512 )
.../functions_mysqli.inc.php:845
Variables in local scope (#7)
$die =
/var/www/html/SandBox/galerie-running/include/dblayer/functions_mysqli.inc.php:845:boolean false

$error =
/var/www/html/SandBox/galerie-running/include/dblayer/functions_mysqli.inc.php:845:string '[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,"(,|$)"))
 '... (length=572)

$header =
/var/www/html/SandBox/galerie-running/include/dblayer/functions_mysqli.inc.php:845:string '
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
;' (length=326)

$mysqli =
/var/www/html/SandBox/galerie-running/include/dblayer/functions_mysqli.inc.php:845:
object(mysqli)[2]
  public 'affected_rows' => int -1
  public 'client_info' => string 'mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $' (length=79)
  public 'client_version' => int 50012
  public 'connect_errno' => int 0
  public 'connect_error' => null
  public 'errno' => int 1064
  public 'error' => string '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' (length=226)
  public 'error_list' => 
    array (size=1)
      0 => 
        array (size=3)
          'errno' => int 1064
          'sqlstate' => string '42000' (length=5)
          'error' => string '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' (length=226)
  public 'field_count' => int 1
  public 'host_info' => string 'Localhost via UNIX socket' (length=25)
  public 'info' => null
  public 'insert_id' => int 0
  public 'server_info' => string '8.0.45-0ubuntu0.22.04.1' (length=23)
  public 'server_version' => int 80045
  public 'stat' => string 'Uptime: 3469086  Threads: 2  Questions: 481233751  Slow queries: 494  Opens: 1829  Flush tables: 3  Open tables: 1747  Queries per second avg: 138.720' (length=150)
  public 'sqlstate' => string '00000' (length=5)
  public 'protocol_version' => int 10
  public 'thread_id' => int 8235554
  public 'warning_count' => int 0

$result =

/var/www/html/SandBox/galerie-running/include/dblayer/functions_mysqli.inc.php:226:boolean false