Attached is a small patch to make the sql queries compatible with both mysql and postgres. Basically the "||" should be "OR" and isnull() should be IS NULL. FYI this fix has been reported and fixed against other modules http://drupal.org/node/466166, http://drupal.org/node/619150

CommentFileSizeAuthor
uc_payflowpro.module.patch796 bytesaaron1234nz

Comments

kwinters’s picture

kwinters commented

Thanks for the patch. I confirmed that the query still works in MySQL, then committed. It may be a little while before a new release goes out, since there are no other completed changes.

This should really be documented in the SQL coding standards: http://drupal.org/node/2497

kwinters’s picture

kwinters commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

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