diff options
author | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
commit | fc2b26a6a27d19ecbfbb2202fd35b37568c65181 (patch) | |
tree | f9123f21920265535bfab4987d8aac674bbbbe08 /xml-rpc.php | |
parent | f8232151a0a4bdd430e928d742686a2330e99d68 (diff) |
add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201)
Diffstat (limited to 'xml-rpc.php')
-rw-r--r-- | xml-rpc.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/xml-rpc.php b/xml-rpc.php index 07f423cbd..0117657d0 100644 --- a/xml-rpc.php +++ b/xml-rpc.php @@ -175,7 +175,7 @@ if (authenticate_user($link, $login, $pass)) { $result = db_query($link, "SELECT - id, feed_url, cat_id, title, SUBSTRING(last_updated,1,19) AS last_updated + id, feed_url, cat_id, title, ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated FROM ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]); @@ -341,7 +341,7 @@ $query = "SELECT title,link,content,feed_id,comments,int_id, marked,unread, - SUBSTRING(updated,1,16) as updated, + ".SUBSTRING_FOR_DATE."(updated,1,16) as updated, author FROM ttrss_entries,ttrss_user_entries WHERE id = '$article_id' AND ref_id = id AND owner_uid = " . $_SESSION["uid"] ; |