Uncaught mysqli_sql_exception (UPLOAD WITH DIGIKAM) #1533

New Issue

Open

opened 2026-10-05 00:47:26 +02:00 by adam · 0 comments

adam commented 2026-10-05 00:47:26 +02:00

Owner

Copy link

Copy source

Piwigo 13.0.0
Linux (debian)
PHP: 8.1.11
MySQL: 10.5.15-MariaDB-0

php error when uploading a photo with digikam when I have a special character (here the apostrophe) in the title of my photo : "Beauté d'automne (TEST)"
I specify that with the web form there is no problem.

[Fri Oct 14 09:23:00.827306 2022] [php:error] [pid 710552] [client CLIENT_IP:60431] PHP Fatal error: Uncaught mysqli_sql_exception: 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 'automne (TEST)',\n date_creation= '2022-10-14 07:53:27'\n WHEREid = '...' at line 2 in /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php:132\nStack trace:\n#0 /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php(132): mysqli->query()\n#1 /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php(478): pwg_query()\n#2 /PIWIGO_DIR/include/ws_functions/pwg.images.php(1102): single_update()\n#3 /PIWIGO_DIR/include/ws_core.inc.php(600): ws_images_add()\n#4 /PIWIGO_DIR/include/ws_protocols/rest_handler.php(41): PwgServer->invoke()\n#5 /PIWIGO_DIR/include/ws_core.inc.php(281): PwgRestRequestHandler->handleRequest()\n#6 /PIWIGO_DIR/ws.php(22): PwgServer->run()\n#7 {main}\n thrown in /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php on line 132

Here is an example of a photo that I can't upload : https://share.heraut.eu/f.php?h=1gGeSHGY&d=1:

Thank you and have a nice day.

Piwigo 13.0.0 Linux (debian) PHP: 8.1.11 MySQL: 10.5.15-MariaDB-0 php error when uploading a photo with digikam when I have a special character (here the apostrophe) in the title of my photo : "Beauté d'automne (TEST)" I specify that with the web form there is no problem. `[Fri Oct 14 09:23:00.827306 2022] [php:error] [pid 710552] [client CLIENT_IP:60431] PHP Fatal error: Uncaught mysqli_sql_exception: 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 'automne (TEST)',\n `date_creation` = '2022-10-14 07:53:27'\n WHERE `id` = '...' at line 2 in /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php:132\nStack trace:\n#0 /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php(132): mysqli->query()\n#1 /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php(478): pwg_query()\n#2 /PIWIGO_DIR/include/ws_functions/pwg.images.php(1102): single_update()\n#3 /PIWIGO_DIR/include/ws_core.inc.php(600): ws_images_add()\n#4 /PIWIGO_DIR/include/ws_protocols/rest_handler.php(41): PwgServer->invoke()\n#5 /PIWIGO_DIR/include/ws_core.inc.php(281): PwgRestRequestHandler->handleRequest()\n#6 /PIWIGO_DIR/ws.php(22): PwgServer->run()\n#7 {main}\n thrown in /PIWIGO_DIR/include/dblayer/functions_mysqli.inc.php on line 132` Here is an example of a photo that I can't upload : https://share.heraut.eu/f.php?h=1gGeSHGY&d=1: Thank you and have a nice day. <!-- github-sync-id:1408905743 -->

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#1533