[openlp-dev] MediaShout import bug

[Ken Roberts]

openlp/plugins/songs/lib/importer/mediashout.py line 69

cursor.execute('SELECT Name FROM Themes INNER JOIN SongThemes ON
SongThemes.ThemeId = Themes.ThemeId '
                           'WHERE SongThemes.Record = %s' % song.Record)

And the list of tables in the songs5.mdb file:
FireHistory
Verses
Songs
SongGroups
PlayOrder
Groups
CCLI

First glance - looks like there might be a change in database schema
or a corrupted mediashout db.


On Sat, Jun 11, 2016 at 7:19 AM, Raoul Snyman <raoul at snyman.info> wrote:
> On 11/06/2016 06:00, Ken Roberts wrote:
>>
>> At first glance, it looks like the error indicates the Themes table is
>> missing.
>>
>> Unfortunately, I don't have MS installed, so can't check the .mdb file
>> to verify.
>
>
> Did you try mdb-tools?
>
>
> --
> Raoul Snyman
> e: raoul at snyman.info
> _______________________________________________
> openlp-dev mailing list
> openlp-dev at openlp.io
> https://lists.openlp.io/mailman/listinfo/openlp-dev



-- 
- Ken
Registered Linux user 296561
Slackin' since 1993
Slackware Linux (http://www.slackware.com)