search

textbrowser / biblioteq

Archive and catalog the world for today's and tomorrow's generations! Awesome and everyware.
https://textbrowser.github.io/biblioteq/
Other
217 stars 46 forks source link

Possible Bug? "Unable to retrieve the data required for populating the main views." #302

Closed mlamias closed 1 year ago

mlamias commented 1 year ago

Hello,

I had been using a previous version of Biblioteq for years to manage my large, personal, statistics library. I wanted to upgrade to the latest version of the software today so I downloaded Version 2023.03.15 of Source code (zip)., made a backup copy of my SQLlight database, and followed the instructions detailed in the attached Windows Installation document provided in the QT (being sure to install the recommended version of QT:
Windows Installation.pdf.

After successfully completing the install, I launched the program and I receive a message indicating that the database must be updated and it instructs me to use the "Upgrade SQLite Database" Utility under the Tools menu. When I run the Upgrade utility, I see the following success messages:

Executing 2 statement(s).

1. CREATE TABLE book_conditions (condition TEXT NOT NULL PRIMARY KEY)

Statement concluded correctly!

2. CREATE TABLE book_originality (originality TEXT NOT NULL PRIMARY KEY)

Statement concluded correctly!

But then, when I try to run a query, I receive the following error message:

Unable to retrieve the data required for populating the main views.

The error logs display the following message:

2023/05/15 19:05:17,Database Error,Unable to retrieve the data required for populating the main views.,no such table: photograph_collection Unable to execute statement,Source\biblioteq_b.cc,3449

I'm attempting to move from version 6.58 of BiblioteQ to the latest version 2023.03.15.

Any idea how to resolve this?

Thank you!

textbrowser commented 1 year ago

You're serious?

textbrowser commented 1 year ago

6.58 was released 11 years ago.

textbrowser commented 1 year ago

The repository version includes a new method of upgrading an SQLite database by executing all known upgrade statements. Two versions: All, Recent.

textbrowser commented 1 year ago

You can build it again or wait until the next release in June.

textbrowser commented 1 year ago

And your request has been asked before. It's very irritating. :P

mlamias commented 1 year ago

6.58 was released 11 years ago.

Yes. Sadly, it's worked well for me since and I haven't upgraded.

mlamias commented 1 year ago

And your request has been asked before. It's very irritating. :P

My apologies for the duplication. Can you point me to the the question and answer? Otherwise, I was thinking of simply exporting the data as a CSV and importing it.

mlamias commented 1 year ago

The repository version includes a new method of upgrading an SQLite database by executing all known upgrade statements. Two versions: All, Recent.

Got it. Thanks for your help. I'll try and run the repo updates since 6.58. I'll so try to be better about keeping up with updates.

Thanks again!

textbrowser commented 1 year ago
  1. Create a new SQLite database.
  2. Merge the legacy database via Tools -> Merge...
textbrowser commented 1 year ago

https://github.com/textbrowser/biblioteq/discussions/191

mlamias commented 1 year ago

191

Many thanks. This is very helpful. I appreciate the support and love this software! I'll be better about upgrading in the future! ;-)