pwg.categories.php #731

New Issue

Open

opened 2026-10-05 00:14:28 +02:00 by adam · 0 comments

adam commented 2026-10-05 00:14:28 +02:00

Owner

Copy link

Copy source

I got this error after updating to piwigo version 1.9.2. I'm not entirely sure of the circumstances, but it looks like the array handling is at some point injecting or allowing a blank value to get into the sql generated. I've obfuscated the IP address and server hostname, but otherwise the stacktrace is as recorded by the server.

2017/11/16 20:42:50 [error] 25173#25173: *830 FastCGI sent in stderr: "PHP message: PHP 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 '220)
AND status = 'private'' at line 3

SELECT id
FROM piwigo_categories
WHERE id IN (,220)
AND status = 'private'
; in /var/www/html-content/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
PHP message: PHP Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html-content/piwigo/include/dblayer/functions_mysqli.inc.php:906
Stack trace:
#0 /var/www/html-content/piwigo/admin/include/functions.php(2665): query2array('\nSELECT id\n FR...', NULL, 'id')
#1 /var/www/html-content/piwigo/admin/include/functions.php(1546): add_permission_on_category(Array, Array)
#2 /var/www/html-content/piwigo/include/ws_functions/pwg.categories.php(573): create_virtual_category('uploads-1291174...', 217, Array)
#3 /var/www/html-content/piwigo/include/ws_core.inc.php(608): ws_categories_add(Array, Object(PwgServer))
#4 /var/www/html-content/piwigo/include/ws_protocols/rest_handler.php(56): PwgServer->invoke('pwg.categories....', Array)
#5 /var/www/html-content/piwigo/include/ws_core.inc.php(296): PwgRestRequestHandler->handleRequest(Object(PwgServer))
#6 /var/www/html-content/piwigo/ws.php(94): PwgServer->run()
#7 {main}
thrown in /var/www/html-content/piwi" while reading response header from upstream, client: 99.999.999.999, server: example.server.com, request: "POST /piwigo/ws.php?format=json HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "example.server.com"
2017/11/16 20:42:52 [error] 25173#25173: *833 FastCGI sent in stderr: "PHP message: PHP 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 '221)
AND status = 'private'' at line 3

I got this error after updating to piwigo version 1.9.2. I'm not entirely sure of the circumstances, but it looks like the array handling is at some point injecting or allowing a blank value to get into the sql generated. I've obfuscated the IP address and server hostname, but otherwise the stacktrace is as recorded by the server. 2017/11/16 20:42:50 [error] 25173#25173: *830 FastCGI sent in stderr: "PHP message: PHP 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 '220) AND status = 'private'' at line 3 SELECT id FROM piwigo_categories WHERE id IN (,220) AND status = 'private' ; in /var/www/html-content/piwigo/include/dblayer/functions_mysqli.inc.php on line 845 PHP message: PHP Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html-content/piwigo/include/dblayer/functions_mysqli.inc.php:906 Stack trace: #0 /var/www/html-content/piwigo/admin/include/functions.php(2665): query2array('\nSELECT id\n FR...', NULL, 'id') #1 /var/www/html-content/piwigo/admin/include/functions.php(1546): add_permission_on_category(Array, Array) #2 /var/www/html-content/piwigo/include/ws_functions/pwg.categories.php(573): create_virtual_category('uploads-1291174...', 217, Array) #3 /var/www/html-content/piwigo/include/ws_core.inc.php(608): ws_categories_add(Array, Object(PwgServer)) #4 /var/www/html-content/piwigo/include/ws_protocols/rest_handler.php(56): PwgServer->invoke('pwg.categories....', Array) #5 /var/www/html-content/piwigo/include/ws_core.inc.php(296): PwgRestRequestHandler->handleRequest(Object(PwgServer)) #6 /var/www/html-content/piwigo/ws.php(94): PwgServer->run() #7 {main} thrown in /var/www/html-content/piwi" while reading response header from upstream, client: 99.999.999.999, server: example.server.com, request: "POST /piwigo/ws.php?format=json HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "example.server.com" 2017/11/16 20:42:52 [error] 25173#25173: *833 FastCGI sent in stderr: "PHP message: PHP 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 '221) AND status = 'private'' at line 3 <!-- github-sync-id:275816681 -->

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

master

issue-2560-people

translation

16.x

feat/embedding-based-contextual-tagging

issue-2576-search-include-ai-in-search-results

feat/search-ocr-ai

issue-2391-update-menu-design

15.x

detect-container

issue-2386-update-filters-users-activity

issue-2362-add-filters-options-in-admin

issue-2367-imagemagick7

issue-2225-quicksearch-help

14.x

issue-2164-BatchManagerUnitMode-Redesign

13.x

12.x

issue-1657-SVG_Support

issue-1703-historySearchMethod

11.x

2.10

2.9

2.8

2.7

2.5

2.6

2.4

2.3

2.2

2.1

2.0

1.7

1.3

1.6

1.5

1.4

16.4.0

16.3.0

16.2.0

16.1.0

16.0.0

16.0.0RC3

16.0.0RC2

15.7.0

16.0.0RC1

16.0.0beta1

16.0.0beta2

15.6.0

15.5.0

15.4.0

15.3.0

15.2.0

15.1.0

15.0.0

15.0.0beta3

15.0.0beta2

15.0.0beta1

14.5.0

14.4.0

14.3.0

14.2.0

14.1.0

14.0.0

14.0.0RC2

14.0.0RC1

14.0.0beta3

14.0.0beta2

13.8.0

14.0.0beta1

13.7.0

13.6.0

13.5.0

13.4.0

13.3.0

13.2.0

13.1.0

13.0.0

13.0.0RC4

13.0.0RC3

13.0.0RC2

13.0.0RC1

12.3.0

13.0.0beta2

13.0.0beta1

12.2.0

12.1.0

12.0.0

12.0.0RC2

12.0.0RC1

12.0.0beta2

12.0.0beta1

11.5.0

11.4.0

11.3.0

11.2.0

11.1.0

11.0.0

11.0.0beta5

2.11.0beta4

2.11.0beta3

2.11.0beta2

2.11.0beta1

2.10.2

2.10.1

2.10.0

2.10.0RC1

2.10.0beta2

2.10.0beta1

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.9.0RC2

2.9.0RC1

2.9.0beta2

2.8.6

2.8.5

2.8.4

2.9.0beta1

2.8.3

2.8.2

2.8.1

2.8.0

2.8.0RC2

2.8.0RC1

2.7.4

2.7.3

2.6.5

2.5.6

2.5.5

2.6.4

2.7.2

2.7.1

2.7.0

2.7.0RC2

2.7.0RC1

2.7.0beta2

2.6.3

2.7.0beta1

2.6.2

2.5.4

2.6.1

2.6.0

2.6.0RC2

2.6.0RC1

2.6.0beta2

2.5.3

2.5.2

2.6.0beta1

2.5.1

2.5.0

2.5.0RC2

2.4.7

2.5.0RC1

2.4.6

2.5.0beta3

2.5.0beta2

2.5.0beta1

2.4.5

2.4.4

2.4.3

2.4.2

2.4.1

2.4.0

2.3.5

2.4.0RC3

2.3.4

2.4.0RC2

2.4.0RC1

2.3.3

2.4.0beta2

2.4.0beta1

2.3.2

2.3.1

2.3.0

2.3.0RC2

2.3.0RC1

2.2.5

2.3.0beta3

2.2.4

2.3.0beta2

2.2.3

2.2.2

2.3.0beta1

2.2.1

2.2.0

2.2.0RC4

2.2.0RC3

2.2.0RC2

2.1.6

2.2.0RC1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.1.0

2.0.10

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.9

2.0.8

2.0.7

2.0.6

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC4

1.7.3

2.0.0RC3

2.0.0RC2

2.0.0RC1

1.7.2

1.7.1

1.7.0

1.7.0RC2

1.7.0RC1

1.6.2

1.6.1

1.6.0

1.6.0RC2

1.6.0RC1

1.5.2

1.5.1

1.5.0

1.5.0RC2

1.5.0RC1

1.4.1

1.4.0

1.4.0RC3

1.4.0RC2

1.3.4

1.4.0RC1

1.3.3

1.3.2

1.3.1

1.3.0

1.3.0RC2

1.3.0RC1

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

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: adam/Piwigo#731