Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Not a Bug Unknown column 'item_view_count' in 'field list'

Discussion in 'Showcase Resolved Bug Reports' started by alfa1, Jun 14, 2015.

  1. alfa1

    alfa1 Active Member CAS Premium EMS Early Adopter IMS Premium LD Premium AMS Premium RMS Premium SC Premium UBS Premium

    I found this error in the log:

    Server Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'item_view_count' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, Apr 19, 2015
    Stack Trace
    #0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tUPDATE xf_...')
    #1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tUPDATE xf_...')
    #2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tUPDATE xf_...')
    #3 /library/NFLJ/Showcase/Model/Item.php(1587): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tUPDATE xf_...', Array)
    #4 /library/NFLJ/Showcase/CronEntry/Views.php(13): NFLJ_Showcase_Model_Item->updateItemViews()
    #5 [internal function]: NFLJ_Showcase_CronEntry_Views::runViewUpdate(Array)
    #6 /library/XenForo/Model/Cron.php(357): call_user_func(Array, Array)
    #7 /library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
    #8 /library/XenForo/Model/Deferred.php(294): XenForo_Deferred_Cron->execute(Array, Array, 7.9636859893799, '')
    #9 /library/XenForo/Model/Deferred.php(428): XenForo_Model_Deferred->runDeferred(Array, 7.9636859893799, '', false)
    #10 /library/XenForo/Model/Deferred.php(373): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
    #11 /deferred.php(23): XenForo_Model_Deferred->run(false)
    #12 {main}
    Request State
    array(3) {
    ["url"] => string(41) "https://.../deferred.php"
    ["_GET"] => array(0) {
    ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(34) "/admin.php?add-ons/install-upgrade"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"

    EDIT: please disregard. I see this is an old error report.
  2. Bob

    Bob Developer Staff Member

    Just delete it. When upgrading addons, its BEST to disable them prior to upgrading to prevent things like CRON and DEFERED from running when there are significant changes between addon versions (like adding new option settings to give more functionality to existing functionality). This (and many more like it) are simply unavoidable.
    alfa1 likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.