RE: [Myexperiment-discuss] install trouble on centos 4.5 machine --- any help?

[David R Newman]

Hi Matt,

 

The error is caused by trying to remove a table that is not currently in the database.   What was the state of you database before you ran rake db:migrate?  If it is a blank (i.e. tables with no data) database or you are not worried about the data in the database you can run the following commands:

 

rake db:migrate VERSION=0

rake db:migrate

 

This should avoid any errors because you won’t  have a database that is not at a specific version of migration.  If  you don’t want to lose your database data, you can hack it by creating a temporary sitealizer table manually at the mysql command line with the following create table statement:

 

CREATE TABLE `sitealizer` (

  `id` int(11) NOT NULL auto_increment,

  `path` varchar(255) default NULL,

  `ip` varchar(255) default NULL,

  `referer` varchar(255) default NULL,

  `language` varchar(255) default NULL,

  `user_agent` varchar(255) default NULL,

  `created_at` datetime default NULL,

  `created_on` date default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

Then you  should be able to run rake db:migrate without error, as it will have a sitealizer table it can remove.

 

Hope this helps.  If you are still having problems, please email back.

 

Regards

 

David Newman

myExperiment Team Member

 

From: address@hidden [mailto:address@hidden On Behalf Of Matthew Links
Sent: 19 August 2008 19:32
To: address@hidden
Subject: [Myexperiment-discuss] install trouble on centos 4.5 machine --- any help?

.

I'm trying to install myExperiment on a centOS 4.5 machine and I'm hitting a problem.

I'm following the details from here

http://wiki.myexperiment.org/index.php/Developer:Installation

When I run

 rake db:migrate

I'm getting an error about sitealizer (see end of message)

any help would be greatly appreciated.

cheers,

Matt

address@hidden trunk]$ rake db:migrate
(in /usr/local/myexperiment/trunk)
== RemoveSitealizer: migrating ================================================
-- drop_table(:sitealizer)
rake aborted!
Mysql::Error: #42S02Unknown table 'sitealizer': DROP TABLE sitealizer

(See full trace by running task with --trace)
address@hidden trunk]$ rake db:migrate -strace
rake aborted!
no such file to load -- ace
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:2073:in `require'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:2073:in `do_option'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:2107:in `handle_options'
/usr/local/lib/ruby/1.8/getoptlong.rb:613:in `each'
/usr/local/lib/ruby/1.8/getoptlong.rb:610:in `loop'
/usr/local/lib/ruby/1.8/getoptlong.rb:610:in `each'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:2107:in `handle_options'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:1889:in `init'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:1948:in `standard_exception_handling'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:1887:in `init'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:1879:in `run'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:1948:in `standard_exception_handling'
/usr/local/lib/ruby/site_ruby/1.8/rake.rb:1878:in `run'
/usr/local/bin/rake:32

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.5/1619 - Release Date: 18/08/2008 17:39