are there anyone test webcal module with postgresql?

this query belong to mysql and not valid with postgresql
$sql = "UPDATE $app_user_table u, $app_session_table s SET u.access = '".time()."' WHERE s.sid = '$sid' AND u.uid = s.uid AND s.uid <> 0";

query for postgresql
$sql = "UPDATE $app_user_table SET access = '".time()."' FROM $app_session_table s WHERE s.sid = '$sid' AND $app_user_table.uid = s.uid AND s.uid <> 0";

plz test my code above. thx

Comments

jaredwiltshire’s picture

Title: user-app-drupal-1.0.x.php query error with postgresql » PostgreSQL support
Category: bug » feature
Priority: Critical » Normal

Not a priority for me at the moment, but if someone who is familiar with PostgreSQL would like to make some changes feel free to post a patch.

duaelfr’s picture

Status: Active » Closed (won't fix)

This version of WebCalendar integration is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.