adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-11-03 07:22:22 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

PHP warnings/errors. #2200

New Issue
Closed
opened 2026-10-05 01:09:32 +02:00 by adam · 2 comments
adam commented 2026-10-05 01:09:32 +02:00
Owner
Copy link
Copy source

A friend came to me with the problem that his piwigo installation wasn't working after an upgrade... So we looked into that and seemed to have fixed it with adding the column "preferences" to the user_infos table.

So then I asked: Can you give me a "getting started with piwigo" tutorial. So I installed it on my own computer and we started importing photos.

After a while we got:

 PHP Warning:  Array to string conversion in /var/www/html/piwigo/include/functions_category.inc.php on line 162, referer: ... piwigo/admin.php?page=batch_manager&display=30
 PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'Array' in 'WHERE' in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php:132

which happens to be the exact same error that my friend was originally complaining about.

This is how I fixed it:

function get_cat_info($id)
{
  $id = is_array($id) ? $id[0] : $id;
  error_log("in get_cat_info: id is: " . print_r($id, true));

  $query = '
SELECT *
  FROM '.CATEGORIES_TABLE.'
  WHERE id = '.$id.'

Apparently get_cat_info is now called with an array instead of a single int as the "$id".

piwigo 16.3.0 (feb 24? downloaded zipfile from piwigo site).
Ubuntu 24.04,
php 8.3

My friend thought it was "version problems" so he downgraded piwigo to 15.x and php from 8.4 to 8.3. (on his ubuntu 25.10 system.)

A friend came to me with the problem that his piwigo installation wasn't working after an upgrade... So we looked into that and seemed to have fixed it with adding the column "preferences" to the user_infos table. So then I asked: Can you give me a "getting started with piwigo" tutorial. So I installed it on my own computer and we started importing photos. After a while we got: ``` PHP Warning: Array to string conversion in /var/www/html/piwigo/include/functions_category.inc.php on line 162, referer: ... piwigo/admin.php?page=batch_manager&display=30 PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'Array' in 'WHERE' in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php:132 ``` which happens to be the exact same error that my friend was originally complaining about. This is how I fixed it: ``` function get_cat_info($id) { $id = is_array($id) ? $id[0] : $id; error_log("in get_cat_info: id is: " . print_r($id, true)); $query = ' SELECT * FROM '.CATEGORIES_TABLE.' WHERE id = '.$id.' ``` Apparently get_cat_info is now called with an array instead of a single int as the "$id". piwigo 16.3.0 (feb 24? downloaded zipfile from piwigo site). Ubuntu 24.04, php 8.3 My friend thought it was "version problems" so he downgraded piwigo to 15.x and php from 8.4 to 8.3. (on his ubuntu 25.10 system.) <!-- github-sync-id:4038697106 -->
adam closed this issue 2026-10-05 01:09:32 +02:00
adam commented 2026-10-05 01:09:33 +02:00
Author
Owner
Copy link
Copy source

This happens here on Fedora Core 43, PHP 8.4, latest Piwigo 16.4.0 :( Every single time I assign to album via batch manager.

Adding $id = is_array($id) ? $id[0] : $id; right before $query ... fixes it.

This happens here on Fedora Core 43, PHP 8.4, latest Piwigo 16.4.0 :( Every single time I assign to album via batch manager. Adding ` $id = is_array($id) ? $id[0] : $id;` right before `$query ... ` fixes it. <!-- github-comment-id:5750962377 -->
adam commented 2026-10-05 01:09:34 +02:00
Author
Owner
Copy link
Copy source

MR : https://github.com/Piwigo/Piwigo/pull/2584

MR : https://github.com/Piwigo/Piwigo/pull/2584 <!-- github-comment-id:5750972210 -->
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#2200