Insert blob - rails 1.0.0 mysql 3.23 - sql syntax error


#1

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 B., MD
ECWA Evangel Hospital
Jos, Nigeria
http://www.ecwaevangel.org
+234-803-385-4268 (mobile/sms)
+234-73-452-980 (home)