Search function error after upgrade from 13.8 to 14.1 #1812

New Issue

Closed

opened 2026-10-05 00:57:34 +02:00 by adam · 3 comments

adam commented 2026-10-05 00:57:34 +02:00

Owner

Copy link

Copy source

After upgrade from 13.8 to 14.1 when I try search function I got error
"Unknown column 'search_uuid' in 'where clause' SELECT COUNT(*) FROM piwigo_search WHERE search_uuid = 'psk-20240109-8txoOz4znJ' ; in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 847"
No errors in upgrade_feed.php (0 upgrades to apply)

Environment

Before updating

 Piwigo 13.8.0 Check for updates
 Installed April 8, 2023, 9 months/months 1 day ago
 Operating system: Linux (Debian GNU/Linux 11 (bullseye))
 PHP: 7.4.33 (Show info) [2024-01-09 22:21:56]
 MySQL: 5.5.5-10.5.18-MariaDB-0+deb11u1 [2024-01-09 22:21:56]
 Graphics Libraries: GD 2.3.0
 Cache size 2068.42 MB now Refresh

After updating

 Piwigo 14.1.0 Check for updates
 Installed April 8, 2023, 9 months/months 1 day ago
 Operating system: Linux
 PHP: 7.4.33 (Show info) [2024-01-09 22:28:05]
 MySQL: 5.5.5-10.5.18-MariaDB-0+deb11u1 [2024-01-09 22:28:05]
 Graphics Libraries: GD 2.3.0
 Cache size 2056.59 MB   calculated now Refresh

After upgrade from 13.8 to 14.1 when I try search function I got error "Unknown column 'search_uuid' in 'where clause' SELECT COUNT(*) FROM piwigo_search WHERE search_uuid = 'psk-20240109-8txoOz4znJ' ; in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 847" No errors in upgrade_feed.php (0 upgrades to apply) Environment Before updating Piwigo 13.8.0 Check for updates Installed April 8, 2023, 9 months/months 1 day ago Operating system: Linux (Debian GNU/Linux 11 (bullseye)) PHP: 7.4.33 (Show info) [2024-01-09 22:21:56] MySQL: 5.5.5-10.5.18-MariaDB-0+deb11u1 [2024-01-09 22:21:56] Graphics Libraries: GD 2.3.0 Cache size 2068.42 MB now Refresh After updating Piwigo 14.1.0 Check for updates Installed April 8, 2023, 9 months/months 1 day ago Operating system: Linux PHP: 7.4.33 (Show info) [2024-01-09 22:28:05] MySQL: 5.5.5-10.5.18-MariaDB-0+deb11u1 [2024-01-09 22:28:05] Graphics Libraries: GD 2.3.0 Cache size 2056.59 MB   calculated now Refresh  <!-- github-sync-id:2073154758 -->

adam closed this issue 2026-10-05 00:57:34 +02:00

adam commented 2026-10-05 00:57:35 +02:00

Author

Owner

Copy link

Copy source

Can you show us the structure of your table piwigo_search ?
And also, the latest lines in your table piwigo_upgrade?

Can you show us the structure of your table `piwigo_search` ? And also, the latest lines in your table `piwigo_upgrade`? <!-- github-comment-id:1898265725 -->

adam commented 2026-10-05 00:57:36 +02:00

Author

Owner

Copy link

Copy source

For me it's an upgrade issue. Please run upgrade.php or see our upgrade guide https://piwigo.org/guides/update/manual

For me it's an upgrade issue. Please run upgrade.php or see our upgrade guide https://piwigo.org/guides/update/manual <!-- github-comment-id:1908091705 -->

adam commented 2026-10-05 00:57:37 +02:00

Author

Owner

Copy link

Copy source

On Thu, 18 Jan 2024 03:04:59 -0800
Pierrick Le Gall @.***> wrote:

Can you show us the structure of your table piwigo_search ?
And also, the latest lines in your table piwigo_upgrade?

Hello Pierrick
Thank You for the update.
Sorry I didn't reply, but I've been very busy lately and haven't had
time to debug the problem in the database.

Regards
Chrisopher

On Thu, 18 Jan 2024 03:04:59 -0800 Pierrick Le Gall ***@***.***> wrote: > Can you show us the structure of your table `piwigo_search` ? > And also, the latest lines in your table `piwigo_upgrade`? > Hello Pierrick Thank You for the update. Sorry I didn't reply, but I've been very busy lately and haven't had time to debug the problem in the database. Regards Chrisopher <!-- github-comment-id:1908132104 -->

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