adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

Can't update plugins after 15.1.0 -> 15.5.0 upgrade #2053

New Issue
Open
opened 2026-10-05 01:04:50 +02:00 by adam · 1 comment
adam commented 2026-10-05 01:04:50 +02:00
Owner
Copy link
Copy source

I recently ran an upgrade from Piwigo 15.1.0 to 15.5.0 and now I can't upgrade extensions from the web ui.

When I navigate to Admin -> Plugins -> Check for updates and click Install a box pops up that says ERROR an error occurred but there is nothing thrown in the console.

If I navigate to Admin -> Plugins and click the slider to disable a plugin (e.g. Community), a pill pops up that says "an error occurred" and this error appears in the console:

<pre><br />
<b>Warning</b>:  [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 ')
    AND level > 8
    AND level <= 8
  GROUP BY category_id' at line 5

SELECT
    category_id
  FROM piwigo_image_category
    JOIN piwigo_images ON image_id = id
  WHERE category_id IN ()
    AND level > 8
    AND level <= 8
  GROUP BY category_id
; in <b>/nfs/aesop1/hw00/d90/machines/photos/include/dblayer/functions_mysqli.inc.php</b> on line <b>847</b><br />
</pre><br />
<b>Fatal error</b>:  Uncaught Error: Call to a member function fetch_assoc() on bool in /nfs/aesop1/hw00/d90/machines/photos/include/dblayer/functions_mysqli.inc.php:900
Stack trace:
#0 /nfs/aesop1/hw00/d90/machines/photos/include/functions.inc.php(1633): query2array('\nSELECT\n    cat...', 'category_id')
#1 /nfs/aesop1/hw00/d90/machines/photos/plugins/community/include/functions_community.inc.php(197): hash_from_query('\nSELECT\n    cat...', 'category_id')
#2 /nfs/aesop1/hw00/d90/machines/photos/plugins/community/main.inc.php(49): community_get_user_permissions('1')
#3 /nfs/aesop1/hw00/d90/machines/photos/include/functions_plugins.inc.php(264): community_init()
#4 /nfs/aesop1/hw00/d90/machines/photos/include/common.inc.php(343): trigger_notify('init')
#5 /nfs/aesop1/hw00/d90/machines/photos/ws.php(12): include_once('/nfs/aesop1/hw0...')
#6 {main}
  thrown in <b>/nfs/aesop1/hw00/d90/machines/photos/include/dblayer/functions_mysqli.inc.php</b> on line <b>900</b><br />

Potentially related, when I navigate to Admin -> Tools -> Maintenance -> Purge Cache and click Refresh the spinner starts, but the following error appears in the console:

VM1073:1 Uncaught SyntaxError: Unexpected token '<', "<pre><br /"... is not valid JSON
    at JSON.parse (<anonymous>)
    at m.parseJSON (jquery.min.js?v15.5.0:5:15998)
    at Object.success (1k4ebag.js:7:325)
    at j (jquery.min.js?v15.5.0:2:27309)
    at Object.fireWith [as resolveWith] (jquery.min.js?v15.5.0:2:28122)
    at x (jquery.min.js?v15.5.0:5:22111)
    at XMLHttpRequest.b (jquery.min.js?v15.5.0:5:26030)
m.parseJSON @ jquery.min.js?v15.5.0:5
success @ 1k4ebag.js:7
j @ jquery.min.js?v15.5.0:2
fireWith @ jquery.min.js?v15.5.0:2
x @ jquery.min.js?v15.5.0:5
b @ jquery.min.js?v15.5.0:5
XMLHttpRequest.send
send @ jquery.min.js?v15.5.0:5
ajax @ jquery.min.js?v15.5.0:5
(anonymous) @ 1k4ebag.js:7
(anonymous) @ 1k4ebag.js:7
dispatch @ jquery.min.js?v15.5.0:4
r.handle @ jquery.min.js?v15.5.0:4

I've tried this in Firefox and Chromium.

I recently ran an upgrade from Piwigo 15.1.0 to 15.5.0 and now I can't upgrade extensions from the web ui. When I navigate to `Admin -> Plugins -> Check for updates` and click `Install` a box pops up that says `ERROR an error occurred` but there is nothing thrown in the console. If I navigate to `Admin -> Plugins` and click the slider to disable a plugin (e.g. `Community`), a pill pops up that says "an error occurred" and this error appears in the console: ``` <pre><br /> <b>Warning</b>: [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 ') AND level > 8 AND level <= 8 GROUP BY category_id' at line 5 SELECT category_id FROM piwigo_image_category JOIN piwigo_images ON image_id = id WHERE category_id IN () AND level > 8 AND level <= 8 GROUP BY category_id ; in <b>/nfs/aesop1/hw00/d90/machines/photos/include/dblayer/functions_mysqli.inc.php</b> on line <b>847</b><br /> </pre><br /> <b>Fatal error</b>: Uncaught Error: Call to a member function fetch_assoc() on bool in /nfs/aesop1/hw00/d90/machines/photos/include/dblayer/functions_mysqli.inc.php:900 Stack trace: #0 /nfs/aesop1/hw00/d90/machines/photos/include/functions.inc.php(1633): query2array('\nSELECT\n cat...', 'category_id') #1 /nfs/aesop1/hw00/d90/machines/photos/plugins/community/include/functions_community.inc.php(197): hash_from_query('\nSELECT\n cat...', 'category_id') #2 /nfs/aesop1/hw00/d90/machines/photos/plugins/community/main.inc.php(49): community_get_user_permissions('1') #3 /nfs/aesop1/hw00/d90/machines/photos/include/functions_plugins.inc.php(264): community_init() #4 /nfs/aesop1/hw00/d90/machines/photos/include/common.inc.php(343): trigger_notify('init') #5 /nfs/aesop1/hw00/d90/machines/photos/ws.php(12): include_once('/nfs/aesop1/hw0...') #6 {main} thrown in <b>/nfs/aesop1/hw00/d90/machines/photos/include/dblayer/functions_mysqli.inc.php</b> on line <b>900</b><br /> ``` Potentially related, when I navigate to `Admin -> Tools -> Maintenance -> Purge Cache` and click `Refresh` the spinner starts, but the following error appears in the console: ``` VM1073:1 Uncaught SyntaxError: Unexpected token '<', "<pre><br /"... is not valid JSON at JSON.parse (<anonymous>) at m.parseJSON (jquery.min.js?v15.5.0:5:15998) at Object.success (1k4ebag.js:7:325) at j (jquery.min.js?v15.5.0:2:27309) at Object.fireWith [as resolveWith] (jquery.min.js?v15.5.0:2:28122) at x (jquery.min.js?v15.5.0:5:22111) at XMLHttpRequest.b (jquery.min.js?v15.5.0:5:26030) m.parseJSON @ jquery.min.js?v15.5.0:5 success @ 1k4ebag.js:7 j @ jquery.min.js?v15.5.0:2 fireWith @ jquery.min.js?v15.5.0:2 x @ jquery.min.js?v15.5.0:5 b @ jquery.min.js?v15.5.0:5 XMLHttpRequest.send send @ jquery.min.js?v15.5.0:5 ajax @ jquery.min.js?v15.5.0:5 (anonymous) @ 1k4ebag.js:7 (anonymous) @ 1k4ebag.js:7 dispatch @ jquery.min.js?v15.5.0:4 r.handle @ jquery.min.js?v15.5.0:4 ``` I've tried this in Firefox and Chromium. <!-- github-sync-id:3043778064 -->
adam commented 2026-10-05 01:04:51 +02:00
Author
Owner
Copy link
Copy source

Hello,

Do you get the same error with other plugins? Because I see an error concerning the community plugin (the empty WHERE category_id IN ())

Hello, Do you get the same error with other plugins? Because I see an error concerning the community plugin (the empty `WHERE category_id IN ()`) <!-- github-comment-id:3236676194 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#2053