ollama - 💡(How to fix) Fix Delete all history button [2 comments, 2 participants]

Fix Plan

To delete all chat histories without removing settings, we can create a script to directly interact with the SQLite database.

Steps

• Stop the Ollama application to ensure the database is not in use.
• Use a SQLite client or a programming language like Python to connect to the database.
• Execute a query to delete all chat history records.

Example Code (Python)

import sqlite3

# Connect to the database
conn = sqlite3.connect('AppData\\Local\\Ollama\\db.sqlite')
cursor = conn.cursor()

# Delete all chat history records
cursor.execute('DELETE FROM chat_history')

# Commit changes and close the connection
conn.commit()
conn.close()

Replace 'AppData\\Local\\Ollama\\db.sqlite' with the actual path to your database file.

Verification

After running the script, restart the Ollama application and verify that all chat histories have been deleted while settings remain intact.

Extra Tips

• Make sure to backup your database before making any changes.
• If you're not comfortable with scripting, consider using a graphical SQLite client like DB Browser for SQLite to execute the delete query.