Hey,
I am using drupal 6.5 with postgresql. Every thing is fine althought I have not tested views and cck but according to my requirement I first needed service module. With service module also every thing is fine but when I run cron it gives me an error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: character varying < integer LINE 2: WHERE timestamp < 1224134302 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in C:\xampp\htdocs\postgre\includes\database.pgsql.inc on line 138.
* user warning: query: DELETE FROM services_timestamp_nonce WHERE timestamp < 1224134302 in C:\xampp\htdocs\postgre\sites\all\modules\services\services.module on line 17.

But I have realized after viewing the code in service.module closely that when you work with postgresql you should be very much careful with data types.

$expiry_time = time() - variable_get('services_key_expiry', 30);
db_query("DELETE FROM {services_timestamp_nonce}
WHERE timestamp < %d", $expiry_time);

so when I changed this code to somewhat like this

$expiry_time = time() - variable_get('services_key_expiry', 30);
db_query("DELETE FROM {services_timestamp_nonce}
WHERE timestamp < ''%s", $expiry_time);

so I request the author of this module to please reflect the change in next release.
Or
is there any patch that could be helpful for me??

Comments

snelson’s picture

Assigned: Unassigned » snelson
Status: Active » Fixed

Committed to D5 and D6. Thanks!

Status: Fixed » Closed (fixed)

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