The scheduled dates of advertising are not recorded in the database.
Can you review the function ad_nodeapi() with $op == "insert"
Before :
db_query("INSERT INTO {ads} (aid, uid, adstatus, adtype, redirect, autoactivate, autoexpire, activated, maxviews, maxclicks) VALUES(%d, %d, '%s', '%s', '%s', %d, %d, %d, %d, %d)", $node->nid, $node->uid, $node->adstatus, $node->adtype, url('ad/redirect/'. $node->nid, array('absolute' => TRUE)), $node->autoactivate ? strtotime($node->autoactivate) : '', $node->autoexpire ? strtotime($node->autoexpire) : '', $activated, $node->maxviews, $node->maxclicks);
After :
db_query("INSERT INTO {ads} (aid, uid, adstatus, adtype, redirect, autoactivate, autoexpire, activated, maxviews, maxclicks) VALUES(%d, %d, '%s', '%s', '%s', %d, %d, %d, %d, %d)", $node->nid, $node->uid, $node->adstatus, $node->adtype, url('ad/redirect/'. $node->nid, array('absolute' => TRUE)), $node->autoactivate, $node->autoexpire, $activated, $node->maxviews, $node->maxclicks);
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | ad-insert-date.patch | 1.16 KB | john franklin |
Comments
Comment #1
john franklin commentedFixed. Thanks for the patch.
(Patch file attached here for others who need to apply to their deployments.)
Comment #2
grasmash commentedI was experiencing the same problem. Has this been committed?
Comment #3
john franklin commentedYes, it is committed to dev. (commit)