Missing table error

[TESTVNULL]

Details

The SQLite studio is connected with my Netbeans programme, but it pops up a "[SQLITE_ERROR] SQL error or missing database (no such table: Model)". I am sure I have created a table. But I don't know why it can't open it in the programme.

Steps to reproduce

[SQLITE_ERROR] SQL error or missing database (no such table: Model)

Operating system

mac os 10.15.4

SQLiteStudio version

v3.2.1

[pawelsalawa]

Does error appear in SQLiteStudio or Netbeans?

I won't be able to help you with Netbeans. I don't know why it throws errors.

[TESTVNULL]

I am not sure. I connect SQLite studio as a database to my Netbeans. It connected, but it can't read the table.

[pawelsalawa]

Hold your mouse over the database (in the left-side panel), a popup will appear, where you will see path to the file. Please confirm it is the same path as you have in netbeans.

[TESTVNULL]

[pawelsalawa]

Again, I'm not 100% sure of the cause, because netbeans is not my expertise, although I'm suspecting some building job in netbeans, that erases the database file and creates new one.

I think it's this way, because I see you have this message in SQLiteStudio that the window could not be restored, because database could not be resolved.

Why the database could not be resolved? Was it deleted & recreated by netbeans?

[TESTVNULL]

it was deleted then I create a new database

[pawelsalawa]

Okay then. In SQLiteStudio everything seems to be fine. I don't know why your netbeans complains.

[TESTVNULL]

Same. Everything is working but I don't know why it can't read the table. This is why I am asking for help. Thank you for responding to me.

[TESTVNULL]

so do I need to contact with Netbeans?

[pawelsalawa]

You can, but I'd recommend you to try to figure it out. Go to that directory within your terminal command line, see if that file is not deleted & recreated. Close SQLiteStudio & reopen it, see if that database is still visible to SQLiteStudio and if has this table. Check if table name does not end with extra whitespace that you didn't see, etc.

Try to nail it down.

[TESTVNULL]

I already try those actions that you mention for a few days. But it just doesn't work.

[pawelsalawa]

Yeah, I'm helpless then.