Announcement

  •  » Extensions
  •  » batch manager error after upgrade

#1 2023-12-14 23:07:00

kinmen
Member
2018-12-17
43

batch manager error after upgrade

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

 

#2 2023-12-14 23:11:15

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13793

Re: batch manager error after upgrade

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

 

#3 2023-12-15 08:48:38

kinmen
Member
2018-12-17
43

Re: batch manager error after upgrade

no they don't... btw this problem also happens when adding coordinates for example...

Offline

 

#4 2023-12-15 12:36:17

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13793

Re: batch manager error after upgrade

I don't reproduce the problem, but I'm not on PHP 8.3. I'm going to ask Willy.

Offline

 

#5 2023-12-15 12:49:56

kinmen
Member
2018-12-17
43

Re: batch manager error after upgrade

thank you very much; note that it doesn't always happen but quite often, I could speculate 1/3...

Offline

 

#6 2023-12-15 13:34:55

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13793

Re: batch manager error after upgrade

Willy, on PHP 8.3, does not reproduce the problem neither. I'm contacting you in private.

Offline

 

#7 2023-12-15 17:11:54

kinmen
Member
2018-12-17
43

Re: batch manager error after upgrade

you got email, tnx

Offline

 

#8 2024-01-11 19:21:33

kinmen
Member
2018-12-17
43

Re: batch manager error after upgrade

finally I got some time to test... after update 14.1 the issue looks fixed. thank you

Offline

 
  •  » Extensions
  •  » batch manager error after upgrade

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact