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:
I am able to turn off maintenance mode and seem to use without errors.
Anyone have ideas or suggestions?
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?
I guess most movies can be evoked this way. It wouldn't make much sense to people who didn't watch the movie though
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?
@Gabe are you seeing this mention?
True indeed. Yes, he had an "installation" running his own friendica node, and recently it seems got it back up and running. 


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
kograt likes this.
The Nexus 5X and Nexus 6P may have just received their last updates - Android Authority
The Nexus 5X and Nexus 6P may have just received their last updates
Now over three years old, the Nexus 5X and Nexus 6P are Google's last two Nexus smartphones.www.androidauthority.com

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
Oh Come On, Apple Could Have Made the 'New' MacBook Air Years Ago
Oh Come On, Apple Could Have Made the
There’s this weird sort of fervor that surrounds the MacBook Air that I’ve never fully understood. Sure, when Steve Jobs pulled the first one out of a manila envelope in 2008, it was cool as hell. But in the 10 years since then, Apple’s once industry-leading laptop was neglected and abandoned to the point that it became a running joke.gizmodo.com

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
[[ Sonnenschein ]] likes this.

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
Hajo Thelen likes this.
Secret Service intercepts suspicious packages addressed to homes of Barack Obama in Washington and Hillary Clinton in Chappaqua, New York; Clinton package resembles a pipe bomb - CBS News
Been a while since I've heard about something like this!
Suspicious packages sent to Clinton, Obama contained crude explosive devices
The packages contained what a law enforcement official described as crude but functional low-ordnance explosive deviceswww.cbsnews.com
Apple and Samsung fined for deliberately slowing down phones | Technology | The Guardian
Apple and Samsung fined for deliberately slowing down phones
Italian investigation found software updates ‘significantly reduced performance’, hastening new purchaseswww.theguardian.com

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
2 people like this
Google admits it lost out to Microsoft buying GitHub - The Verge
Google admits it lost out to Microsoft buying GitHub
Google wanted to acquired GitHub but the company lost out to Microsoft in the latest big tech acquisitionwww.theverge.com
The NSA’s Hidden Spy Hubs in Eight U.S. Cities
The NSA’s Hidden Spy Hubs in Eight U.S. Cities
These fortress-like AT&T buildings are central to a secret NSA program that has monitored billions of communications, documents and sources reveal.theintercept.com
Westworld’s Man in Black is beyond saving
Bernard and Maeve make important strides of their own in the season’s penultimate episodewww.theverge.com
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!
the federation - a statistics hub
Podlist and statistics for The Federation (diaspora*, Friendica, Hubzilla, GangGo, Socialhome).the-federation.info
Hypolite Petovan likes this.
Mr.Robot - Soundtrack (Mac Quayle - Main Theme Song)
Soundtrack nowego amerykańskiego serialu Mr. Robot. Polski portal fanów serialu: mrobot.pl Fanpage: www.facebook.com/mr.robotv Premiera serialu odbędzie się 24 czerwca na kanale USA Network. Na platsoundcloud.com
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
. Here's hoping it goes smoothly!

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


This entry was edited (5 years ago)
Adam Magness
Fingers crossed...
Adam Magness
Then, for fun, tried to run dbscructure update, which gave:
[Error] SQLSTATE[HY000]: General error: 1356 View 'social.participation-view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Adam Magness
Adam Magness
Adam Magness
Adam Magness
Adam Magness
bin/console dbstructure drop
command gives no table names. I then ran dbstructure update, and received this error:[Error] SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`social`.`post-thread-user`, CONSTRAINT `post-thread-user_ibfk_7` FOREIGN KEY (`psid`) REFERENCES `permissionset` (`id`))
Adam Magness
Adam Magness