Posted by gatoth on November 4, 2009 at 10:09am
Jump to:
| Project: | Web Links |
| Version: | 6.x-2.3 |
| Component: | Contrib: Checker |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (won't fix) |
Issue Summary
query: SELECT l.vid, l.nid, l.url, l.last_checked, l.last_status, l.last_status_info, n.title, n.status as node_published FROM prod_weblinks l INNER JOIN prod_node n ON n.vid=l.vid AND n.nid=l.nid WHERE n.status=1 or (last_status <> '' and !ISNULL(last_status_info)) ORDER BY l.last_checked ASC LIMIT 150 OFFSET 0 in modules/weblinks/contribs/weblinks_checker/weblinks_checker.module on line 323
!ISNULL(last_status_info) should be replaced by last_status_info!=null
Thanx,
Gabor
Comments
#1
Looking on the web, it looks like
(last_status <> '' and !ISNULL(last_status_info)is more correctly(last_status <> '' and last_status_info IS NOT NULL). Unfortunately it is not clear to me whether Postgres will accept that. Can you please confirm?#2
Reopen this when you can answer the question.