Forum: Ruby on Rails Insert blob - rails 1.0.0 mysql 3.23 - sql syntax error

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
E7949995e1bdf8c0876ca62116d594fc?d=identicon&s=25 Mike Blyth (Guest)
on 2006-01-29 20:38
(Received via mailing list)
I had the same problem and think I've solved it, but only because you
spelled it out so clearly. Caveat: I know essentially zero about the
Rails software or mySQL so be sure to make backups, be cautious, etc.
However, I found that changing line 120 (or so) in

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb

from   "x'#{s}'" to    "0x#{s}" (all the quotes are there in the source,
I haven't added any).

The file may of course be located somewhere else on your system. I had
to reboot the system to make the change take effect but if that's not
convenient for you maybe you can find what process is running that needs
to be restarted.

Hope it works for you.

Mike Blyth, MD
ECWA Evangel Hospital
Jos, Nigeria
http://www.ecwaevangel.org
+234-803-385-4268 (mobile/sms)
+234-73-452-980 (home)
This topic is locked and can not be replied to.