hi, i''ve a problem, i''ve updated from rails 1.1.4 to the 1.1.6 and from mysql 5.0.22 to mysql 5.0.24. i tryed to start the rail''s server, all ok.... http://localhost:3000... some pages are ok, but some of them have a problem (here a paste of the problem: http://rafb.net/paste/results/0s29O649.html )...so, i removed the 1.1.6 e installed the 1.1.4, tryed...nothing...i think is mysql...i found the part of the code that start the problem: @user = User.new( params[:user] )...the new mysql version doesn''t permit this? how can i correct the code: def register @user = User.new( params[:user] ) if request.post? and @user.save @user = User.new end end sigh, help me please, i''m trying to fix this problem since this morning :( -- Posted via http://www.ruby-forum.com/.
Ben Lisbakken wrote:> Nice! You saved me from having to post. Same thing for me. My host > (OCS Solutions) upgraded to 1.1.6 yesterday, and I now get the same > error on every sql query I make (maybe not all, but I don''t feel like > checking)! Eeeeek! Here''s the first statement that it hits and dies > on:what is the mysql version? i don''t understand if it''s rails or mysql the problem, because i tryed to delete the 1.1.6 and install the 1.1.4 but it''s still not working :( -- Posted via http://www.ruby-forum.com/.
user wrote:> hi, i''ve a problem, i''ve updated from rails 1.1.4 to the 1.1.6 and from > mysql 5.0.22 to mysql 5.0.24. i tryed to start the rail''s server, all > ok.... http://localhost:3000... some pages are ok, but some of them have > a problem (here a paste of the problem: > http://rafb.net/paste/results/0s29O649.html )...so, i removed the 1.1.6 > e installed the 1.1.4, tryed...nothing...i think is mysql...i found the > part of the code that start the problem: @user = User.new( params[:user] > )...the new mysql version doesn''t permit this? how can i correct the > code: > > def register > @user = User.new( params[:user] ) > if request.post? and @user.save > @user = User.new > end > end > > sigh, help me please, i''m trying to fix this problem since this morning > :(Nice! You saved me from having to post. Same thing for me. My host (OCS Solutions) upgraded to 1.1.6 yesterday, and I now get the same error on every sql query I make (maybe not all, but I don''t feel like checking)! Eeeeek! Here''s the first statement that it hits and dies on: @pics = Movie.find(:all, :order => ''movies.rating desc'', :include => [:user]) If I take out the :include then it doesn''t throw an error on it... it then throws an error where I use the association... aka when I do: <%= @pics[0].user.name %> Any help would be much appreciated! Google doesn''t have the answers :( Thanks, Ben Lisbakken -- Posted via http://www.ruby-forum.com/.
user wrote:> what is the mysql version? i don''t understand if it''s rails or mysql the > problem, because i tryed to delete the 1.1.6 and install the 1.1.4 but > it''s still not working :(ok...the problem is mysql 5.0.24, i reinstalled the 5.0.22 and now it works -- Posted via http://www.ruby-forum.com/.
user wrote:> user wrote: >> what is the mysql version? i don''t understand if it''s rails or mysql the >> problem, because i tryed to delete the 1.1.6 and install the 1.1.4 but >> it''s still not working :( > > > ok...the problem is mysql 5.0.24, i reinstalled the 5.0.22 and now it > worksI, I''ve same problem here, but cannot get back to 5.0.22 because of a security bug. What can I do ? -- Posted via http://www.ruby-forum.com/.
jean-marc DETREZ wrote:> user wrote: >> user wrote: >>> what is the mysql version? i don''t understand if it''s rails or mysql the >>> problem, because i tryed to delete the 1.1.6 and install the 1.1.4 but >>> it''s still not working :( >> >> >> ok...the problem is mysql 5.0.24, i reinstalled the 5.0.22 and now it >> works > > I, I''ve same problem here, but cannot get back to 5.0.22 because of a > security bug. What can I do ?You could have a look at http://benr75.com/pages/ruby_on_rails_gentoo_mysql-5.0.24_commands_out_of_sync if you running GENTOO -- Posted via http://www.ruby-forum.com/.