Hi
Upgraded to Piwigo 14 and php8.3, mariadb 15.1, now I'm getting the following error when performing different operations on pictures' set. For ex, I add tags and get:
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 ')' at line 5 in include/dblayer/functions_mysqli.inc.php:132
Stack trace:
#0 include/dblayer/functions_mysqli.inc.php(132): mysqli->query()
#1 include/dblayer/functions_mysqli.inc.php(888): pwg_query()
#2 admin/include/functions.php(1854): query2array()
#3 admin/include/functions.php(1620): get_image_tag_ids()
#4 admin/batch_manager_global.php(112): add_tags()
#5 admin/batch_manager.php(814): include('...')
#6 admin.php(346): include('...')
#7 {main} thrown in include/dblayer/functions_mysqli.inc.php on line 132
Weird is that sometimes I repeat the operation and then it works. But not always.
I have 3 different installations on the same server, the problem is at least in 2 of them
Any clue? Tnx
Kinmen
Offline
Considering the function is add_tags, I guess it's when you perform the action to add tags to a selection of photos, right?
Do the photos already have the tag you try to add?
Offline
no they don't... btw this problem also happens when adding coordinates for example...
Offline
I don't reproduce the problem, but I'm not on PHP 8.3. I'm going to ask Willy.
Offline
thank you very much; note that it doesn't always happen but quite often, I could speculate 1/3...
Offline
Willy, on PHP 8.3, does not reproduce the problem neither. I'm contacting you in private.
Offline
finally I got some time to test... after update 14.1 the issue looks fixed. thank you
Offline