KichangKim / DanbooruDownloader

Danbooru image downloader.
MIT License
149 stars 25 forks source link

table posts has no column named media_asset #19

Closed zpanula closed 1 year ago

zpanula commented 1 year ago

Danbooru has a (new?) media_asset field that is unable to be written to the table as it isn't defined in the schema.

System.AggregateException: One or more errors occurred. (SQLite Error 1: 'table posts has no column named media_asset'.)
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'table posts has no column named media_asset'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at DanbooruDownloader.Utilities.SQLiteUtility.InsertOrReplace(SqliteConnection connection, IEnumerable`1 posts) in I:\deepbooru\DanbooruDownloader\DanbooruDownloader\Utilities\SQLiteUtility.cs:line 116
   at DanbooruDownloader.Commands.DumpCommand.Run(String path, Int64 startId, Int64 endId, Boolean ignoreHashCheck, Boolean includeDeleted, String username, String apikey) in I:\deepbooru\DanbooruDownloader\DanbooruDownloader\Commands\DumpCommand.cs:line 227
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.Wait()
   at DanbooruDownloader.Program.<>c__DisplayClass0_1.<Main>b__2() in I:\deepbooru\DanbooruDownloader\DanbooruDownloader\Program.cs:line 63
   at Microsoft.Extensions.CommandLineUtils.CommandLineApplication.Execute(String[] args)
   at DanbooruDownloader.Program.Main(String[] args) in I:\deepbooru\DanbooruDownloader\DanbooruDownloader\Program.cs:line 78