this post was submitted on 03 Jun 2023
2 points (100.0% liked)
Lemmy Support
4651 readers
5 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Sorry Chris, I was figuring that out as I went. It looks like a postgres syntax error but the command matches what I used.
If you run "SELECT * from local_user;" do you get output showing your list of registered users? Perhaps you're not attached to the lemmy database?
Yes, the Select did work, it was just the updates that didn't work.
Not sure what to suggest, sorry I'm not a DBA :(
To make it clear, here is the command I ran enclosed with "
"UPDATE local_user SET email_verified = ‘t’, accepted_application = ‘t’ WHERE id = 1;"
"lemmy=# UPDATE local_user SET email_verified = ‘t’, accepted_application = ‘t’ WHERE id = 1; ERROR: column "‘t’" does not exist LINE 1: UPDATE local_user SET email_verified = ‘t’, accepted_applica... ^ HINT: Perhaps you meant to reference the column "local_user.id"." This was its response.
I've just taken a look at your instance... you're running a slightly older version. I'm guessing the DB schema has changed.
Does "SELECT * from local_user.id;" get you a list of users? You may need to update the other references to match whatever the old DB schema is.
no it doesn't work. "ERROR: relation "local_user.id" does not exist LINE 1: SELECT * from local_user.id;"
My instance is only 4 days old, how do I update it?
updated my instance, no change however as far as the database is concerned.
Sorry mate, I'm out of ideas.