When installing fb_devel on a Postgres backend, an error is generated by this bit of code on line 18 in fb_devel.install

    $count = db_query('SELECT count(uid) FROM {users} WHERE data LIKE :as OR data LIKE :iau OR data LIKE :fbu',
      array(':as' => '%\"app_specific\"%',
        ':iau' => '%\"is_app_user\"%',
        ':fbu' => '%\"fbu\"%'))->fetchField();

The error is: ERROR: invalid input syntax for type bytea

This is due to the backslash characters.

I was able to remove the error by removing the backslashes, but not being familiar with the system, I don't know if that breaks something else.

I believe they are unnecessary though.

CommentFileSizeAuthor
#3 fb-postgres_compat-1790496-1.patch1.35 KBaacraig
#2 fb-postgres_compat-1790496.patch675 bytesaacraig

Comments

Dave Cohen’s picture

Dave Cohen commented
Status: Active » Needs review

The rules about escaping might have changed. I'll have to test that on mysql before committing. Thanks.

That code is about catching erroneous data that was once stored in the serialized user data. Might be safe to get rid of it entirely.

aacraig’s picture

aacraig commented
StatusFileSize
new fb-postgres_compat-1790496.patch675 bytes

I've created a patch for this from the latest code base on git.

aacraig’s picture

aacraig commented
StatusFileSize
new fb-postgres_compat-1790496-1.patch1.35 KB

This patch includes the install file changes, as well as a similar patch in .module.

I will continue to add patches in this thread with all of the changes necessary as I find them.