<p>Raoul:</p>
<p>Thanks. I will paste some Oops code below.</p>
<p>I took the songs.sqlite file from the Ubuntu computer where the upgrade caused the songs to disappear. I took it to a brand new Windows 7 computer with a fresh install of the suggested download of OpenLP. I pasted the file in where it should normally go.</p>
<p>Then I started OpenLP. MNo songs showed. I clicked to re-index songs, and got the following:</p>
<p>Traceback (most recent call last):</p>
<p style="margin: 0px; text-indent: 0px;">File "C:\Program Files (x86)\OpenLP\plugins\songs\songsplugin.py", line 149, in onToolsReindexItemTriggered</p>
<p style="margin: 0px; text-indent: 0px;">songs = self.manager.get_all_objects(Song)</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", line 315, in get_all_objects</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.query", line 1579, in all</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.query", line 1689, in iter</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.query", line 1694, in _execute_and_instances</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 720, in execute</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1191, in execute</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1271, in _execute_clauseelement</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1302, in __execute_context</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1401, in _cursor_execute</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1394, in _cursor_execute</p>
<p style="margin: 0px; text-indent: 0px;">File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.default", line 299, in do_execute</p>
<p style="margin: 0px; text-indent: 0px;">OperationalError: (OperationalError) no such column: songs.create_date u'SELECT songs.id AS songs_id, songs.song_book_id AS songs_song_book_id, songs.title AS songs_title, songs.alternate_title AS songs_alternate_title, songs.lyrics AS songs_lyrics, songs.verse_order AS songs_verse_order, songs.copyright AS songs_copyright, songs.comments AS songs_comments, songs.ccli_number AS songs_ccli_number, songs.song_number AS songs_song_number, songs.theme_name AS songs_theme_name, songs.search_title AS songs_search_title, songs.search_lyrics AS songs_search_lyrics, songs.create_date AS songs_create_date, songs.last_modified AS songs_last_modified, authors_1.id AS authors_1_id, authors_1.first_name AS authors_1_first_name, authors_1.last_name AS authors_1_last_name, authors_1.display_name AS authors_1_display_name \nFROM songs LEFT OUTER JOIN authors_songs AS authors_songs_1 ON songs.id = authors_songs_1.song_id LEFT OUTER JOIN authors AS authors_1 ON authors_1.id = authors_songs_1.author_id' ()</p>
<p style="margin: 0px; text-indent: 0px;"> </p>
<p> </p>
<p>Sincerely,</p>
<p>Pastor Doug Joseph</p>