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

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Mike B. (Guest)
on 2006-01-29 21: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


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
+234-803-385-4268 (mobile/sms)
+234-73-452-980 (home)
This topic is locked and can not be replied to.