Skip to main content

Broken Search

!Friendica Support So I upgraded my Friendica node today, and the search seems to be broken.

Anything I type into the search box just yields a blank page in the result.

!Friendica Support
in reply to Jonathan Lamothe

Jonathan Lamothe
Jonathan Lamothe
• •
...and by blank, I mean a completely empty result. No HTML whatsoever.
in reply to Jonathan Lamothe

Sarah Brown
Sarah Brown
• •
@Jonathan Lamothe Have found a brief /usr/bin/mysqlcheck --all-databases --optimize -P<databasepassword> helps when this happens. Make sure Friendica isn't running when you do it.
@Jonathan Lamothe
in reply to Sarah Brown

Jonathan Lamothe
Jonathan Lamothe
• •

@Sarah Brown Since I have multiple databases and they all have different passwords, is there a way to specify the specific database, rather than --all-databases.

I suppose I can check the man page.

@Sarah Brown
in reply to Jonathan Lamothe

Jonathan Lamothe
Jonathan Lamothe
• •
@Sarah Brown Also, I'll try this tomorrow, but in the past, when it's been a database issue, there's been a long pause before the blank result was returned. This one is nearly immediate.
@Sarah Brown
in reply to Jonathan Lamothe

Hypolite Petovan
Hypolite Petovan
• •
@Jonathan Lamothe The stable release introduced several costly database updates since the search index has been reworked. Please make sure your database schema is up to date with bin/console dbstructure update. It should have been automatically updated with a run of the background worker but it's possible you have a different setup.
@Jonathan Lamothe
in reply to Hypolite Petovan

Jonathan Lamothe
Jonathan Lamothe
• •
@Hypolite Petovan Already checked. It appears to be up to date, but when I run that command it produces no output whatsoever.
@Hypolite Petovan
in reply to Jonathan Lamothe

Michael Vogel
Michael Vogel
• •
When you say "blank page", do you mean a white page without any content on it or do you mean that the system hasn't found any results? If this is the latter, then it is expected. We introduced a new table for the search index. This is built in the background and it will run some time (probably days).
in reply to Hypolite Petovan

Jonathan Lamothe
Jonathan Lamothe
• •

@Hypolite Petovan @Michael Vogel I'll have to check that when I'm at a real computer (I'm on mobile, ATM).

I'm wondering if I just need to bump up the memory available to MariaDB again. I've had to do that in the past.

@Hypolite Petovan @Michael Vogel
in reply to Jonathan Lamothe

Jonathan Lamothe
Jonathan Lamothe
• •
@Hypolite Petovan Forgot there was a web interface for the logs. Here it is:
Error: Call to undefined function Friendica\Util\idn_to_ascii() in /var/www/friendica/personal/src/Util/Network.php:543
Stack trace:
#0 /var/www/friendica/personal/src/Module/Search/Index.php(245): Friendica\Util\Network::convertToIdn()
#1 /var/www/friendica/personal/src/Module/Search/Index.php(131): Friendica\Module\Search\Index::tryRedirectToProfile()
#2 /var/www/friendica/personal/src/BaseModule.php(250): Friendica\Module\Search\Index->content()
#3 /var/www/friendica/personal/src/App.php(711): Friendica\BaseModule->run()
#4 /var/www/friendica/personal/index.php(55): Friendica\App->runFrontend()
#5 {main}

Looks decidedly not like a memory or database issue.
@Hypolite Petovan
⇧