Hello all, I am having trouble getting my 0.10.2 Madeleine-base data migrated to sqlite on 0.13. I have closely followed the README, the FAQ and found a few relevant posts on this list but I am unable to get reset_references to run properly. So far I have successfully managed to generate the SQL to populate sqlite and it seems to have worked in that the script threw no errors and I can now see various populated tables when I mount production.db.sqlite3. I''d be vastly grateful for any help - I miss the ease of use of instiki and the info that I have in it is nearly 3 years worth of personal notes on my various job processes - its invaluable. Failing a fix for instiki, can anyone point me at something that can convert an unpacked snapshot to a format that I could import into another wiki or tool? Going to the next step of the upgrade process, after sqlite import, to run rest_references, here''s what I''m getting: ----------------------------------------------- C:\cam\util\instiki-0.13.0>ruby C:\cam\util\instiki-0.13.0\script\reset_references Loading Rails for development environment... The DL driver for sqlite3-ruby is deprecated and will be removed in a future release. Please update your installation to use the Native driver. C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'': SQLite3::SQL Exception: no such table: wiki_references: DELETE FROM wiki_references WHERE 1=1 (ActiveRecord::StatementInvalid) from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:346:in `catch_schema_changes'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:155:in `delete'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/base.rb:513:in `delete_all'' from C:/cam/util/instiki-0.13.0/script/reset_references:15 ----------------------------------------------- Since I can see there IS a wiki_references table, altho its empty: ----------------------------------------------- C:\cam\util>sqlite3.exe instiki-0.13.0\db\production.db.sqlite3 "select * from wiki_references" C:\cam\util>sqlite3.exe instiki-0.13.0\db\production.db.sqlite3 "select * from webs" 1|2005-09-21 12:08:26|2008-05-08 16:23:01|localnotes|localnotes|XXX| |false|false|false|textile|008B26|0|false|false ----------------------------------------------- I thought I would comment out the wiki_references.delete_all call , but this only gets me this far: ----------------------------------------------- C:\cam\util\instiki-0.13.0>ruby C:\cam\util\instiki-0.13.0\script\reset_references Loading Rails for development environment... The DL driver for sqlite3-ruby is deprecated and will be removed in a future release. Please update your installation to use the Native driver. C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection _adapters/abstract_adapter.rb:128:in `log'': SQLite3::SQL Exception: no such table: webs: SELECT * FROM webs (ActiveRecord::StatementInvalid) from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:346:in `catch_schema_changes'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:165:in `select_all'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/base.rb:427:in `find_by_sql'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/base.rb:997:in `find_every'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/base.rb:418:in `find'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/active_record/deprecated_finders.rb:39:in `find_all_without_deprecation'' from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/../../activesupport/lib/active_support/deprecation.rb:94:in `find_all'' from C:/cam/util/instiki-0.13.0/script/reset_references:17 C:\cam\util\instiki-0.13.0>c:\cam\util\sqlite3.exe db\production.db.sqlite3 "select * from webs" 1|2005-09-21 12:08:26|2008-05-08 16:23:01|localnotes|localnotes|password| |false|false|false|textile|008B26|0|false|false ----------------------------------------------- Some diagnostic stuff: C:\cam\util>ruby -v ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32] Windows XP SP2 instiki\lib\native\win32 and the directory of my sqlite3.exe are both on my PATH. Cheers, cam _______________________________________________ Instiki-users mailing list Instiki-users@rubyforge.org http://rubyforge.org/mailman/listinfo/instiki-users
Matthias Tarasiewicz
2008-May-19 12:51 UTC
[Instiki] Errors upgrading storage 0.10 to 0.13
hello, the script seems to be started in development mode (see the line where it says "Loading Rails for development environment..."). you would need to change that to the production environment. for a quick fix: you can change the settings in database.yml to be the same for development as for the production environment. if that does not do the trick, please tell me so i can take a look at the migration script. regards, matthias On 19.05.2008, at 12:58, cam wrote:> Hello all, > > I am having trouble getting my 0.10.2 Madeleine-base data migrated to > sqlite on 0.13. I have closely followed the README, the FAQ and found > a few relevant posts on this list but I am unable to get > reset_references to run properly. So far I have successfully managed > to generate the SQL to populate sqlite and it seems to have worked in > that the script threw no errors and I can now see various populated > tables when I mount production.db.sqlite3. > > I''d be vastly grateful for any help - I miss the ease of use of > instiki and the info that I have in it is nearly 3 years worth of > personal notes on my various job processes - its invaluable. Failing a > fix for instiki, can anyone point me at something that can convert an > unpacked snapshot to a format that I could import into another wiki or > tool? > > Going to the next step of the upgrade process, after sqlite import, to > run rest_references, here''s what I''m getting: > > ----------------------------------------------- > C:\cam\util\instiki-0.13.0>ruby > C:\cam\util\instiki-0.13.0\script\reset_references > Loading Rails for development environment... > The DL driver for sqlite3-ruby is deprecated and will be removed > in a future release. Please update your installation to use the > Native driver. > C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/abstract_adapter.rb:128:in `log'': > SQLite3::SQL > Exception: no such table: wiki_references: DELETE FROM wiki_references > WHERE 1=1 (ActiveRecord::StatementInvalid) > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:346:in > `catch_schema_changes'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:155:in `delete'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/base.rb:513:in > `delete_all'' > from C:/cam/util/instiki-0.13.0/script/reset_references:15 > ----------------------------------------------- > > Since I can see there IS a wiki_references table, altho its empty: > > ----------------------------------------------- > C:\cam\util>sqlite3.exe instiki-0.13.0\db\production.db.sqlite3 > "select * from wiki_references" > > C:\cam\util>sqlite3.exe instiki-0.13.0\db\production.db.sqlite3 > "select * from webs" > 1|2005-09-21 12:08:26|2008-05-08 16:23:01|localnotes|localnotes|XXX| > |false|false|false|textile|008B26|0|false|false > ----------------------------------------------- > > I thought I would comment out the wiki_references.delete_all call , > but this only gets me this far: > > ----------------------------------------------- > C:\cam\util\instiki-0.13.0>ruby > C:\cam\util\instiki-0.13.0\script\reset_references > Loading Rails for development environment... > The DL driver for sqlite3-ruby is deprecated and will be removed > in a future release. Please update your installation to use the > Native driver. > C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection _adapters/abstract_adapter.rb:128:in `log'': > SQLite3::SQL > Exception: no such table: webs: SELECT * FROM webs > (ActiveRecord::StatementInvalid) > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:346:in > `catch_schema_changes'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:145:in `execute'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/connection_adapters/sqlite_adapter.rb:165:in > `select_all'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/base.rb:427:in > `find_by_sql'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/base.rb:997:in > `find_every'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/base.rb:418:in > `find'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/lib/ > active_record/deprecated_finders.rb:39:in > `find_all_without_deprecation'' > from C:/cam/util/instiki-0.13.0/vendor/rails/activerecord/ > lib/../../activesupport/lib/active_support/deprecation.rb:94:in > `find_all'' > from C:/cam/util/instiki-0.13.0/script/reset_references:17 > > C:\cam\util\instiki-0.13.0>c:\cam\util\sqlite3.exe db > \production.db.sqlite3 "select * from webs" > 1|2005-09-21 12:08:26|2008-05-08 16:23:01|localnotes|localnotes| > password| > |false|false|false|textile|008B26|0|false|false > > ----------------------------------------------- > > Some diagnostic stuff: > > C:\cam\util>ruby -v > ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32] > Windows XP SP2 > > instiki\lib\native\win32 and the directory of my sqlite3.exe are both > on my PATH. > > Cheers, > cam > > _______________________________________________ > Instiki-users mailing list > Instiki-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instiki-users