[opensuse-buildservice] osc rdelete never works for me
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? -- Jon -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
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 -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
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 <adrian@suse.de> wrote:
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
On Tue, Apr 16, 2013 at 10:55 AM, Jon Nelson <jnelson-suse@jamponi.net> wrote:
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)
What do I need to do to fix this problem?
On Tue, Apr 16, 2013 at 9:46 AM, Adrian Schröter <adrian@suse.de> wrote:
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.
-- Jon -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
participants (2)
-
Adrian Schröter -
Jon Nelson