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?
Roland Häder likes this.
Friendica Support reshared this.
@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
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
and breakfast. Good morning friends!!
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!
. Here's hoping it goes smoothly!
Is it just me, or is it more fun working on code for ~friendica than it is working on code for work? 
than it is working on code for work?
Michael Vogel
•bin/console dbstructure dropto check which tables can be deleted. With the additional parameter-ethe tables will then be deleted. Then the update should run.2 people like this
Adam Magness and Roland Häder like this.
Adam Magness
Fingers crossed...
Roland Häder likes this.
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 themRoland Häder likes this.
Michael Vogel
•Roland Häder likes this.
Michael Vogel
•drop tablecommands line by line? I would like to see which table makes these problems.Concerning the view: This view is not used anymore. You can drop it without any problem.
Roland Häder likes this.
Adam Magness
Roland Häder likes this.
Adam Magness
Roland Häder likes this.
Adam Magness
Roland Häder likes this.
Michael Vogel
•Adam Magness
Adam Magness
bin/console dbstructure dropcommand 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`))Roland Häder likes this.
Michael Vogel
•update.phpgo to the functionupdate_1440and comment out the lineDBA::delete('permissionset'.... We can always have a look at the problem later. This line should just remove some data garbage.2 people like this
Adam Magness and Roland Häder like this.
Adam Magness
Roland Häder likes this.
Michael Vogel
•2 people like this
Roland Häder and Adam Magness like this.
Roland HΓ€der
•Adam Magness likes this.
Adam Magness