I've been fighting for days to get the mapper working with anything. Then I looked at the logs and found that there's an sql error. There's improper quoting happening when using postgres. In the function _feedapi_mapper_store_mapping(), the queries quote the %s value as "%s". That doesn't work with postgres. I changed it to \'%s\' and everything seemed worked fine.

Sorry I don't have time to make a proper patch. I havn't tested this with mysql to see if this will still work with it.

CommentFileSizeAuthor
#1 341251_postgres_compatibility.patch1.03 KBalex_b

Comments

alex_b’s picture

Version: 6.x-1.0-beta2 » 6.x-1.x-dev
Status: Active » Needs review
StatusFileSize
new1.03 KB

This concerns all versions of FeedAPI mapper.

Patch needs to be tested with pgsql and mysql. Critical focus should be on whether serialized data stays sane.

aron novak’s picture

Status: Needs review » Reviewed & tested by the community

It also works on MySQL.

alex_b’s picture

Status: Reviewed & tested by the community » Fixed

Committed to DRUPAL-6--1 .

alex_b’s picture

Status: Fixed » Closed (fixed)

Rolled out in beta 4