Error in DigitalPoint cron process for Xenforo add-on

Discussion in 'Digital Point Ads' started by SneakyDave, Mar 1, 2011.

  1. #1
    Just an FYI, noticed this in the error logs, happens every time the DigitalPointAds/cron.php runs... Let me know if you need any more info.

    Message: Mysqli statement execute error : Column 'option_value' cannot be null

    File: library/Zend/Db/Statement/Mysqli.php:214

    Stack Trace:
    #0 /xxxx/xenforo/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /xxxx/xenforo/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /xxxx/xenforo/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_opti...', Array)
    #3 /xxxx/xenforo/library/XenForo/DataWriter.php(1516): Zend_Db_Adapter_Abstract->update('xf_option', Array, 'option_id = 'dp...')
    #4 /xxxx/xenforo/library/XenForo/DataWriter.php(1485): XenForo_DataWriter->_update()
    #5 /xxxx/xenforo/library/XenForo/DataWriter.php(1291): XenForo_DataWriter->_save()
    #6 /xxxx/xenforo/library/XenForo/Model/Option.php(473): XenForo_DataWriter->save()
    #7 /xxxx/xenforo/library/DigitalPointAds/Cron.php(64): XenForo_Model_Option->updateOptions(Array)
    #8 [internal function]: DigitalPointAds_Cron::runHourly()
    #9 /xxxx/xenforo/library/XenForo/Model/Cron.php(353): call_user_func(Array)
    #10 /xxxx/xenforo/library/XenForo/Cron.php(29): XenForo_Model_Cron->runEntry(Array)
    #11 /xxxx/xenforo/library/XenForo/Cron.php(64): XenForo_Cron->run()
    #12 /xxxx/xenforo/cron.php(12): XenForo_Cron::runAndOutput()
    #13 {main}

    Request State:
    array(3) {
    ["url"] => string(51) "http://xxxx.com/cron.php?1299034847"
    ["_GET"] => array(1) {
    [1299034847] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }
     
    Solved! View solution.
    SneakyDave, Mar 1, 2011 IP
  2. #2
    The error itself wouldn't "hurt" anything, but it's certainly annoying...

    If you go into library/DigitalPointAds/Cron.php, and change these lines:
    'dpa_keywords' => $result['keywords'],
    'dpa_staticlinks' => $result['static_links']
    PHP:
    to this:
    'dpa_keywords' => (isset($result['keywords']) ? $result['keywords'] : ''),
    'dpa_staticlinks' => (isset($result['static_links']) ? $result['static_links'] : '')
    PHP:
    Does that take care of it? Let me know either way so I can get it pushed out.
     
    digitalpoint, Mar 1, 2011 IP
  3. SneakyDave

    SneakyDave Member

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #3
    Yes, that took care of it, thanks again.
     
    SneakyDave, Mar 2, 2011 IP