Needs review
Project:
RSVP
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
8 Jun 2011 at 23:05 UTC
Updated:
8 Jun 2011 at 23:05 UTC
The query in rsvp.cron is not PostgreSQL-compatible. The attached patch makes it PostgreSQL-compatible. Note, however, that the new query is not MySQL-compatible. I'm not sure that there's a Standard SQL way to do what is done in this query (MySQL allows multiple tables after the UPDATE keyword, PostgreSQL handles this by using FROM to specify additional tables). To handle both, you're going to need to detect which is in use, and use the appropriate query, but so far I haven't found a reliable way to do this.
For the moment, those using RSVP on a PostgreSQL-based Drupal site might want to apply this patch.
| Comment | File | Size | Author |
|---|---|---|---|
| rsvp_postgresql_compatibility.patch | 608 bytes | ben coleman |