I am trying to save data entered in a form and nothing seems to be saving. What do you I have to look at to ensure everything is set-up correctly? I have looked in my database.yml file and all looks good and the database that I am trying to use exist. Thanks, -S -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Shandy Nantz wrote:> I am trying to save data entered in a form and nothing seems to be > saving. What do you I have to look at to ensure everything is set-up > correctly? I have looked in my database.yml file and all looks good and > the database that I am trying to use exist. Thanks, > > -S >There should be a lot of good information in your log files like what was sent to the controller and what the sql for accessing the database looked like. It sounds like you did not get an error which means that your parameters and sql were ok. I would suspect you somehow are looking for your data in the wrong place. When you say it is not saving, do you mean that it is not fetched if you try to list it (or do something like a=Type.find :all in a script/console window). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Norm wrote:>> > There should be a lot of good information in your log files like what > was sent to the controller and what the sql for accessing the database > looked like. It sounds like you did not get an error which means that > your parameters and sql were ok. I would suspect you somehow are > looking for your data in the wrong place. > When you say it is not saving, do you mean that it is not fetched if you > try to list it (or do something like a=Type.find :all in a > script/console window).Not really, this is what I see: Processing AdminController#create_user (for 127.0.0.1 at 2008-11-15 12:39:02) [POST] Session ID: 055075e032051a9365cecbcbf4abb283 Parameters: {"commit"=>"Submit", "post"=>{"emailvrfy"=>"test-/E1597aS9LQAvxtiuMwx3w@public.gmane.org", "passwordvrfy"=>"test72", "password"=>"test72", "email"=>"test-/E1597aS9LQAvxtiuMwx3w@public.gmane.org"}, "action"=>"create_user", "controller"=>"admin"} [4;35;1mUser Columns (0.007000) [0m [0mSHOW FIELDS FROM users [0m [4;36;1mSQL (0.003000) [0m [0;1mBEGIN [0m [4;35;1mUser Load (0.000000) [0m [0mSELECT * FROM users WHERE (users.email IS NULL) LIMIT 1 [0m [4;36;1mSQL (0.000000) [0m [0;1mCOMMIT [0m Redirected to http://localhost:3000/league/beginning Completed in 0.03700 (27 reqs/sec) | DB: 0.01000 (27%) | 302 Found [http://localhost/admin/create_user] When I try and manually add a user through irb nothing even though it appears that it is saving. The only thing that I can guess is that it is being saved to another table somewhere but my .yml seems to think it is using the same table that I am looking at. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Nov 15, 7:42 pm, Shandy Nantz <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> [4;35;1mUser Load (0.000000) [0m [0mSELECT * FROM users WHERE > (users.email IS NULL) LIMIT 1 [0mthis looks suspicious, (I''m guessing it''s a query from validates_uniqueness_of) - it looks like your controller is looking for params in the wrong place. the logs show that nothing attempted to write the data at all, usually this is because of a failed validation. Fred> [4;36;1mSQL (0.000000) [0m [0;1mCOMMIT [0m > Redirected tohttp://localhost:3000/league/beginning > Completed in 0.03700 (27 reqs/sec) | DB: 0.01000 (27%) | 302 Found > [http://localhost/admin/create_user] > > When I try and manually add a user through irb nothing even though it > appears that it is saving. The only thing that I can guess is that it is > being saved to another table somewhere but my .yml seems to think it is > using the same table that I am looking at. > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Frederick Cheung wrote:> On Nov 15, 7:42�pm, Shandy Nantz <rails-mailing-l...-ARtvInVfO7m5VldFQK4jKA@public.gmane.orgt> > wrote: >> � �[4;35;1mUser Load (0.000000) [0m � �[0mSELECT * FROM users WHERE >> (users.email IS NULL) LIMIT 1 [0m > > this looks suspicious, (I''m guessing it''s a query from > validates_uniqueness_of) - it looks like your controller is looking > for params in the wrong place. > the logs show that nothing attempted to write the data at all, usually > this is because of a failed validation. > > FredYou are correct, I was validates_uniqueness_of :email and then not passing an email address. Thanks for the help, hope everyone is having a good weekend. -S -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---