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