item 'Categories' in Jdownloads throws an error - [Solved]

[orodenbu]

I run a site for our chamber choir where JDownloads is used for our musical scores. I recently got the running under J4 after building up the site locally, using Xampp. That went well.
On the 'live' site however (it's not really alive and kicking) I get this warning when selecting the menu item 'categories' : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Could someone tell me where I can find this SQL script ?

[ColinM]

Hi
I do not quite understand! Could you perhaps put it in sequence of what happens- or is it just that it happens as soon as you click on the menu item 'List All Categories' ?

I will send you a Private Message (PM)
Colin

[ColinM]

Hi
Having looked at the site the problem was effectively the List All Categories Menu item was located in an inaccessible menu that jD could not access.  Adding a 'hidden' menu item in the main menu solved the problem.
Colin