Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Search results do not appear
So it seems the reason the search isn’t working is maybe not to do with the database at all, but because the query isn’t even reaching the part of the page to perform the search. Or something. Hmmm.
*scratches head and stubble*
I wonder if the vendors/Textpattern/Search files will reveal anything. I think to narrow this down we’re going to need some low-level debugging.
Do you mind providing me with some file-access credentials so I can poke around your Textpattern installation and upload a few tweaked Txp files to try and figure out what’s going on? Or shall we carry on back-and-forthing here trying to find where things are going sideways?
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline
#17 2020-02-27 12:13:09
- saccade
- Plugin Author
- From: Neubeuern, Germany
- Registered: 2004-11-05
- Posts: 521
Re: Search results do not appear
I’ll send you access :)
Offline
Re: Search results do not appear
Thanks to Michael’s generosity at letting me use his server, I’ve narrowed it down. This is actually an issue with the volume of data in the textpattern table and a host-imposed setting to protect the shared hosting environment. Our admin-side search query is choking thus:
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
We need to find a way to fix this in core so the queries are less hungry, or in some way manageable. For anyone hitting this issue, we apologise, and will try to find a fix.
Last edited by Bloke (2020-02-27 16:51:10)
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline