jpmayer / fantasy-chrome-extension

Chrome Extension for Creating LM Note Content in ESPN Fantasy Football Leagues
MIT License
39 stars 13 forks source link

Error processing SQL: could not prepare statement (1 no such table: history) #119

Open dnalloheoj opened 5 years ago

dnalloheoj commented 5 years ago

Steps to recreate:

1) (Not sure if necessary) Fill in Power Rankings. 2) Process Power Rankings 2) Attempt to Update DB (Wanted to process the rankings first just in case the text was lost upon switching tabs (Which I see is a resolved issue, hurray!)). 3) Results in 'Error processing SQL: could not prepare statement (1 no such table: history)'

Have not encountered issues with the Database/History dating back to Pre-season or after Week 1.

Did have the issue where Rankings were showing 'NaN' but that appears to be resolved, though now I simply see nothing under 'Trending' aside from three dashes '---'.

If I let it run, after getting the error, it says it's updated to Week 3, but I don't see any indication that it is in the Stats/Rankings/Leaderboards.

League is fairly standard aside from being HPPR and 12 teams. No funky lineups, owners that haven't accepted invites, or anything like that.

In an attempt to troubleshoot it myself, I deleted the existing DB (Choosing 'Cancel' to retain Power Rankings), but upon completion of re-updating the DB I still don't have trending data. Though I can now Update the DB without the error message in the Title appearing.

Mostly just FYI, as I don't expect to get the Trending Data back at this point, but figured it would be worthwhile for informational purposes.

Let me know if I can provide any further information!

Thanks!