openlp-core team mailing list archive

[Albert Steiner <652380@xxxxxxxxxxxxxxxxxx>]

I ran on W7 home priemier 64 bit the -r1183 revision.  I did not build the
binary, but simply imvoked python openlp.pyw -l debug  and I get the error
saying something like you must supply the python-sqlite module to read an
openlp1 db.

I have sqlite.py in my python 2.6.6 installation, it appears that the test
for sqlite fails.  However, when I put import sqlite into the openlp.pyw,
then sqlite is loaded correctly.

If I do not put import sqlite in openlp.pyw  and in importer.py remove the
try  except around


from olp1import import OpenLP1SongImport
has_openlp1 = True


I get:
2011-01-02 09:41:10,884 openlp.plugins.songs.forms.editsongform
    INFO     openlp.plugins.songs.forms.editsongform EditSongForm loaded
2011-01-02 09:41:10,918 openlp.core.lib.pluginmanager
    ERROR    Failed to import module songs.songsplugin on path
C:\Projects\trunk1183\openlp\plugins\songs\songsplugin.py for reason DLL
load failed: Invalid access to memory location.
Traceback (most recent call last):
  File "C:\Projects\trunk1183\openlp\core\lib\pluginmanager.py", line 97, in
find_plugins
    __import__(modulename, globals(), locals(), [])
  File "C:\Projects\trunk1183\openlp\plugins\songs\songsplugin.py", line 34,
in <module>
    from openlp.plugins.songs.lib import SongMediaItem, SongsTab,
SongXMLParser
  File "C:\Projects\trunk1183\openlp\plugins\songs\lib\__init__.py", line
128, in <module>
    from mediaitem import SongMediaItem
  File "C:\Projects\trunk1183\openlp\plugins\songs\lib\mediaitem.py", line
36, in <module>
    from openlp.plugins.songs.forms import EditSongForm,
SongMaintenanceForm, \
  File "C:\Projects\trunk1183\openlp\plugins\songs\forms\__init__.py", line
60, in <module>
    from songimportform import SongImportForm
  File "C:\Projects\trunk1183\openlp\plugins\songs\forms\songimportform.py",
line 34, in <module>
    from openlp.plugins.songs.lib.importer import SongFormat
  File "C:\Projects\trunk1183\openlp\plugins\songs\lib\importer.py", line
35, in <module>
    from olp1import import OpenLP1SongImport
  File "C:\Projects\trunk1183\openlp\plugins\songs\lib\olp1import.py", line
35, in <module>
    import sqlite
  File "C:\python26\Lib\site-packages\sqlite\__init__.py", line 1, in
<module>
    import _sqlite
ImportError: DLL load failed: Invalid access to memory location. .


This is a repeatable error, I got it with other revisions.  I get it with
the latest exe (I don't see the trace just the error)

In python2.6.6 I have sqlite.dll in the DLLs directory.  And I have set my
path to go to DLLs before any other section of python2.6.6   in addition
sqlite package is installed in python2.6.6\Lib\site-packages

Of course I cannot recreate the error by runing python and trying a variety
of import of sqlite, and of various openlp modules.

On Fri, Dec 31, 2010 at 10:09 AM, m2j <652380@xxxxxxxxxxxxxxxxxx> wrote:

> Can you provide your DB? I have just checked it and it is working for
> all databases I have available. I need at least the value of the invalid
> bytes and the chosen codemap.
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/652380
>
> Title:
>  OpenLP1.x database fails to import in 1.9.3 with character issues
>
> Status in OpenLP - Worship Presentation Software:
>  Fix Released
>
> Bug description:
>  Tried to import our church database into 1.9.3 and it failed on the 5th
> song with encoding problems in copyright field.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/openlp/+bug/652380/+subscribe
>


-- 
Albert Steiner

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/652380

Title:
  OpenLP1.x database fails to import in 1.9.3 with character issues

Status in OpenLP - Worship Presentation Software:
  Fix Released

Bug description:
  Tried to import our church database into 1.9.3 and it failed on the 5th song with encoding problems in copyright field.