Skip to main content

Friendica Support reshared this.


DBStructure update


!Friendica Support Sorry if this has been addressed already and I missed it in my search. I may have been a version or two behind before getting the latest in the past few days, however, I'm getting an error and set into maintenance mode.

bin/console dbstructure update produces the following:
[Error] SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`social`.`item`, CONSTRAINT `item_ibfk_4` FOREIGN KEY (`psid`) REFERENCES `permissionset` (`id`))

I am able to turn off maintenance mode and seem to use without errors.

Anyone have ideas or suggestions?
@Michael Vogel commented out the line and then successfully completed the dbstructure update. Things are looking well!!! Thank you very much for your patience and help, as always!!

@Hypolite Petovan @Brian I hadn't considered how much of that movie could be told with emoji! 🤣🤣
I guess most movies can be evoked this way. It wouldn't make much sense to people who didn't watch the movie though



Finally, it seems that the Autumn weather is here! (Hopefully to stay) I've been patiently awaiting cooler temperatures and being able to wear hoodies again :-D
This entry was edited (3 years ago)


I recently got a connection request from someone who had an instance a while back, and apparently recently restored it. However I cannot accept, because my user data seems to still be in their database, so the request/accept fails.

@Gabe are you seeing this mention?
The more common term is “node” for Friendica instances.
True indeed. Yes, he had an "installation" running his own friendica node, and recently it seems got it back up and running. :-D



My Pixel3 finally got the Feb 5th security update today. Which basically reminded me that, other than waiting for it to be available, I have no recollection of what's new in it...

#pixel3 #googlefi





19/20

A fun project to help us learn about each other.
20 films that had an impact on you, for the next 20 days.

Only post a pic. No film title or comment. Number them and use the hashtags below.

#20MovieChallenge #movies #film

I wanna be buried same way like guy from this movie




16/20

A fun project to help us learn about each other.
20 films that had an impact on you, for the next 20 days.

Only post a pic. No film title or comment. Number them and use the hashtags below.

#20MovieChallenge #movies #film




14/20

A fun project to help us learn about each other.
20 films that had an impact on you, for the next 20 days.

Only post a pic. No film title or comment. Number them and use the hashtags below.

#20MovieChallenge #movies #film





8/20

A fun project to help us learn about each other.
20 films that had an impact on you, for the next 20 days.

Only post a pic. No film title or comment. Number them and use the hashtags below.

#20MovieChallenge #movies #film




6/20

A fun project to help us learn about each other.
20 films that had an impact on you, for the next 20 days.

Only post a pic. No film title or comment. Number them and use the hashtags below.

#20MovieChallenge #movies #film

Who would've believed Woody of Cheers would have gone so far!!! :D thumbs up





5/20

A fun project to help us learn about each other.
20 films that had an impact on you, for the next 20 days.

Only post a pic. No film title or comment. Number them and use the hashtags below.

#20MovieChallenge #movies #film



3/20

A fun project to help us learn about each other.
20 films that had an impact on you, for the next 20 days.

Only post a pic. No film title or comment. Number them and use the hashtags below.

#20MovieChallenge #movies #film









Wow, I am super happy seeing all the new nodes springing up lately. From my last recollection, the list at the-federation.info went from 48 to 62 during the last months!




Just received the notification and the post.


When one is attending a web meeting and eating M&Ms, one must remember to put oneself on mute!



This week may very well provide the motivation to finish this bottle!
This entry was edited (5 years ago)



Well, it looks like today is the day. I've moved everything I can think of from this #server over to the "new" server. Some things were easy and some took more time than I thought, #Openfire took more, and #NextCloud took less. The last thing before I flip the switch on the router is ~friendica ~friendica. Here's hoping it goes smoothly!
This entry was edited (5 years ago)


Finally went to see this last night! I quite enjoyed it :-)



Happy Thanksgiving to all my friends who celebrate it! For those of you who don't Happy Hackathon weekend! :-D


Is it just me, or is it more fun working on code for ~friendica ~friendica than it is working on code for work? :-)
This entry was edited (5 years ago)