Closed (fixed)
Project:
Rules
Version:
6.x-1.0-beta3
Component:
Rules Engine
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
27 Nov 2008 at 02:50 UTC
Updated:
19 Feb 2009 at 15:00 UTC
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
Comment #1
fagoah, 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.
Comment #2
fago#322756: postgresql: Fatal error when loading rules from db has been fixed.