Problem: rails and mysql

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
:frowning:

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
:frowning:

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 :frowning:

Thanks,
Ben L.

Ben L. 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 :frowning:

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 :frowning:

ok…the problem is mysql 5.0.24, i reinstalled the 5.0.22 and now it
works

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 :frowning:

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 ?

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 :frowning:

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