I gave that a try, however I seem to be having some issues with ActiveRecord (btw, the user model doesn't seem to have a Terms of Use must be accepted). I am replicating the steps that script/create_admin uses, is this script out of date?
Also the SQL statement seems to be ok when I run it directy in mysql, I am including the output of the mysql statement and what I get in IRB. r...@vallekas:/opt/gitorious# mysql -u git -p git_production Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 788 Server version: 5.0.75-0ubuntu10 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SELECT `users`.id FROM `users` WHERE (LOWER(`users`.`login`) = BINARY 'admin') LIMIT 1; Empty set (0.00 sec) mysql> ### IRB ### >> admin => #<User id: 0, login: "admin", email: "[email protected]", crypted_password: nil, salt: nil, created_at: nil, updated_at: nil, remember_token: nil, remember_token_expires_at: nil, activation_code: nil, activated_at: nil, ssh_key_id: nil, fullname: nil, url: nil, identity_url: nil, is_admin: true, suspended_at: nil, aasm_state: "pending", public_email: true, wants_email_notifications: true, password_key: nil, avatar_file_name: nil, avatar_content_type: nil, avatar_file_size: nil, avatar_updated_at: nil> >> admin.wants_email_notifications = false => false >> admin.save ActiveRecord::StatementInvalid: Mysql::Error: MySQL server has gone away: SELECT `users`.id FROM `users` WHERE (LOWER(`users`.`login`) = BINARY 'admin') LIMIT 1 from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract_adapter.rb:212:in `log' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ connection_adapters/mysql_adapter.rb:320:in `execute' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ connection_adapters/mysql_adapter.rb:595:in `select' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/query_cache.rb:62:in `select_all' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ base.rb:661:in `find_by_sql' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ base.rb:1548:in `find_every' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ base.rb:1505:in `find_initial' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ base.rb:692:in `exists?' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ validations.rb:758:in `validates_uniqueness_of' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ base.rb:2143:in `with_scope' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ base.rb:2151:in `with_exclusive_scope' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ validations.rb:757:in `validates_uniqueness_of' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ validations.rb:399:in `validates_each' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ validations.rb:396:in `each' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ validations.rb:396:in `validates_each' ... 5 levels... from /opt/gitorious/vendor/rails/activesupport/lib/active_support/ callbacks.rb:90:in `send' from /opt/gitorious/vendor/rails/activesupport/lib/active_support/ callbacks.rb:90:in `run' from /opt/gitorious/vendor/rails/activesupport/lib/active_support/ callbacks.rb:276:in `run_callbacks' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ validations.rb:1029:in `valid_without_callbacks?' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ callbacks.rb:315:in `valid?' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ validations.rb:1008:in `save_without_dirty' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ dirty.rb:79:in `save_without_transactions' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ transactions.rb:229:in `send' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ transactions.rb:229:in `with_transaction_returning_status' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/database_statements.rb:136:in `transaction' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ transactions.rb:182:in `transaction' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ transactions.rb:228:in `with_transaction_returning_status' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ transactions.rb:196:in `save' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ transactions.rb:208:in `rollback_active_record_state!' from /opt/gitorious/vendor/rails/activerecord/lib/active_record/ transactions.rb:196:in `save' from (irb):15>> On May 27, 2:47 am, Marius Mårnes Mathiesen <[email protected]> wrote: > On 27. mai. 2009, at 05.10, Telmo wrote: > > > As you can see I don't get any error, just a false return from the > > User.save. Has anyone encountered a similar issue? > > There are two methods for saving a record in Rails: #save, which > returns whether it was saved and #save! which raises an error if it > couldn't be saved. In your case, the latter would probably give you an > error like > > ActiveRecord::RecordInvalid: Validation failed: Login can't be blank, > Login is too short (minimum is 3 characters), Login is invalid, Terms > of use must be accepted > > Which means 1) you need to supply a login for the user and 2) the > terms of use must be accepted. Set these, and you should be good to go. > > HTH, > - Marius --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Gitorious" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/gitorious?hl=en -~----------~----~----~----~------~----~------~--~---
