Running with:
RAILS_ENV=production ./check_database
I get this:
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.17/lib/active_record/connection_adapters/abstract_adapter.rb:227:in
`log': Mysql::Error: Column 'develproject_id' in where clause is
ambiguous: SELECT `db_packages`.* FROM `db_packages` LEFT JOIN
db_projects prj ON db_packages.db_project_id = prj.id LEFT JOIN flags
f ON f.db_project_id = prj.id AND (ISNULL(f.flag) OR flag = 'access')
LEFT JOIN project_user_role_relationships ur ON ur.db_project_id =
prj.id WHERE ((develpackage_id is not null) or (develproject_id is not
null)) GROUP BY db_packages.id (ActiveRecord::StatementInvalid)
On Tue, Apr 16, 2013 at 9:46 AM, Adrian Schröter
On Dienstag, 16. April 2013, 09:37:51 wrote Jon Nelson:
Whenever I use rdelete to try to remove a project on a local OBS install, this is what I get:
Uncaught exception: Mysql::Error: Column 'repository_id' cannot be null: INSERT INTO `path_elements` (`repository_id`, `position`, `parent_id`) VALUES(NULL, 1, 204)
OBS version 2.3.8
What's going on?
your database is corrupt.
We have the script/check_database script to validate it.
-- Adrian Schroeter SUSE Linux Products GmbH email: adrian@suse.de
-- Jon -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org