Bible disappear after upgrade

Bug #804747 reported by Kamae Norihiro on 2011-07-02
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Andreas Preikschat

Bug Description

After upgrading a bible, the bible disappeared from the list in bible plugin.
In directory "data/bibles", the bible file named ".sqlite" was created. (

1. start OpenLP with Japanese bible data of previous format.
2. Use Bible Upgrade Wizard to upgrade it;
 select the bible (
 save backup to C:\temp
 set language as Japanese.
 And click OK to continue.
 The wizard says succeeded. (
3. open bible plugin and no bible found. (

OS: Windows Server 2008 R2 Enterprise
OpenLP Version: 1.9.6 download from
Bible translation: Japanese bible translated in 1987, proprietary.

I will attach bible data which I can reproduce the bug.

Related branches

Kamae Norihiro (norihiro) wrote :
Andreas Preikschat (googol) wrote :


Can you attach the bible (the not upgraded version)? Or is this the not upgraded version?


Changed in openlp:
status: New → Incomplete
milestone: none → 1.9.7
Kamae Norihiro (norihiro) wrote :

Yes, the date submit at 2011-07-02 is the not upgraded version.

Andreas Preikschat (googol) wrote :

The database looks small, too small. I guess the database was corrupted before you attempted to upgrade it!?

Kamae Norihiro (norihiro) wrote :

Thank you for your reply.
As this version of bible has strict copy right, I cannot post whole verses. So the posted database has only first verses.
I also check the behavior with this small database and the behavior is similar to that with full database.
# If you need full verse database, could you email me? I will send by E-mail.

Andreas Preikschat (googol) wrote :

I cannot say if we'll need the database. However, I think we won't.

Did you try to import the bible more then once?
Is only this bible affected?

When you can answer both questions with yes, we need a full copy of the bible.

Kamae Norihiro (norihiro) wrote :

> Did you try to import the bible more then once?
Yes, I try this bible 2 times and always OpenLP generate file named ".sqlite"

> Is only this bible affected?
Yes only this bible. NIV didn't.
But the attached bible (containing first verse in each book) also causes this bug.

Andreas Preikschat (googol) wrote :

Upgrading the attached bible fails (well, the wizard does not fail, but the bible disappears).

Changed in openlp:
status: Incomplete → Confirmed
Changed in openlp:
importance: Undecided → Medium
Changed in openlp:
assignee: nobody → Andreas Preikschat (googol)
status: Confirmed → In Progress
Changed in openlp:
status: In Progress → Fix Committed
Andreas Preikschat (googol) wrote :

This should be fixed now. Thank you for reporting this.


Changed in openlp:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers