OpenLP

Bible disappear after upgrade

Bug #804747 reported by Kamae Norihiro
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenLP
Fix Released
Medium
Unassigned
OpenLP 1.9.7 "Joyful John"

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. (http://static.inky.ws/image/449/image.jpg)

Steps:
1. start OpenLP with Japanese bible data of previous format.
2. Use Bible Upgrade Wizard to upgrade it;
 select the bible (http://static.inky.ws/image/446/image.jpg)
 save backup to C:\temp
 set language as Japanese.
 And click OK to continue.
 The wizard says succeeded. (http://static.inky.ws/image/447/image.jpg)
3. open bible plugin and no bible found. (http://static.inky.ws/image/448/image.jpg)

OS: Windows Server 2008 R2 Enterprise
OpenLP Version: 1.9.6 download from http://sourceforge.net/projects/openlp/files/openlp/1.9.6/OpenLP-1.9.6-setup.exe/download
Bible translation: Japanese bible translated in 1987, proprietary.

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

Related branches

lp:~googol-deactivatedaccount/openlp/bug-804747
Raoul Snyman: Approve
Tim Bentley: Approve
Diff: 983 lines (+137/-296)
8 files modified
openlp/core/ui/mainwindow.py (+2/-5)
openlp/core/utils/__init__.py (+12/-1)
openlp/plugins/bibles/forms/bibleupgradeform.py (+79/-233)
openlp/plugins/bibles/forms/languageform.py (+5/-6)
openlp/plugins/bibles/lib/db.py (+30/-43)
openlp/plugins/bibles/lib/manager.py (+6/-5)
openlp/plugins/bibles/lib/mediaitem.py (+1/-1)
openlp/plugins/songs/lib/openlyricsexport.py (+2/-2)
lp:openlp
Revision history for this message
Kamae Norihiro (norihiro) wrote :
Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) wrote :

hm...

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

Cheers

Changed in openlp:
status: New → Incomplete
milestone: none → 1.9.7
Revision history for this message
Kamae Norihiro (norihiro) wrote :

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

Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) wrote :

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

Revision history for this message
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.

Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) 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.

Revision history for this message
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.

Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) wrote :

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

Changed in openlp:
status: Incomplete → Confirmed
Andreas Preikschat (googol-deactivatedaccount)
Changed in openlp:
importance: Undecided → Medium
Andreas Preikschat (googol-deactivatedaccount)
Changed in openlp:
assignee: nobody → Andreas Preikschat (googol)
status: Confirmed → In Progress
Andreas Preikschat (googol-deactivatedaccount)
Changed in openlp:
status: In Progress → Fix Committed
Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) 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  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.