SQL problem

@Friendica Support Heute morgen lag mein friendica platt. Arghhh. Ein MYSQL problem anscheinend

Incorrect key file for table '/tmp/#sql_daf_0.MY I'; try to repair it

Irgendwelche queries die man letzte zeit geanderd hat? Anscheinend hat sich da ein riesen TMP von +10gb aufgebaut.
Oliveira do Hospital (CO) 26.1% german, 20.6% english, 20.2% dutch
8 comments show more
Es gibt einen Datenbank-Befehl "Optimize Table". Man kann das auch für eine gesamte DB ausführen:

mysqlcheck -u [username]-p [password]-o [database name]
29.2% german, 16.9% dutch, 15.7% danish
Das dachte ich schon, ja hab ich gemacht mal sehn was das log jetzt ergibt
27.5% german, 21.2% dutch, 19.3% estonian
Folks; yesterday I stumbled across the #friendica app found on f-droid ( , and was pretty amazed to see what it already can do, but it doesn't seem to work _completely_ well. Though on I can read entries and post new entries too (good), I cannot see who liked or "starred" entries same way I cannot do so on any entries I see; in there, I only see an "Invalid dataset!" message next to the thumbs-up/thumbs-down/star controls. Looking at the page however it seems this app has seen its last update in mid-2013 so this might not be a fault of the app at all but just a matter of things having changed in Friendica API since then. Does anyone know about this app, its maintainer and its current state? Given the fact that I really would use friendica more on my mobile and twidere is not really all the time, I wonder whether this app might be a way to go... ;)
35.3% english, 25.6% pidgin, 20.9% german
10 comments show more
@heluecht I asked Dan Velazco who brought us tinfoil for facebook if he could tweak that for Friendica. See
22.6% english, 18.3% danish, 17.4% norwegian
@tugelblend @Max Maybe you could join forces with Dan Velazco. His Tinfoil for Facebook is great. See
23.6% english, 17.5% danish, 15.3% pidgin
@Michael Vogel @Friendica Support
Michael, ich weiss nicht, ob das mit der API zu tun hat, aber dieser Beitrag von @Tobias wird bei Twidere so angezeigt:


Mir war das neulich schon einmal aufgefallen bei einem Beitrag von Tobias, hatte das aber als "Kann ja mal vorkommen" gewertet ;-) Habe ich bisher aber nur bei Tobias gesehen.
Schleswig-Holstein - Der echte Norden 28.5% german, 20.9% dutch, 15.5% danish
15.1% spanish, 14.5% portuguese, 14.3% english
Ah, known Issue
13.1% indonesian, 11.9% somali, 10.8% azeri
@Friendica Support After the upgrade to version 3.3 I'm not able to use friendica on Android. Neither with the Android Browser nor with Firefox (aka Fennec) I'm able to post something. I think there is some problem with the JavaScript code that is executed. Anyone else?
Bordesholm 28.3% english, 20.1% danish, 19.6% french
16 comments show more
Dennis 3 days ago Friendica Und in den Passwörter Optionen hast du einen Haken gesetzt für Passwörter merken, und trotzdem merkt der Tint Browser sich die nicht?
36.3% german, 24.5% dutch, 21.1% danish
37.3% dutch, 33.2% german, 27.3% latin
@Michael Vogel @Friendica Support

Michael, zu meinem Statusnet Problem (erst wurden keine Kontakte von Statusnet in Friendica angelegt, und dann auch keine Post mehr gesendet und empfangen). Als letztes war, das Du ein Pull Request gemacht hast, um die Debug Meldungen etwas aufzupolieren. Ich weiss zwar nicht, ob das bereits durch ist, poste aber dann doch schonmal einen Teil des Tracelogs, vielleicht kannst Du ja damit was anfangen beizeiten.

------------------- schnipp ----------------------
2014-10-21 17:40:20@ [NORMAL]:statusnet.php:748:statusnet_cron statusnet: cron_start
2014-10-21 17:40:20@ [NORMAL]:statusnet.php:753:statusnet_cron statusnet: fetching for user 12
2014-10-21 17:40:21@ [NORMAL]:statusnet.php:753:statusnet_cron statusnet: fetching for user 1
2014-10-21 17:40:21@ [NORMAL]:statusnet.php:761:statusnet_cron statusnet: importing timeline from user 12
2014-10-21 17:40:21@ [DEBUG]:statusnet.php:128... show more
Schleswig-Holstein - Der echte Norden 21.1% german, 19.9% english, 18.7% danish
8 comments show more
Das ist ein Support Channel und keine Smalltalk-Runde. Wir sind hier nicht auf 140 Zeichen beschränkt! Ausserdem hat Twidere eine sehr starke Filtermöglichkeit.
37.7% german, 22.7% norwegian, 21% danish
Zu den Kontakten werde ich noch ein erweitertes Logging einbauen, damit wir die Ursache finden.
40.9% german, 29.5% dutch, 18.6% norwegian
Daniel 7 days ago Friendica
Updated friendica to 3.3 today. Thanks for your hard work devs.
No problems until now :)
22.1% english, 17.6% pidgin, 16.3% danish
6 comments show more
Daniel 6 days ago Friendica
No statistics plugin. I know, I forgot to download and install the addons. They are not in the main release right?
38% english, 32.2% pidgin, 23% italian
Yeah, you have to update the addons separately.
37.5% english, 19.6% albanian, 18.4% french

Wall to wall post

Hi there!
General question.
If I post on my network or home page

Tupambae: Tecnical Support
@Friendica Support Test post wall to wall to check the conection with friendica support. This account was already related to the forum but had problems with the connection so I deleted all contacts and try to establish all conections from scratch.

shouldn't it become a wall to wall post to over here at friendica support?
Why does this post from diaspora shows up but not mine from within the friendica network?
31.5% english, 19.7% pidgin, 19% latin
9 comments show more
And the post is displayed as from

Is the NSA standing on the my wires or is it the BND?
30.4% english, 20.1% pidgin, 19% latin
Big question is: What are the logfiles telling? Are you having PHP errors in your PHP log file? What about the friendica logfile? Do you see things like "delivery: invoked:"? And do you see things like "notifier: dfrndelivery: Friendica Support" in your logfile?
29.2% english, 22.4% french, 21.6% pidgin
Tolles Plugin.
Fehlt noch eine Version für #wordpress

#linktip #friendica #diaspora

Uberspace: New addon "Leistungsschutzrecht"
@Friendica Support @Friendica Developers I just created a new addon, called "Leistungsschutzrecht". It is a function that helps with one of the dumbest laws ever made in germany:
19.3% english, 14.1% pidgin, 13% dutch

New addon "Leistungsschutzrecht"

@Friendica Support @Friendica Developers I just created a new addon, called "Leistungsschutzrecht". It is a function that helps with one of the dumbest laws ever made in germany:

The addon looks if an address is from one of the members of the "VG Media" (the ones who want money for snippets) and removes all but the title and address from the parsed address.

The sites are taken from the list of the VG Media:

It seems to work fine. But: I needed a new hook for that. So the question is, what to do? If I only merge it with the "develop" branch, then we shouldn't do the release in one year., but maybe one month?
30.2% english, 20.3% pidgin, 19.6% german
4 comments show more
Tobias 1 week ago Friendica
At least having the option to check version dependency would be an idea. Addons not having that information in the addon header should defauöt to "useable with this version".
40.3% english, 22.7% dutch, 20.8% danish
Sounds like a good idea.
24% pidgin, 19.1% hawaiian, 16.2% french
@Friendica Support Today I added some Diaspora contacts. For this I used the "Add New Contact" text input field unter the Contact Tab. Problem: for every new contact my account posted a notification about the new contact like

But I didn't wanted that as I have configured my setting:

So what's going wrong? Did I made a mistake or is this a bug? I think I never had this problem when I've added a ~friendica ~friendica contact.
Bordesholm 27.5% english, 20.8% pidgin, 16.6% french

Testing friendica 3.3 update

Hi their,
working on the webhosting setup. We updated from 3.1 to 3.3 and are resetting at the same time our webhosting to a single friendica hosting. That means beside the problems that might be because of the update some others might depend on other issues. This post is a wall to wall post, the last help request by was posted visiting the Helpers Forum. That post isn't visible most of the time and doesn't show up in the public stream of the helpers forum.

Besides the IP problems we are working on webhosting side some problems still appear nearly "since ever". As you can see in the screen snippet of the quattro theme forum display, half of the links don't display correct the avatars and visiting those links nearly ever create a recognized visit to the forum pages. I believe that this is due to the use of with and without SSL (http/https) so that somehow the links are wrong. The last few days I also used access over IP like... show more
38.1% english, 26.1% pidgin, 20.2% dutch
4 comments show more
it just doesn't make sense
32.9% pidgin, 26.3% danish, 25.9% english
It makes sense if you consider that URLs are stored in the database. If those URLs later change, then the database still stores the old (invalid) URLs.

Possibly fixable through database plumbing, but that's a lot of extra effort that can be avoided if we just pick http or https and our domain name, then stick with that.
31.9% english, 18.7% norwegian, 18% danish
Guten Morgen,
ich versuche gerade, auch durch Nutzung der Suchmaschine meines Mistrauens, herauszufinden, wo denn bei friendica genau der Unterschied zwischen einem Normalen Server und einem Forum ist.
Das Outfit herkömmlicher Foren ist ja etwas anders, daher verstehe ich das noch nicht so genau, denn auch der "Friendica Support" sieht ja optisch kaum anders aus.
Vielleicht kann mir das jemand erklären, das wäre echt nett.
Gruß Jörg
27.4% german, 20.3% danish, 18.6% norwegian
15 comments show more
Was musst du da nun machen ? Bloß von A nach B kopieren oder ist da mehr zu tun ?

Geht das automatisch ?
32.9% german, 20.2% dutch, 18.9% french
Tobias 2 weeks ago Friendica
die einzelnen mesage.po Dateien müssen in das von friendica verwendete Format überführt werden und dann an die richtige Stelle im kopiert werden. Das cal ist ein Beispiel für die Verzeichnis-Struktur bei den Übersetzungen der Addons.

Das Prozedere der Übersetzung (für friendica-core) ist in der README.translate beschrieben.
38.1% german, 27.4% dutch, 26.1% danish
Hello all, this is Oliver, the helpers-forum admin. I just got done purging all the dead accounts (234) from the forum.
Did I delete your connection by mistake? Sorry. Please reconnect.
32.9% english, 25.9% pidgin, 21.1% latin
4 comments show more
Just got a warm welcome on the forum page accessing over the forum avatar in my forum section. Thats an improvement right now. :-)
36.2% english, 34% pidgin, 22.9% german
Keine Ahnung I have, gekriegt dein message I have, denke mal das ich noch dabei bin I do.
32% german, 24.9% danish, 23.2% dutch
@Friendica Support Hi their, I need help as my update from 3.1 to 3.3 somehow got stuck after log in. I get a 404 (page does not exist) in /network page. The .htaccess doesn't work for my webhosting and I'm using an older version that fit's apparently.
This is the site:

Any Ideas?
Tupambae: Tupambae.Net
27.7% english, 19.9% danish, 19.3% pidgin
4 comments show more
23.7% icelandic, 17.4% dutch, 16.1% danish
This is already "old" i got some access over the friendica network. thx Roland anyway!
30.7% english, 23% pidgin, 17.1% danish

php5-imap on Ubuntu 14.04 is not enabled

@Friendica Support Please add this to the git wiki as it differs from normal module install. To install the imap module on Friendica these steps required are:

sudo apt-get install php5-imap
sudo php5enmod imap

sudo service apache2 restart

Oliveira do Hospital (CO) 26.7% english, 19.6% french, 19% spanish
Dennis 2 weeks ago Friendica
@Friendica Support @Friendica Theme Developers

Where to set the language for a user in the vier theme?
37.2% english, 29.3% norwegian, 27.9% danish
5 comments show more
OK that's fine we know now whom to hold responsible ;)
30.3% english, 21.7% pidgin, 13.1% slovak
Dennis 2 weeks ago Friendica
What about putting a language menu in the settings?
39.5% english, 27.5% norwegian, 25.9% danish
Seth 2 weeks ago Friendica

"Community" tab never seems to update, is it possible to disable or just do away with it?

For some reason the community tab on my Friendica instance does not update. It has been frozen in time as per the screenshot for many months now.

Even when it does work I never use it. Is it possible to disable the tab or just do away with it entirely?


@Friendica Support
27.5% english, 24.4% pidgin, 19.9% italian
admin/site/Show Community Page
24.8% albanian, 22.8% italian, 21.3% romanian
Seth 2 weeks ago Friendica
Ah! Of course I missed that.

Thank you Keith, you are el hombre.
31.4% english, 16.6% hawaiian, 14.8% french

No admin access

Gerade ein neues install gemacht nach gitclone und configuration kein admin Zugang.
27.9% german, 22.9% latin, 21.9% english
Admin direct gibt nu eine Lehre Zeit mit Logoff button
25.1% german, 18.5% french, 17.1% italian
Habs schon, es war Options All
41.9% english, 29.7% french, 27.8% german
@Friendica Support was geht ab, komm nich am log ran

replace_macros: unable to write file view/smarty3/compiled/wrt543905bab7d2d3_96522116

die rechte stehn aber gut. Rest lauft prima.
Oliveira do Hospital (CO) 22.7% german, 21.4% english, 21.1% french
Waaah! Twidere stopped connecting to my instance! Did anything change in the api or did I make a mistake when I added a new vhost to my webserver? Am I the only one?

@Friendica Support
33.1% english, 23.7% pidgin, 21.1% italian
7 comments show more
Ähem... my bad... the order of adding sites to the webserver... tralalalaaaa...
30.9% english, 24% pidgin, 18.8% portuguese
55.2% english, 16.8% danish, 16.6% dutch

[Closed] [Fixed] Corrupt Message?

About 48 hours ago, suddenly my "Everybody" and "friends" streams present "Internal Server Error" messages. I have other streams that I can view fine. I thought maybe it might be something from the @Friendica Support forum, but when I moved that contact to a newly-created stream, it shows up fine.

I turned on logging:
Non-helpful log excised.
12.4% italian, 10.6% swedish, 10.3% english
New discovery. This happened around the same time that @Seth Martin made some changes in his server. On a hunch, I placed his account in a new group and everything (except that new group) displays okay.

I'll repair or reconnect with him and mark this #fixed and #closed.
32.7% english, 20% pidgin, 18% german has been experiencing frequent 504 Gateway Time-outs recently.
24.6% english, 20.1% spanish, 19.3% pidgin
Seth 2 weeks ago Friendica

Finally finished migrating Friendica instance to nginx

@Friendica Support
@Public Stream

Haven't seen any network updates on my network tab since then however. Could that be because I originally made all the connections when my server was HTTP only?

I am using a certificate for TLS...hopefully that is not a problem.

If you see this message, please post a reply so I can see if two-way communications are working.
32% english, 21.8% pidgin, 19.4% french
21 comments show more
Other changes for 5.6 are that Innodb cannot be disabled.
For a MyISAM only databases with 5.6 use
innodb_buffer_pool_size = 5M
This keeps innodb memory to a minimum, values under 5M still give 5M
Also full text search is possible with InnoDB.
29.9% english, 19% pidgin, 17.9% danish
Possibly a similar procedure I had to use when using a 5.6 database with 5.5.
Use mysqldump to get a dump of the database with mariadb 10.10 (5.6 in my case),
then with Percona 5.6 recreate the database with the file from the mysql dump (5.5 in my case). Keep an extra backup of the database.
27.3% english, 21.4% pidgin, 20.4% italian
@Friendica Developers , @Friendica Support

I seem to have inadvertently recreated the problem of looping comments. And I have no clue why.

The comment repeats every ten minutes (this is the interval at which I run the poller). The thread link is here: . But it was originally created on ~friendica ~friendica at . The original post does not repeat, but my comment to it does.

@Tobias earlier spotted that I hadn't configured the plugin correctly and I have now fixed this. Yes I copied and pasted the site name from the admin site panel into the configuration item:

$a->config['pumpio']['application_name'] = "";
Sebastopol, California 27.6% english, 18.9% italian, 18.4% pidgin
I have turned off the plugin for now.
34.6% english, 22.3% danish, 18.1% pidgin
@Friendica Support
Ist die Verbindung zu Statusnet broken? Seit dem 05.10. werden bei mir weder Messages gesendet, noch empfangen über friendica *stirnrunzel*

Twitter, und Diaspora funktionieren wie gehabt (bei mir)
Schleswig-Holstein - Der echte Norden 34.4% german, 24.9% dutch, 21.6% norwegian
11 comments show more
Ich hab es vor 3 Tagen mit Quitter problemlos einrichten können, hatte aber Probleme mit 3 anderen Servern. Auf zweien hab ich überhaupt keine Verbindung bekommen, auf einem konnte ich nur Nachrichten empfangen, aber nicht senden (löschen ging aber).
35.3% german, 27% dutch, 23.9% danish
@ddorian Bei mir ist es ja so, das es ein paar Monate lief, und dann vor ein paar Tagen den Dienst eingestellt hat. Das ganze ohne das ich an der Konfiguration was verändert habe.
37.5% german, 30.2% dutch, 26.4% danish
Folks, is there a way to follow tags / categories and always see new content in my networks the way it works in D*?
42.2% english, 26.9% pidgin, 24.1% german
4 comments show more
Aaah I see. Thanks for pointing me there. :)
39% english, 35% norwegian, 31.3% danish
Although I'm always thinking about making this possible :)
27.5% english, 17% pidgin, 13.7% latin


@Friendica Support: Foto-Upload from Android phone not working.

Am I the only one with this problem? For my it is not possible to upload a photo into an album. Error is „This file extension is not allowed“. Maybe something how Android sends files to a server? Friendica says the filename is like „image%3A2168“.

This is from the log file:
[DATA]:photos.php:95:photos_post mod_photos: REQUEST Array
[q]=> photos/ts
[album]=> Pinnwand-Bilder
[not_visible]=> true
[qqfile]=> image%3A2168
[DATA]:photos.php:96:photos_post mod_photos: FILES Array
[]:js_upload.php:155:js_upload_post_init mod/photos.php: photos_post(): error uploading photo: Die Dateiextension ist nicht erlaubt, sie muss eine der folgenden sein jpeg, gif, png, jpg.
Bordesholm/ Eiderstede ✶ Kiel 26.8% english, 21.8% pidgin, 17.7% danish
9 comments show more
Lol was waiting for that one. Now we can put Closed in the subject
46.7% english, 28.9% pidgin, 22.8% norwegian
55.8% pidgin, 52.6% italian, 50.3% latin

Flickr support?

Folks; is there any way to link Friendica with Flickr? Didn't manage to find it in the settings; unsure whether it's a plugin or not possible so far.
33.7% english, 26.2% pidgin, 19.9% danish
6 comments show more
If there is an API, there is a way :) Question always is, in which way it should work. Posting pictures to a default album will be possible, I guess.

If there is a possibility in flickr to follow some users, it should be able to get new picture, when they are published. Everything else depends upon the API.
35% english, 23.6% pidgin, 17.5% danish
@heluecht Filed a feature request. Guess many of these things are possible using their API, but the TOS look a bit...strange. :/
29.6% english, 19.2% pidgin, 17.9% french

Facebook: Postings to private groups could be synced accidentally

@Friendica Support @Friendica Developers I just posted a video to a private facebook group (I used the facebook web page). Even though the posting was private (according to the settings of facebook) the mirroring function of friendica had distributed it around the world ...

I haver to investigate, whether this is a bug in the mirroring function or between my ears :)
32.5% english, 20.4% pidgin, 18.3% french
26.3% english, 22.7% italian, 15.1% latin
22.6% pidgin, 22.2% english, 18.2% french
3 comments show more
17% pidgin, 14.7% english, 11.9% italian

DNSBL something for friendica?

@Friendica Support Just sharing some code while testing the bb-code. This little gadget will look for attacks on your webside and send anyone suspicious to the blacklist where he is listed. You will be needing php_net_dnsbl and dependencies for this installed. It leaves a nice clickable log to check whoes been refused by setting $filename through the function you put this in. Anyone up for adding dnsbl to Friendica?

function testbl($filename){
if(!$_SERVER['REMOTE_ADDR']) return;
$testip = $_SERVER['REMOTE_ADDR'];

require_once '/usr/share/php/Net/DNSBL.php';
$dnsbl = new Net_DNSBL();
$dnsbl->setBlacklists(array('', '','', ''));
if ($dnsbl->isListed($testip)){
$txta=explode(" ",$blref[0]);
header("Location: ".$blref[0]);
Oliveira do Hospital (CO) 27.3% english, 18.9% pidgin, 15.5% danish

DNSBL something for friendica?

@Friendica Support Just sharing some code while testing the bb-code. This little gadget will look for attacks on your webside and send anyone suspicious to the blacklist where he is listed. You will be needing php_net_dnsbl and dependencies for this installed. It leaves a nice clickable log to check whoes been refused by setting $filename through the function you put this in. Anyone up for adding dnsbl to Friendica?

function testbl($filename){
if(!$_SERVER['REMOTE_ADDR']) return;
$testip = $_SERVER['REMOTE_ADDR'];

require_once '/usr/share/php/Net/DNSBL.php';
$dnsbl = new Net_DNSBL();
$dnsbl->setBlacklists(array('', '','', ''));
if ($dnsbl->isListed($testip)){
$txta=explode(" ",$blref[0]);
header("Location: ".$blref[0]);
Oliveira do Hospital (CO) 27.3% english, 18.9% pidgin, 15.5% danish
x0ma 2 weeks ago Friendica
I would be interested in testing this out. Can you give a bit more instructions on how to do it, and the dependencies needed? Thanks.,
46% english, 24.8% danish, 23.5% pidgin

working with tags.

Looking at profiles (like my own), I see things such as "Tags" in which I, well, tend to use hashtags, but it seems they're not "clickable" links so don't allow for any sort of navigation. Is this intended? Copy/posting any of the hashtags (including the #) to the search box works however, so having the hashtags mere hyperlinks to toggle a search for this tag would be nice to have.
34.4% english, 25.7% pidgin, 16.9% german
3 comments show more
Andreas, thanks for your comment. :) Well that's more or less the way I thought it to be. Just wondering why the user interface doesn't treat tags as something "linked" to anything else, be that in public tags or in textual descriptions (like G+ or Diaspora do).
33.7% english, 27.2% pidgin, 21.1% norwegian
27% latin, 26.8% tagalog, 25.9% english

d* integration?

Folks; feeling dumb for eventually asking the obvious, but is there any way setting up Friendica (I am on to cross-post to Diaspora* the way I can cross-post to Twitter or FB? What to do to make this work?
32.1% english, 30.8% pidgin, 18.2% spanish
10 comments show more
If you have a feature request:

if you want to discuss, if there is need for e special feature, then please use this group.
31.3% english, 20% pidgin, 19.8% spanish
Ok, I will keep that in mind, thanks. :)
32.6% english, 20.8% indonesian, 20.3% danish

Email setup

@Friendica Support looks like I got the bugger finaly going. (Wiping sweat of forehead.)
Oliveira do Hospital (CO) 23.5% english, 19.3% pidgin, 18.9% norwegian
Fabio 4 weeks ago Friendica
@Hackathon Berlin 2014 @Friendica Support @Friendica Developers

Anyone is using "multidomain" settings with friendica?
We are thinking about removing it, because security...
(see )


I would release 3.3 this week, after this last change.
27.7% english, 20.1% pidgin, 16.2% french
82 comments show more
Fabio 2 weeks ago Friendica
I thought it was a bookmark like thingy, you should be able to change the popinter at which a bookmark is pointing towards.

I could, but it's already out, let's people which already updated know that there is a little update to the update...

For the addons we are keeping the "master" - without a "develop"?

ATM friendica-addons repo is not tagged and not branched...
34.6% english, 21.2% pidgin, 17.5% dutch
Beanow 1 week ago Friendica
@Tobias you can "move" a tag by removing it locally, adding it on a new commit and pushing your tags. It's considered bad practise for versions though afaik.
33.5% english, 19.9% french, 19.1% danish

email problem

@Friendica Support What goes wrong here, I used email notation to add a contact like mailto:user@domain.tld

Oliveira do Hospital (CO) 23.6% english, 19.3% italian, 19.1% french
3 comments show more