I have a similar error if I do not use a blog name in the url.

i.e.
calstock.org.uk/?disp=mediaidx gives an error
calstock.org.uk/cabin/?disp=mediaidx does not give an error

UPDATE :: I have noticed that on some other blogs I do get the same error even though they use the same skin, so I may check the pluigns and widgets to see if they interfere.

However they all have the error

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ASC LIMIT 2000' at line 4(Errno=1064)

not the 1052 you have.

I'm working on the issue still and have found that if I delete a query the images appear.

file ~ /inc/widgets/widgets/_coll_media_index.widget.php

Line 273 274 I removed some spaces between lines 273 and 274 so the query was all on one line ~273

then I commented it out.

Will continue to look at the query to see why it causes an error (syntax)

UPDATE ::

If I only remove the last parameter ', link_ID '.$this->disp_params['order_dir'] I get your 1052 error so will focus on that variable.

BUT as I can get it to owrk on most of my blogs I must have done something to the one I have a problem on and it's not the skin.

Anyway that's agood few hours having fun but am stopping for today :)

We'll fix this asap.

@saunders @amoun Thank you for the report, we fixed the bug in commit https://github.com/b2evolution/b2evolution/commit/f18388a4193fce830be73a04dfb8fe030e4db439, screenshot:

@yurabakhtin Thanks for the fix. Works fine.
Regards and best wishes for happy holidays, Will