First off, SimpleFeed is by far and away the best feed to node module out there, great job and thanks so so much!

CVS HEAD as of May 9 has a problem with PostgreSQL (may be specific to databases with UNICODE encoding, or just to the 7.4.x versions) with regard to the serialization/unserialization of data to/from the simplefeed_feed_item_cache table.

It seems as it stands now, unserialization is failing and breaking the entire feed update process.

The only way I could get it to work was to change the INSERT sql to use a '%s' instead of %b, and wrap the serialize() call with a base64_encode, and then add a base64_decode call before unserialize().

There may be a better fix somewhere, but I was unable to find it in the hour or so I debugged the issue.

If you would like a patch, I'm more than happy to attach one.

Thanks again!

Comments

csevb10’s picture

If you want to submit a patch, I'd love to see it/review it. If it fixes problems in postgresql & works for mysql, it might be the better way to go. Thanks!

m3avrck’s picture

Status: Active » Fixed

serialize() and unserialized() have been removed, should not be an issue anymore!

Anonymous’s picture

Status: Fixed » Closed (fixed)