How to unarchive in opencode-desktop

[leavor]

Question

I accidentally clicked 'Archive' on a session in opencode-desktop. How can I find it and get it back?

opencode-desktop version is v1.1.53

[github-actions]

This issue might be a duplicate of existing issues. Please check:

• [FEATURE]: view archived sessions on desktop #6680: [FEATURE]: view archived sessions on desktop - This is a feature request for the ability to view and unarchive archived sessions
• Data loss due to session closure without confirmation (OpenCode Desktop for macOS) #10815: Data loss due to session closure without confirmation - Related issue about session archival/closure, discusses the need for reversible operations

Feel free to ignore if none of these address your specific case.

[github-actions]

To stay organized issues are automatically closed after 90 days of no activity. If the issue is still relevant please open a new one.

[NashYang96]

create a new session and just give it this prompt "My archived OpenCode chat session (your session name) are missing from the sidebar. They are stored in the SQLite database at ~/.local/share/opencode/opencode.db in the session table. The column time_archived is set to a timestamp when a session is archived. To restore them, set time_archived = NULL. Please run a query to show me all archived sessions, ask me which one to restore, and then run the UPDATE query to fix it." Restart after the execution! The session will be recovered!

[devbijay]

opencode export > session-export.json
jq 'del(.info.time.archived)' session-export.json > session-unarchived.json
opencode session delete
opencode import session-unarchived.json
opencode --session

[SawLay043]

Well, it was a weird way to find out this issue after I accidently miss pressed the caps lock and stuff, and my sessions went disappeared, lol.

[g19375592715-del]

test

[SinnySupernova]

on linux you can install sqlite3 cli and run sqlite3 ~/.local/share/opencode/opencode.db "SELECT id,title,slug,time_archived FROM session ORDER BY time_archived DESC LIMIT 1;" to get last archived session details- increase limit to get more sessions
then run sqlite3 ~/.local/share/opencode/opencode.db "UPDATE session SET time_archived = NULL WHERE slug = 'PASTE_SLUG_HERE';" for the session you want to unarchive

[TimChinye]

Just accidentally pressed "CTRL+Alt+Backspace" and my super massive conversation just got deleted. It says "Archive", but there's seemingly no way to view archived conversations and/or bring them back - which is quite misleading. And there really should be a confirmation modal for such an irreversible action.

[zkxil]

create a new session and just give it this prompt "My archived OpenCode chat session (your session name) are missing from the sidebar. They are stored in the SQLite database at ~/.local/share/opencode/opencode.db in the session table. The column time_archived is set to a timestamp when a session is archived. To restore them, set time_archived = NULL. Please run a query to show me all archived sessions, ask me which one to restore, and then run the UPDATE query to fix it." Restart after the execution! The session will be recovered!

Thanks Yang, Really helps me a lot.

[FreeRide23]

WHY the fuck is this topic opened since FEB.6????
How the fuck can a programm behave like this for over 5 months?
Omfg.... can some one explain to me, how to edit the C:\Users\FreeRide23.local\share\opencode\opencode.db to reset the sessions???
I read 20 different approaches, no one works.... cause there are terms like "TUI" what NO ONE EXPLAINS.....
How the fuck should a normal person understand ANY SHIT that is written here????
I dont have any fucking idea how to fucking open a database, or what to klick where to edit WHAT....

So can anyone fucking explain this shit to me? IN SIMPLE FUCKING TERMS????

This:
"create a new session and just give it this prompt "My archived OpenCode chat session (your session name) are missing from the sidebar. They are stored in the SQLite database at ~/.local/share/opencode/opencode.db in the session table. The column time_archived is set to a timestamp when a session is archived. To restore them, set time_archived = NULL. Please run a query to show me all archived sessions, ask me which one to restore, and then run the UPDATE query to fix it." Restart after the execution! The session will be recovered!"

Did not work, because I DO NOT FUCKING KNOW THE NAME OF THE SESSION......
Also it does not work because it says i need to close the OpenCode software...

I found this one:
https://github.com/OllyJohnston/OpenCode-Archive-Session-Manager

So you realy mean, i should install:
Python
Opencode TUI
and then follow 20 steps of shit, just to install a FEATURE that should have been there 5 month ago????

So your fix for a problem, is a installation process of its own????

WHY THE FUCK can no one in this dev community ADD the CODE that is written ALLREADY here: #24153 ????

WHO THE FUCK IS IN CHARGE OF THIS???? What ASS we need TO KICK to MAKE THIS FUCKING HAPPEN????????

I realy love the open source community, but you fucking guys are missing the abilit to MAKE DECISIONS and MAKE IT HAPPEN!!!! FOR FUCK SAKE WHO IS IN CHARGE OF THIS SHIT?????

[giuliov]

@FreeRide23 on Windows I suggest this:

1. download a simple GUI like sqlite-gui
2. open C:\Users\<YOURUSER>\.local\share\opencode\opencode.db (yes, I know it's unnatural, should be under C:\Users\<YOURUSER>\AppData\Roaming\opencode, sic)
3. find the session e.g.

SELECT id, title, slug, time_archived
FROM session
ORDER BY time_archived DESC
LIMIT 1;

to get last archived session details (copy-paste then press Execute)
4. save the value of the slug cell (right-click, Copy cell)
5. un-archive executing another command

UPDATE session
SET time_archived = NULL
WHERE slug = 'PASTE_COPIED_SLUG_HERE';

6. close and reopen Opencode Desktop

at least it worked for me
thanks @SinnySupernova for the tip

[FreeRide23]

SELECT id, title, slug, time_archived
FROM session
ORDER BY time_archived DESC
LIMIT 1;
to get last archived session details (copy-paste then press Execute) 4. save the value of the slug cell (right-click, Copy cell) 5. un-archive executing another command

UPDATE session
SET time_archived = NULL
WHERE slug = 'PASTE_COPIED_SLUG_HERE';
6. close and reopen Opencode Desktop

DUDE! THX! That works!
Finaly a good explanation!

Ok, what i was missing (a friend helped me then) was the following information:

You say "find the session e.g." and then post the SQL execution parameters....
I told you, i dont know shit about databases....

So what i was missing, was the information, Open the *.db with the SQL Lite viewer, then you see the Database, on the tab "database structure, Browse Data, Edit Pragmas, execute SQL" press the execute SQL tab.
Then paste the code:
SELECT id, title, slug, time_archived
FROM session
ORDER BY time_archived DESC
LIMIT 1;

Then press > run
Now you find your the slug you need, the slug is showed below the execution window, copy the slug name and paste it into the other command:

found slug:
jolly-forest

UPDATE session
SET time_archived = NULL
WHERE slug = 'PASTE_COPIED_SLUG_HERE';

=

UPDATE session
SET time_archived = NULL
WHERE slug = 'jolly-forest';

Repeat it as often as you need (i needed to do it two times).

This works!

THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Fuck that shit, make that user interface work.... please, for fuck sake....

I dont know if this programm is run by a dev community or a vibe coding community i realy dont care....
All i see are endless treads, with different approaches, and it needs me to get fucking angry, to get a answer that helps....
I see https://github.com/OllyJohnston/OpenCode-Archive-Session-Manager this and just get angry, because a simple explanation (that is now given) would solve all the problems.... and all the problems would not even exist, if the suggestion of the implementation of this bugfix would WORK in TIME.....

So who ever is in charge of this shit here, get your shit together, for fuck sake.....