If you use the schema type blob for the data field in postgres that field is a bytea. The problem is if you store a '\r\n' into such a field it comes out as '\\015\\012' which causes php's unserialize to fail, as in rules_get_configured_items().

To see the bug occur start with a drupal install on a postgresdb. Install the rules module. Create a triggered rule and add the system action "Send a mail to a user." Then set a message in that action that contains a carriage return and the install crashes (at least it does with php 5.1.6 and postgres 8.1.4 on redhat).

Instead you may want to change the schema type to 'blob' in the .install file.

Comments

fago’s picture

Component: Rules Core » Rules Engine

ah, there was already a related bug reposted.

>Instead you may want to change the schema type to 'blob' in the .install file.

Is now using "blob" right or not? Currently there should be used "blob" everywhere.

fago’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.