When I send a mail it sends it and it creates the node but it throws up this error:
user error: DB Error: unknown error
query: UPDATE node SET body = "
This email was sent to users with the following roles: Site admin
This is another test mail" WHERE nid = 40 in /home/.sites/58/site34/web/includes/database.pear.inc on line 89.
I'm using Drupal 4.1 and Postgres.
Does anyone know how to solve this?
Comments
Comment #1
nedjoThanks for noting this. The problem is related to my use of an update immediately after the node with the mail is created. (I did this so that the email would include information on what roles it was sent to).
Perhaps the problem is caused by Postgresql locking the newly-created record?
To disable this update (and therefore end the error message), delete or comment out (put two forward-slashes in front of) the line:
Comment #2
nedjoI've made the update database-specific (i.e., won't update if database type is pgsql). This should solve the error, though I don't have a pgsql installation to test on.
Comment #3
(not verified) commented