User delete while browsing #1103

Open
opened 2026-10-05 00:31:25 +02:00 by adam · 0 comments
Owner

If you delete the user , while he is browsing the page.
Then its dies.

"Share Album" plugin creates a user, and if you revoke (Cancel sharing) the access while the user is browsing.
functions_user_inc.php dies at row 348.

I added these rows to avoid the problem:
$user_infos_row = pwg_db_fetch_assoc($result); if (is_null($user_infos_row)) { unset($_SESSION["pwg_uid"]); redirect(get_absolute_root_url()); }

The error message:
`Warning: array_merge(): Expected parameter 1 to be an array, null given in ...\www\piwigo\include\functions_user.inc.php on line 356

Warning: Invalid argument supplied for foreach() in ...\www\piwigo\include\functions_user.inc.php on line 358

Notice: Undefined index: id in ...\www\piwigo\include\functions_user.inc.php on line 380

Notice: Undefined index: status in ...\www\piwigo\include\functions_user.inc.php on line 380

Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3

SELECT cat_id
FROM pwg_user_access
WHERE user_id =
; in ...\www\piwigo\include\dblayer\functions_mysqli.inc.php on line 856

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in ...\www\piwigo\include\dblayer\functions_mysqli.inc.php:917 Stack trace: #0 ...\www\piwigo\include\functions_user.inc.php(545): query2array('\nSELECT cat_id\n...', NULL, 'cat_id') #1 ...\www\piwigo\include\functions_user.inc.php(380): calculate_permissions(NULL, NULL) #2 ...\www\piwigo\include\functions_user.inc.php(273): getuserdata(5, true) #3 ...\www\piwigo\include\user.inc.php(60): build_user(5, true) #4 ...\www\piwigo\include\common.inc.php(154): include('C:\Users\szabog...') #5 ...\www\piwigo\index.php(11): include_once('C:\Users\szabog...') #6 {main} thrown in ...\www\piwigo\include\dblayer\functions_mysqli.inc.php on line 917`

If you delete the user , while he is browsing the page. Then its dies. "Share Album" plugin creates a user, and if you revoke (Cancel sharing) the access while the user is browsing. functions_user_inc.php dies at row 348. **I added these rows to avoid the problem:** ` $user_infos_row = pwg_db_fetch_assoc($result); if (is_null($user_infos_row)) { unset($_SESSION["pwg_uid"]); redirect(get_absolute_root_url()); } ` **The error message:** `Warning: array_merge(): Expected parameter 1 to be an array, null given in ...\www\piwigo\include\functions_user.inc.php on line 356 Warning: Invalid argument supplied for foreach() in ...\www\piwigo\include\functions_user.inc.php on line 358 Notice: Undefined index: id in ...\www\piwigo\include\functions_user.inc.php on line 380 Notice: Undefined index: status in ...\www\piwigo\include\functions_user.inc.php on line 380 Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3 SELECT cat_id FROM pwg_user_access WHERE user_id = ; in ...\www\piwigo\include\dblayer\functions_mysqli.inc.php on line 856 Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in ...\www\piwigo\include\dblayer\functions_mysqli.inc.php:917 Stack trace: #0 ...\www\piwigo\include\functions_user.inc.php(545): query2array('\nSELECT cat_id\n...', NULL, 'cat_id') #1 ...\www\piwigo\include\functions_user.inc.php(380): calculate_permissions(NULL, NULL) #2 ...\www\piwigo\include\functions_user.inc.php(273): getuserdata(5, true) #3 ...\www\piwigo\include\user.inc.php(60): build_user(5, true) #4 ...\www\piwigo\include\common.inc.php(154): include('C:\\Users\\szabog...') #5 ...\www\piwigo\index.php(11): include_once('C:\\Users\\szabog...') #6 {main} thrown in ...\www\piwigo\include\dblayer\functions_mysqli.inc.php on line 917` <!-- github-sync-id:751540632 -->
Sign in to join this conversation.
No labels
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#1103