]> git.wh0rd.org - tt-rss.git/commitdiff
Merge pull request #381 from bram85/master
authorAndrew Dolgov <gothfox@users.noreply.github.com>
Thu, 19 Jun 2014 10:56:42 +0000 (14:56 +0400)
committerAndrew Dolgov <gothfox@users.noreply.github.com>
Thu, 19 Jun 2014 10:56:42 +0000 (14:56 +0400)
Fix for testing filters getting stuck sometimes.

include/functions2.php

index 5228d875ce91a1dcd373f024999a3693a860cab0..507c5343e46e0c3cca80106160cb000595cc885b 100644 (file)
                                // Try to check if SQL regexp implementation chokes on a valid regexp
 
 
-                               $result = db_query("SELECT true AS true_val FROM ttrss_entries,
-                                       ttrss_user_entries, ttrss_feeds
+                               $result = db_query("SELECT true AS true_val
+                                        FROM ttrss_entries
+                                        JOIN ttrss_user_entries ON ttrss_entries.id = ttrss_user_entries.ref_id
+                                        JOIN ttrss_feeds ON ttrss_feeds.id = ttrss_user_entries.feed_id
                                        WHERE $filter_query_part LIMIT 1", false);
 
                                if ($result) {