looks a bit like an SQL error - but postgres instance is running fine.
---> System.InvalidCastException: Null object cannot be converted to a value type. at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at Dapper.SqlMapper.GetValue[T](IDataReader reader, Type effectiveType, Object val) in /_/Dapper/SqlMapper.cs:line 1275
I ran into this as well, but solved it by seeding the database with manually populated mastodon account, as well as one twitter account to follow. I was migrating from birdsitelive so I just copied the content over from the birdsitelive database. There are some minor differences in table structure, but after copying the content over the web-ui successfully started.
ok, so I can just connect the bird.makeup container to a db container from birdsitelive?
~perler: no you can't. As ~eric-pierce mentioned, there are some minor differences in the table structure. You have to first let bird.makeup create the tables and then populate the first rows manually. Hope this will be fixed in the future! Thanks a lot ~cloutier!
can someone post a sql file with the minimum records? trying to figure out what needs to be in the tables but no luck
~vzeebrod Sure here are some sample records for @Gargron@mastodon.social following @npr on twitter.
followers table:
id,followings,followingssyncstatus,acct,host,inboxroute,sharedinboxroute,actorid,postingerrorcount
1,{1},{"1": 1632785881919549441},gargron,mastodon.social,/users/gargron/inbox,/inbox,https://mastodon.social/users/gargron,0
twitter_users table:
id,acct,lasttweetpostedid,lasttweetsynchronizedforallfollowersid,lastsync,fetchingerrorcount,twitteruserid
1,npr,1632785881919549441,1632785881919549441,2023-03-06 11:32:04.5,0,5392522