Issues - eol/eol

eol / eol

Description:

Encyclopedia of Life

Sort by: Priority | Votes | Last Updated

Loading…

2.

0 votes

Another problem on bin/recreate_databases
4 comments Created 4 months ago by hansku

Title

Body
Still trying to get the database setup on first install. It mostly works, but I still see a "SQL ERROR" on the home page. This is what I see when running bin/recreate_databases: ... == 20090706193825 FixNonUserRatings: migrating ================================ -- execute("update eol_data_test.data_objects dato left join eol_test.users_data_objects_ratings udor on (udor.data_object_id=dato.id) set dato.data_rating=3.9 where dato.data_rating>3.9 and udor.id IS NULL;") rake aborted! Mysql::Error: Table 'eol_test.users_data_objects_ratings' doesn't exist: update eol_data_test.data_objects dato left join eol_test.users_data_objects_ratings udor on (udor.data_object_id=dato.id) set dato.data_rating=3.9 where dato.data_rating>3.9 and udor.id IS NULL; and then: An Exception was thrown by scenario: foundation rake aborted! undefined method `find_by_uri_and_title_and_link_and_agent_id_and_description_and_logo_cache_url' for #<Class:0xb6e80880>
or cancel

Still trying to get the database setup on first install. It mostly works, but I still see a "SQL ERROR" on the home page.

This is what I see when running bin/recreate_databases:
... == 20090706193825 FixNonUserRatings: migrating ================================ -- execute("update eol_data_test.data_objects dato left join eol_test.users_data_objects_ratings udor on (udor.data_object_id=dato.id) set dato.data_rating=3.9 where dato.data_rating>3.9 and udor.id IS NULL;") rake aborted!
Mysql::Error: Table 'eol_test.users_data_objects_ratings' doesn't exist: update eol_data_test.data_objects dato left join eol_test.users_data_objects_ratings udor on (udor.data_object_id=dato.id) set dato.data_rating=3.9 where dato.data_rating>3.9 and udor.id IS NULL;

and then:

An Exception was thrown by scenario: foundation
rake aborted!
undefined method `find_by_uri_and_title_and_link_and_agent_id_and_description_and_logo_cache_url' for #<Class:0xb6e80880>

Comments

hansku Mon Aug 24 21:34:38 -0700 2009 | link

Also, if I simply take 20090706193825 out of the migrate directory, the migration completes. The error seen at the end of bin/recreate_databases is then:

An Exception was thrown by scenario: foundation
rake aborted!
undefined method `ping_host_url=' for #<Collection:0xb6e94114>

Comment
Also, if I simply take 20090706193825 out of the migrate directory, the migration completes. The error seen at the end of bin/recreate_databases is then: An Exception was thrown by scenario: foundation rake aborted! undefined method `ping_host_url=' for #<Collection:0xb6e94114>
or cancel

hansku Mon Aug 24 22:04:04 -0700 2009 | link

On my attempt to load the site, I get this error:

RuntimeError in ContentController#index

Called id for nil, which would mistakenly be 4 -- if you really wanted the id of nil, use object_id
RAILS_ROOT: /var/www/railsapp

Application Trace | Framework Trace | Full Trace
app/controllers/application.rb:536:in set_session_hierarchy_variable'<br/> app/controllers/application.rb:628:inset_current_language'
app/controllers/application.rb:628:in set_current_language'<br/> /usr/bin/mongrel_rails:19:inload' /usr/bin/mongrel_rails:19

Comment
On my attempt to load the site, I get this error: RuntimeError in ContentController#index Called id for nil, which would mistakenly be 4 -- if you really wanted the id of nil, use object_id RAILS_ROOT: /var/www/railsapp Application Trace | Framework Trace | Full Trace app/controllers/application.rb:536:in `set_session_hierarchy_variable' app/controllers/application.rb:628:in `set_current_language' app/controllers/application.rb:628:in `set_current_language' /usr/bin/mongrel_rails:19:in `load' /usr/bin/mongrel_rails:19
or cancel

hansku Mon Aug 24 23:14:35 -0700 2009 | link

Seems the revert of eol.sql and eol_data.sql to the older versions broke something (some tables went missing). Using the previous versions fixed the problem and the foundation scenario ran without error. Migrate did stop at AddCuratorialToComments, though:
== 20090406173750 AddCuratorialToComments: migrating ========================== -- add_column(:comments, :from_curator, :boolean, {:default=>nil, :null=>false}) rake aborted!
Mysql::Error: Duplicate column name 'from_curator': ALTER TABLE comments ADD from_curator tinyint(1) NOT NULL

This ran fine:
root@rails:/var/www/railsapp# git checkout HEAD~3 db/eol.sql
root@rails:/var/www/railsapp# git checkout HEAD~3 db/eol_data.sql
root@rails:/var/www/railsapp# bin/recreate_databases

Comment
Seems the revert of eol.sql and eol_data.sql to the older versions broke something (some tables went missing). Using the previous versions fixed the problem and the foundation scenario ran without error. Migrate did stop at AddCuratorialToComments, though: == 20090406173750 AddCuratorialToComments: migrating ========================== -- add_column(:comments, :from_curator, :boolean, {:default=>nil, :null=>false}) rake aborted! Mysql::Error: Duplicate column name 'from_curator': ALTER TABLE `comments` ADD `from_curator` tinyint(1) NOT NULL This ran fine: root@rails:/var/www/railsapp# git checkout HEAD~3 db/eol.sql root@rails:/var/www/railsapp# git checkout HEAD~3 db/eol_data.sql root@rails:/var/www/railsapp# bin/recreate_databases
or cancel

hansku Tue Aug 25 18:03:46 -0700 2009 | link

Downloaded master again, put back in my database.yml and mongrel_cluster.yml files, and ran bin/recreate_databases--all completed successfully!

Thanks for your help and patience while I try to get a working version up.

Comment
Downloaded master again, put back in my database.yml and mongrel_cluster.yml files, and ran bin/recreate_databases--all completed successfully! Thanks for your help and patience while I try to get a working version up.
or cancel

Parsed with GitHub Flavored Markdown

Labels

Another problem on bin/recreate_databases

Comments