Search?
!Friendica Support
Hi! My first message ever to a forum, so hoping this will work.
I have set up my own Friendica instance, and loving it so far. One thing though: do I have to do/enable something to get the "search" working for anything that isn't usernames (which I do find)?
If I search on something that is not a fediverse username, it consistently finds absolutely nothing. I have gone through all the settings in admin to ensure it isn't only searching "users" or "tags".
If I compare searching between Friendica and Pleroma (which I also run an instance of, on another server) the Pleroma instance finds absolutely anything in the Fediverse. Users, tags, free text content etc. I would like that on Friendica too. Is it possible? Have I misconfigured something?
I run the latest develop branch on my (Ubuntu hosted on Digital Ocean) server.
Hi! My first message ever to a forum, so hoping this will work.
I have set up my own Friendica instance, and loving it so far. One thing though: do I have to do/enable something to get the "search" working for anything that isn't usernames (which I do find)?
If I search on something that is not a fediverse username, it consistently finds absolutely nothing. I have gone through all the settings in admin to ensure it isn't only searching "users" or "tags".
If I compare searching between Friendica and Pleroma (which I also run an instance of, on another server) the Pleroma instance finds absolutely anything in the Fediverse. Users, tags, free text content etc. I would like that on Friendica too. Is it possible? Have I misconfigured something?
I run the latest develop branch on my (Ubuntu hosted on Digital Ocean) server.
Roland Häder likes this.
Friendica Support reshared this.
Sebastian Lasse, redaktor.me
•Steffen K9 🐰
•Mathias Hellquist
•I was also thinking I should "give it time" to announce itself on the fediverse or something, but now it has gone a couple of days. Everything works perfectly, except for the search.
utzer [Friendica]
•However it will only find local content, so you need to have post to find anything. To receive more posts locally you have to setup a relay or some relais. I'd suggest some Mastodon (ActivitiPub) relais and the last remaining diaspora relay. This will get you lots of posts over time, then you'll find more with your searches.
Mathias Hellquist
•In the field for relays there is a pre-populated value of https://social-relay.isurf.ca
Is that good/bad/wrong? Where do I find other/alternative relays?
I also notice "Direct relay transfer" is also "on" (checked).
"Relay scope" is set to "all".
If I compare to Pleroma search I can search on spurious/random words and it will find that word regardless of if it is in a username, a tag, a post etc. For example searching for "football" will return lots of content, none of which I have posted or interacted with (I'm not much of a football fan).
utzer [Friendica]
•Besides that there is AP relays, which you can currently just add by the bin/console, so you need to use the Linux CLI.
utzer [Friendica]
•How many active users are on the pleroma server, alls the posts of people the follow or the posts they interact with, are stored locally on the server, so theses will be searched too I assume.
Same for Friendica, if you follow more people or interact with more posts you'll have more local posts to search through. Same for other users on your server.
Mathias Hellquist
•Mathias Hellquist
•Are there any pointers/guides to "how-to" and what commands/values to use?
utzer [Friendica]
•There might not be much documentation about the AP relay, but you can see on your Friendica server under /help if there is something.
Mathias Hellquist
•In my log I have a bunch of entries that look like this, is it even related?
2021-02-06T07:44:23Z index [ERROR]: DB Error {"code":3065,"error":"Expression #1 of ORDER BY clause is not in SELECT list, references column 'friendica.post-view.received' which is not in SELECT list; this is incompatible with DISTINCT","callstack":"DBA::p, Profile::rawContent, call_user_func, Module::run, App::runFrontend","params":"SELECT DISTINCT(
parent-uri-id
) ASuri-id
,created
FROMpost-view
WHEREuid
= 2 AND NOTcontact-blocked
AND NOTcontact-pending
ANDvisible
AND (NOTdeleted
ORgravity
= 3) AND NOTmoderated
ANDwall
ANDreceived
> '2021-02-06 02:41:14' ANDprivate
!= 1 ORDER BYreceived
DESC"} - {"file":"Database.php","line":662,"function":"p","uid":"76430f","process_id":648036}Mathias Hellquist
•Mathias Hellquist
•Mathias Hellquist
•Also, as I ended up running the development branch of Friendica it could make sense. Then again, as it is only me on my instance it isn't "critical" for anyone else, so could also do as you suggest, stick to MySQL and report errors as and when they happen.
I have no idea what the db error I do get (above) actually impacts though.
Mathias Hellquist
•This was then coupled with it being almost nigh on impossible to re-install MySQL after having uninstalled it, and installed/un-installed MariaDB. Apparently I'm not the only one, so luckily there were enough examples of how to fix it so I finally could re-install MySQL and get my instance back up again.
I won't be doing that any time soon again. So, I guess it is "stick to MySQL and file DB errors then" hehe. :)
utzer [Friendica]
•yes, they are not compatible anymore sind MySQL 8, neither compatible to MySQL 7.x nor to #MariaDB.
Mathias Hellquist
•Might be worth updating documentation to highlight that.
For me, I'm not really sure how to go forward. Should I invest more time in the instance I have (building contacts etc) or should I scrap it and start over again? As I can't backup/restore the database and change from one to the other I am not looking forward to adding all contacts once again etc. Then again, "search" would be great to have. I can't right now for example use "saved searches" or follow tags etc, as they return exactly nothing.
Mathias Hellquist
•one question on that though: as I am "new" to Friendica I am currently not great (yet) at explaining what possibly go wrong. Sometimes I don't think too much about it. Yet I get a log entry.
My question becomes: Should I post the db error log entry to the issues even if I can't "explain" them? I'm thinking they quite probably make sense to you even if I don't know what it was trying to do and why/how it failed...:)
utzer [Friendica]
•I am not a programmer and I am not sure what it means that the compatibility was dropped with release 8.x, I was just looking at it because someone here asked if he can switch from MySQL to MariaDB and it turned out it is not as easy anymore starting from 8.x, the person in that case was still on 5.x, so maybe at that point the move would still be possible easily.
Also interesting that Ubuntu offers MySQL, or that Digital Ocean baked their own thing there and there wa... show more
I am not a programmer and I am not sure what it means that the compatibility was dropped with release 8.x, I was just looking at it because someone here asked if he can switch from MySQL to MariaDB and it turned out it is not as easy anymore starting from 8.x, the person in that case was still on 5.x, so maybe at that point the move would still be possible easily.
Also interesting that Ubuntu offers MySQL, or that Digital Ocean baked their own thing there and there was no choice if you need MySQL or MariaDB, especially if the two are not compatible anymore.
Maybe if you open the issue on Github mention the installation help that you used and raise the question if MariaDB should be the preferred DB or if still both are equal in the regard of support. Just to make devs aware of the problem.
Here is a lists that shows there is no compatible version.
https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/
Mathias Hellquist likes this.
extarys
•Mathias Hellquist likes this.
Mathias Hellquist
•Nanook
•