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.

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

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.

I was having a similar problem.  I discovered the problem was with albums that had a manual sort. (Unfortunately this is most of my albums :()
After trying some other sort options, I discovered that all I needed to do to fix the problem was go into the album's Photos sort order, and just hit Submit at the top by the manual sort pictures.
Apparently this resubmitted my original manually chosen sort order and in doing so fixed whatever was off in the sql.

I hope this might help other folks.

And thanks for the above replies that got me this far!

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

(If there was more to the error message I can't see it . . . but since the above seems to fix things, I'll be working on the fix rather than trying to recreate the errors :)