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 ?
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
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