adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

SQL -error with 15.0.0 #1967

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

After from 14.5.0 to 15.0.0 i see this after a click on one of the albums:

Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 7 in include/dblayer/functions_mysqli.inc.php:132 Stack trace:
0 include/dblayer/functions_mysqli.inc.php(132): mysqli->query('\nSELECT DISTINC...')
1 include/dblayer/functions_mysqli.inc.php(888): pwg_query('\nSELECT DISTINC...')
2 include/section_init.inc.php(317): query2array('\nSELECT DISTINC...', NULL, 'image_id')
3 index.php(12): include('/var/www/client...')
4 {main} thrown in include/dblayer/functions_mysqli.inc.php on line 132

I use MySQL on a server with PHP 8.2

After from 14.5.0 to 15.0.0 i see this after a click on one of the albums: > Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 7 in include/dblayer/functions_mysqli.inc.php:132 Stack trace: > 0 include/dblayer/functions_mysqli.inc.php(132): mysqli->query('\nSELECT DISTINC...') > 1 include/dblayer/functions_mysqli.inc.php(888): pwg_query('\nSELECT DISTINC...') > 2 include/section_init.inc.php(317): query2array('\nSELECT DISTINC...', NULL, 'image_id') > 3 index.php(12): include('/var/www/client...') > 4 {main} thrown in include/dblayer/functions_mysqli.inc.php on line 132 I use MySQL on a server with PHP 8.2 <!-- github-sync-id:2630532232 -->
adam closed this issue 2026-10-05 01:02:36 +02:00
adam commented 2026-10-05 01:02:37 +02:00
Author
Owner
Copy link
Copy source

Can you edit this album in the administration, go to the "photos sort order" tab and change options?

Can you edit this album in the administration, go to the "photos sort order" tab and change options? <!-- github-comment-id:2453379604 -->
adam commented 2026-10-05 01:02:38 +02:00
Author
Owner
Copy link
Copy source

Can you edit this album in the administration, go to the "photos sort order" tab and change options?

Thank you for reply! This did the job. It's visible now

> Can you edit this album in the administration, go to the "photos sort order" tab and change options? Thank you for reply! This did the job. It's visible now <!-- github-comment-id:2454057468 -->
adam commented 2026-10-05 01:02:39 +02:00
Author
Owner
Copy link
Copy source

I close this ticket

I close this ticket <!-- github-comment-id:2454058749 -->
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#1967