Does not display ads under postgresql and (presumably) any non-mysql database
deatech - August 28, 2009 - 07:43
| Project: | Text Link Ads Integration |
| Version: | 6.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Description
On line 428 of textlinkads.module, the following code appears:
$where = ($type == 'text') ? 'text IS NOT NULL && beforetext IS NOT NULL && aftertext IS NOT NULL' : 'rsstext IS NOT NULL';the two instances of "&&" in the SQL query are a non-standard, mysql specific extension which is not compatible with other databases. Both of these should be replaced by "AND".