I need to read data from a sqlite database from inside the actiony.py file and return it as a message.
Unfortunately, I always get an error message, saying the databse cannot be accessed.
The sqlite database file is inside my actions/ folder.
Are there any recommendations on how to solve this?
I tried sqlite3.connect( "database.sqlite") as well with the same result. My code always enters the catch block. The error message is no such table but the table does definitely exist.
Hi @andileni, Here is how I performed a simple query in MySQL. Try this format. Be sure to put the DB connection code outside of the try-catch. Only the query operations should be in try-catch. I’m not sure if this will work for sqlite but do try it.
Here “varunsapre” is the username of the DB, “password” is the password for the user and “rasadb” is the database name.
Hi Tobias, i’m trying to run rasax on wsl(ubuntu).! i’m not getting chatbot prompt even project gets loaded .! i can see that sqllite3 is trying to insert and getting failed.! i don’t need any database for my project.! how can i disable this action.! and just run demo project on browser . please help.!
@suryakiran The sqlite database is essential for the functionality of Rasa X. On what error is it failing? I recommend creating a new forum thread as this is quite old.