sql error on node's "home" page. [#15790]

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: sql error on node's "home" page. [#15790]

Re: 2183 - sql error on node's "home" page.

by MiPi » Tue Jun 25, 2019 3:40 am

Thanks! I have found exact steps to reproduce all of this, tracked as: https://www.ventismedia.com/mantis/view.php?id=15790

sql error on node's "home" page. [#15790]

by Barry4679 » Mon Jun 24, 2019 2:29 am

https://www.dropbox.com/s/gbza80hnim5r4 ... e.png?dl=0

I clicked where shown, and got that sql error. ... Where clause is incomplete ... It happens with all albums on the page ... Artists are OK.

I had just altered the config for the EntireLibrary node (add visibility for the AlbumArtist sub-node, and move it up the pecking order). ... eg "Edit Collection.." ... I also toggled a few other sub-node indices on, then off .... then I tried to use the node I had just altered, and the sql error occurred.

This has happened to me before, in another version, but I could not figure out what caused it last time.

I closed and restarted MM5 ... it now looks like this https://www.dropbox.com/s/6q9v90nuq4lot ... e.png?dl=0

Both nodes are functional ... the sql error has gone away.

Top