play_by_play table empty after "successful" database build

[throwaway87]

using the application to build the database works for other tables but using the same settings and only building the play_by_play table results in the application acting like it was successful but the resulting table has zero rows

[mpope9]

Hi, thanks for the report. A few questions:

• What version were you using?
• Are you trying to use the 'default-mode' setting to build the play_by_play table?
• Does building the whole db from scratch without skipping the play_by_play table fill it?

I am able to create a new DB from scratch and that table does get populated. I am using SQLite.

[throwaway87]

Sorry. Been a while since I wrote up a bug

the app is nba_sql_v0.0.9 on postgresql 15 on windows 10 Yes. I'm using the default mode and since the rest of the db built fine, I'm just attempting that table for the 2022-2023 season. Previously, I could not get a successful build by doing all tables for the current season, so I built the database without building the play_by_play or shot_chart_detail. That worked fine. So now I'm just trying to get the play by play table.

No it does not. When I just build the whole db, it fails on the play by play. I have only built for this season in all circumstances though. Technically, I don't know if doing it for all the seasons would work.

[mpope9]

Sorry for the late reply on this. I have trouble reproducing this on the most recent version. Is it possible for you to update and try this again? I've tested it on SQLite, MySQL, and Postgres.