PostgreSQL compatibility
gatoth - November 4, 2009 - 10:09
| Project: | Web Links |
| Version: | 6.x-2.3 |
| Component: | Contrib: Checker |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
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