Cron triggers SQL error
blackdog - July 31, 2009 - 07:48
| Project: | Decisions |
| Version: | HEAD |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
When running cron, this error pops up:
Unknown column "d.created" in "where clause" query: SELECT d.nid FROM decisions d INNER JOIN node n ON d.nid = n.nid WHERE (d.created + d.runtime) < 1249026115 AND d.active = 1 AND d.runtime <> 0 in /sites/all/modules/decisions/decisions.module on line 82
I'm guessing the d.created should be n.created, so I made a patch for that.
| Attachment | Size |
|---|---|
| decisions_cron.patch | 981 bytes |
#1
Actually, "created" is the node creation date, not the start date for the decision. I fixed this properly in CVS, thanks for reporting the issue.
#2
Automatically closed -- issue fixed for 2 weeks with no activity.