sqlite3.OperationalError: no such table: posts

[Asmedeus998]

I having trouble creating sqlite database using following command

deepdanbooru make-training-database [your_dataset_sqlite_path] [your_filtered_sqlite_path]

[KichangKim]

Check your sqlite database structure. It must contains posts table which has columns like this:

posts
├── id (INTEGER)
├── md5 (TEXT)
├── file_ext (TEXT)
├── tag_string (TEXT)
└── tag_count_general (INTEGER)

Also, you have to prepare your database yourself (or use DanbooruDownloader)

[Asmedeus998]

I use DanbooruDownloader and it work thanks