Hello all, Apologies for the repost - Yahoo mangled my first attempt... 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::StatementInvali d) 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::StatementInvali d) 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