Friendica Support reshared this.
DBStructure update
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?
@Gabe are you seeing this mention?

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.
kograt likes this.
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.
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.
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.
[[ Sonnenschein ]] likes this.
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.
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
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.
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.
like this
Hypolite Petovan likes this.



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