Piwigo.org

shami · 2024-02-29 02:25:47

Hello/Hi/Greetings,

when i open gallery photos, this fatal error shows. plz help to resolve this. Thanks

Fatal error: 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 /home/bestphot/public_html/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0

(Piwigo 14.2.0 Check for upgrade
Installed on 30 November -0001, 2024 years 2 months 4 weeks 1 day ago
Operating system: Linux
PHP: 8.1.27 (Show info) [2024-02-29 05:24:11]
MySQL: 8.0.36-cll-lve [2024-02-28 20:24:11]
Graphics Library: GD bundled (2.1.0 compatible)
Cache size 0 Mo   calculated 1 hour ago Refresh)

Piwigo URL: https://bestphotographer.ae

ddtddt · 2024-02-29 07:56:11

Hi :-)

I don't see this error

Only for admin error message ?

erAck · 2024-02-29 11:53:45

Unfortunately you omitted part of the error message that states the actual SQL query that fails. The "syntax to use near 'ASC'" though tells it is some sort order related so I presume it might be the dreaded "rank" vs "`rank`" problem mentioned several times in the forum. However, please provide the full message including the failing SQL statement.

shami · 2024-02-29 12:34:49

Fatal error: 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 /home/bestphot/public_html/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /home/bestphot/public_html/include/dblayer/functions_mysqli.inc.php(132): mysqli->query('\nSELECT DISTINC...') #1 /home/bestphot/public_html/include/dblayer/functions_mysqli.inc.php(888): pwg_query('\nSELECT DISTINC...') #2 /home/bestphot/public_html/include/section_init.inc.php(317): query2array('\nSELECT DISTINC...', NULL, 'image_id') #3 /home/bestphot/public_html/index.php(12): include('/home/bestphot/...') #4 {main} thrown in /home/bestphot/public_html/include/dblayer/functions_mysqli.inc.php on line 132

shami · 2024-02-29 12:37:30

It is not admin error. This error on most of gallery categories. While few are working fine.

OHappyDay · 2024-02-29 13:32:23

erAck · 2024-02-29 18:39:06

Odd that the actual SQL query is not partially output in the message. Anyway, are those albums sorted by ranking? Then switch them to any other sorting order and then back to ranking.
See also [Forum, topic 33397] Piwigo 2.8.2 database error and many others.

shami · 2024-03-01 01:00:47

Thanks for your kind reply
@erAck
@OHappyDay
@ddtddt

Actually I am not much familiar with coding and database. But from all your discussions , I conclude there may b something wrong with apparent setting of the galleries, like some title missing or some record missing. So I just swapped the sorting order of pictures in each gallery and submit , the problem is resolved.

Thank you guys :)

Piwigo.org

Announcement

#1 2024-02-29 02:25:47

error message when i open any gallery

#2 2024-02-29 07:56:11

Re: error message when i open any gallery

#3 2024-02-29 11:53:45

Re: error message when i open any gallery

#4 2024-02-29 12:34:49

Re: error message when i open any gallery

#5 2024-02-29 12:37:30

Re: error message when i open any gallery

#6 2024-02-29 13:32:23

Re: error message when i open any gallery

#7 2024-02-29 18:39:06

Re: error message when i open any gallery

#8 2024-03-01 01:00:47

Re: error message when i open any gallery

Board footer