Zum Inhalt der Seite gehen

Since updating to 2024.03 I get continuously database errors like:

1054
error
Unknown column 'contact-id' in 'where clause'
params
DELETE FROM item WHERE (contact-id = 103118)

Who knows what's gone wrong here?

!Friendica Support #Friendica

#friendica !Friendica Support
Als Antwort auf alfredb

Michael Vogel
Michael Vogel
• •
What do you see, when you execute this command:
bin/console dbstructure drop
Als Antwort auf Michael Vogel

alfredb
alfredb
• •

@Michael Vogel

These tables are not used for friendica and will be deleted when you execute "dbstructure drop -e":

item_id
poll
sign
term
item
auth_codes
tokens
clients
profile_check
addon

@Michael Vogel
Als Antwort auf alfredb

Michael Vogel
Michael Vogel
• •
What is the result of this command?
show create table item;
Als Antwort auf alfredb

Michael Vogel
Michael Vogel
• •
"Error, this is a private paste or is pending moderation. If this paste belongs to you, please login to Pastebin to view it."
Als Antwort auf alfredb

Michael Vogel
Michael Vogel
• •
Have you used Hubzilla or something different in the database? The item table is not used anymore by Friendica for several years now. So we have got the command to remove these tables. But these table doesn't look like a table from Friendica, so removing it, could destroy some other system.
Als Antwort auf alfredb

Michael Vogel
Michael Vogel
• •
Having both systems in a single database is a huge risk! I cannot guarantee that both systems use completely different tables, especially since they have got the same heritage. So it can happen that you destroy one or both systems by running them in parallel.
Als Antwort auf alfredb

Michael Vogel
Michael Vogel
• •
Have a look into that item table if the data in it is new or old. With dbstructure drop -e you can delete all the tables. So only do it, after you created a backup and you are sure that you can delete the data.
Als Antwort auf Michael Vogel

alfredb
alfredb
• •
@Michael Vogel Done that, the error production stopped.
Once again, thanks for your assistance! You made my day.
@Michael Vogel
Als Antwort auf alfredb

Roland Häder
Roland Häder
• •
@alfredb Have you run the obligatory database update after upgrading Friendica? ./bin/console dbstructure update and then ./bin/console postupdate
@alfredb
Als Antwort auf alfredb

alfredb
alfredb
• •
obligatory database update
AFAIK this is or should be done automatically,
But yes, both is done,
Als Antwort auf alfredb

Roland Häder
Roland Häder
• •

@alfredb Yes, I now see it in your /friendica info page:

This is Friendica, version 2024.03 that is running at the web location social.alfredbuehler.ch. The database version is 1557/1557, the post update version is 1550/1550.
@alfredb

Diese Webseite verwendet Cookies. Durch die weitere Benutzung der Webseite stimmst du dieser Verwendung zu. https://inne.city/tos

⇧