1. REGISTRATION REQUIREMENTS:

    Register with your xenforo.com Username then 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.

Updated from 1.0.0 to 1.2.0

Discussion in 'Showcase Support' started by DRE, Mar 27, 2013.

  1. DRE

    DRE Member Showcase Sportsbook

    I can't access my showcase index. I get this error.

    Server Error

    Mysqli prepare error: Unknown column 'item.review_count' in 'field list'
    1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
    5. Zend_Db_Adapter_Abstract->fetchRow() in NFLJ/Showcase/Model/Item.php at line 568
    6. NFLJ_Showcase_Model_Item->getQuickStatsItemTotals() in NFLJ/Showcase/ControllerPublic/Index.php at line 170
    7. NFLJ_Showcase_ControllerPublic_Index->actionModular() in XenForo/FrontController.php at line 310
    8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    9. XenForo_FrontController->run() in /home/user/public_html/index.php at line 13
     
  2. Bob

    Bob Developer Staff Member

    review_count is a new field that is added to the items table when upgrading to 1.2.0
     
  3. Bob

    Bob Developer Staff Member

    Did you by chance try to upgrade using Chris Deemings auto installer?
     
  4. DRE

    DRE Member Showcase Sportsbook

    I guessed that much but how come I can no longer access my index?

    showcase.jpg
     
  5. Bob

    Bob Developer Staff Member

    because its MISSING, which means that the UPGRADE was fucked up and you will be missing more than just that one field.

    There is a reason I ask questions. The reason I asked about the auto installer is that someone else attempted to upgrade with it and it missed doing the install.php file steps (which are vital to the upgraded).
     
    BamaStangGuy likes this.
  6. DRE

    DRE Member Showcase Sportsbook

    aww man.
     
  7. DRE

    DRE Member Showcase Sportsbook

    Hey I didn't see your question until just now so I wasn't ignoring you. And I did upgrade with it yeah.
     
  8. Bob

    Bob Developer Staff Member

    I can do for you what I did for that other person, but you are going to have to give me full admin access to your site, ftp access and phpMyAdmin access to the DB. Inbox me with the credentials.
     
    DRE likes this.
  9. Bob

    Bob Developer Staff Member

    No worries, its an easy fix (For Me), but it would take me 6 months to teach someone how to do resolve this.
     
  10. DRE

    DRE Member Showcase Sportsbook

    I don't have access to that, chris deeming is hosting me so I'll ask him if he can give it to you thanks
     
  11. Bob

    Bob Developer Staff Member

    I doubt Chris will have a problem with that :D
     
  12. Neal

    Neal Member Showcase

    I removed the auto-installer after this problem :D
     
  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.