Unable to save SQL Notebooks due to "Object reference not set to an instance of an object." about sqlnotebook HOT 7 CLOSED

Hi @muelphil, sorry this happened! Can you try it in a new notebook and see what triggers it? If a fresh, new notebook can be saved without error, what needs to happen to break it?

from sqlnotebook.

I experimented again. When I save a plain Notebook it works. Also when there are tables and scripts present. As soon as I introduce a page - can be completly empty - it wont save anymore with the given error message.

Hope that helps. Feel free to ask further questions.

I really like this software and would like to use it in school for teaching. With some more features this would be perfect for my usecase. So i hope it gets fixed soon :-)

from sqlnotebook.

Aha. Using your instructions I was able to reproduce the error myself. Thank you for that. I will work on fixing this for the next version of SQL Notebook.

from sqlnotebook.

I faced the same issue as well. Although if I removed all SQL blocks and saved them as scripts it saved without error. However as soon as I add a sql block it gives the error again.

from sqlnotebook.

Hi All - I appreciate the work that has gone into SQL Notebook. I chose it over Jupyter + an SQL extension because there were so many versions of the latter and they had many disparate dependencies. Conversely, SQL Notebook had what I wanted right out of the box. But... it's crashing and losing my work frequently. I'm simply working in a page and creating interleaving blocks of text and SQL code and if I don't save every 3 minutes I will invariably lose a block or two of work. Very frustrating.

I'm using 1.2.0. The tables I'm using were imported from CSV files and contain hundreds to thousands of records, with not more than a dozen columns. And most of the SQL code is right out of sqlitetutorial.net. In other words, I'm doing what I think is pretty basic stuff, but it's crashing a lot.

Please let me know what other info I can provide to assist resolution. I would really love to be able to use SQL Notebook for me and my team.

Thank you!

from sqlnotebook.

I had encountered the same issue, however, I was getting this error after creating a page. Once I had executed all the cells in the page, I had no errors while saving.

Not a solution, but an observation I noted.

from sqlnotebook.

This issue has been fixed in version 1.2.1. Please give it a try.

from sqlnotebook.