Nick Burch wrote:
On Tue, 29 Aug 2006, Clair wrote:
I'm trying to convert a database to the 'new' schema used in the latest OG version. When running wiki-toolkit-setupdb, I get the following message:
Upgrading: old_to_9 Grabbing and upgrading old data... read 333 nodes... read 1250 contents... done
Hmm, it doesn't seem to be doing the next steps, where it drops the tables. After that, it'll create the new versions (including the version table), and then put all your data back
If it breaks on the permissions check, you ought to get an error reported to you. Odd that you're not. However, that's my hunch - check that your database user can create and drop tables
Yep, the database user can do 'all'.
If it helps, the script I'm using is: #!/usr/bin/perl use CGI::Carp qw( fatalsToBrowser ); use Wiki::Toolkit
print "Content-type: text/plain\n\n"; system("wiki-toolkit-setupdb --type mysql --name [database] --user [user] --pass [password]")
(as CGI)