I opened the database using a free DB tool called DB Browser and all rows are in at as expected. The error comes up when I try and print all rows to the screen which I don't need to do now given that I know they are in the DB. Think I will just use the DB Browser now for all checks on correct DB contents etc and not Python and the browser.