Textpattern CMS support forum

You are not logged in. Register | Login | Help

#31 2018-11-05 23:33:59

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,148

Re: Admin Search not working anymore since 4.7.0

etc wrote #314995:

I could tomorrow.

You have mail from my forum address.


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#32 2018-11-07 18:56:08

Kris
New Member
Registered: 2018-10-30
Posts: 5

Re: Admin Search not working anymore since 4.7.0

Bloke wrote #314997:

But just to be absolutely sure, your search options are set to search all facets of the article – all checkboxes on, or at least one of them on?

I could provide feedback regarding public search because we already have it integrated. For us, the public search for articles (incl. title) works without problems. (We run a small online shop for beverages using yab_shop plug-in)
On the admin side, “search” doesn’t work properly but we have to access all products stored as articles everytime we need to update prices so a working search functionality on the admin side is crucial. I played around with it:

If I turn all checkboxes on and use searchwords that I know are part of our section/category names, I get the message “Es liegen keine Ergebnisse vor” (=“there are no results”). If I uncheck the search facet “title, …” and use the same searchwords, I get normal results but obviously I can’t search for titles now.
Unfortunately, the search facet “title, …” is the most importent facet for us in order to keep our onlineshop running&updated.

EDIT: We’ve also been forced to update textpattern because Host Europe shut PHP 5.6 down.

Last edited by Kris (2018-11-07 18:58:54)

Offline

#33 2018-11-07 21:16:51

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 8,435
Website

Re: Admin Search not working anymore since 4.7.0

Kris wrote #315057:

If I uncheck the search facet “title, …” and use the same searchwords, I get normal results but obviously I can’t search for titles now.

Thank you for the excellent feedback that echoes what others have experienced. A few things off the top of my head we could work through and eliminate:

  • A common factor here may be non-English database content or collations. Things work fine for me with English search terms on English content. Does it specifically affect German? Anyone care to do some tests?
  • UTF8 might be a factor since we moved to utf8mb4. Or an incompatible collation. Dumping the textpattern table structure (DESCRIBE textpattern should do the trick?) and comparing it to, say, mine might give us some clues.
  • Something up with the Fulltext index on the textpattern table. Again, comparing indexes between working and non-working DBs might help.
  • Article corruption on upgrade. I’ve seen this before but it generally manifests itself on the public site. Articles just don’t show up but simply viewing it on the admin side and resaving each affected article makes them appear again. I wonder if a similar thing (resaving a few articles and searching for known words in them) might reveal any information.

Lots to think about and try. Anyone with a broken title/body/excerpt search, please see how many of these we can try so we can hone in on the problem. Thank you.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#34 2018-11-08 18:37:07

etc
Developer
Registered: 2010-11-11
Posts: 2,936
Website

Re: Admin Search not working anymore since 4.7.0

We have uploaded 4.7.2 on Uli’s Hosteurope server and it seems to work. I’m pretty confident 4.7.1 would too. Mystery…


etc_[ query | search | pagination | date | tree | cache ]

Offline

#35 2018-11-08 19:50:23

jakob
Moderator
From: Germany
Registered: 2005-01-20
Posts: 3,138
Website

Re: Admin Search not working anymore since 4.7.0

etc wrote #315099:

We have uploaded 4.7.2 on Uli’s Hosteurope server and it seems to work. I’m pretty confident 4.7.1 would too. Mystery…

Is that a new install or an update? It sounds like all the above reported cases are updated earlier versions? Can a failed or incomplete update have skipped some of the db index changes?


TXP Builders – finely-crafted code, design and txp

Offline

#36 2018-11-08 20:03:20

etc
Developer
Registered: 2010-11-11
Posts: 2,936
Website

Re: Admin Search not working anymore since 4.7.0

It’s an update from 4.6.2, with Umlauts in the db :-) We have not tried to update from pre-4.6. The admin-side search does not seem to use indexes anyway, though I’m not sure. A strange case.


etc_[ query | search | pagination | date | tree | cache ]

Offline

#37 2018-11-08 21:20:01

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 8,435
Website

Re: Admin Search not working anymore since 4.7.0

etc wrote #315104:

It’s an update from 4.6.2, with Umlauts in the db :-)

Nice sleuthing, thank you. I like that this is becoming more deterministic. Maybe during the conversion process to utf8mb4 (or during an ALTER TABLE operation) some encoding has taken place which screws up the FULLTEXT search? Or something causes that to clash with the collation such that searching the table does so in a non-binary way and MySQL is coming unstuck and shrugging its shoulders.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#38 2018-11-08 21:36:04

etc
Developer
Registered: 2010-11-11
Posts: 2,936
Website

Re: Admin Search not working anymore since 4.7.0

Dunno. Uli site is working, so, at least txp is Hosteurop compatible. We use FULLTEXT on the public side, and it seems to work for everybody in this thread. And this is plain weird.


etc_[ query | search | pagination | date | tree | cache ]

Offline

#39 2018-11-08 21:39:02

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 8,435
Website

Re: Admin Search not working anymore since 4.7.0

etc wrote #315112:

We use FULLTEXT on the public side, and it seems to work

Oh yeah, good point. That is very odd.

So how does, say, an article search query on the public side differ from the same search on the admin side, in terms of dumping the actual query?


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#40 2018-11-08 21:44:22

etc
Developer
Registered: 2010-11-11
Posts: 2,936
Website

Re: Admin Search not working anymore since 4.7.0

I think we order by MATCH(columns) AGAINST search_term on the public side, but not on the admin side. No trace of other use of FULLTEXT.


etc_[ query | search | pagination | date | tree | cache ]

Offline

Board footer

Powered by FluxBB