1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 I need a Red Adair to troubleshoot.... :(

Discussion in 'Installation, Upgrade, and Import Support' started by Shane Greer, Mar 14, 2014.

  1. Shane Greer

    Shane Greer Member

    Ok where do I start....

    I was running X1.25 and went to upgrade last night to v1.30 the usual way.

    I ftp'd the files and ran the install.

    It advised me I had server disabled core .php functions. I pressed on regardless as Im on a shared hosting and there wasnt anything I could do.

    During the install I was getting 504 time outs. By pressing F5 it was able to batter on past them until the very end I get....

    Server Error
    Mysqli prepare error: Unknown column 'display_order' in 'order clause'

    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 XenForo/Model.php at line 219
    5. XenForo_Model->fetchAllKeyed() in XenForo/Model/Smilie.php at line 87
    6. XenForo_Model_Smilie->getAllSmiliesForCache() in XenForo/Model/Smilie.php at line 113
    7. XenForo_Model_Smilie->rebuildSmilieCache() in XenForo/Deferred/ImportMasterData.php at line 40
    8. XenForo_Deferred_ImportMasterData->execute() in XenForo/Deferred/Atomic.php at line 66
    9. XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 256
    10. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
    11. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 316
    12. XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
    13. XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Upgrade.php at line 221
    14. XenForo_Install_Controller_Upgrade->actionRunDeferred() in XenForo/FrontController.php at line 347
    15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    16. XenForo_FrontController->run() in /home/linweb24/t/thefewgoodmen.com-1068658282/user/htdocs/thefgmforum/install/index.php at line 18

    Upon researching this error on Xenforo I find it has to do with a Smiley Manager... so I delete all the files from said Smiley Manager and re-run the install. Same error.

    So at this point I can no longer get into Admin CP to delete the add on so decide to reinstall v1.25 to roll it back and delete it from there.

    I also added the ignore add on code to the config file.

    Now when I rolled back to 1.25 and installed it it throws up this error about data and internal data being writeable. I 777'd the files and sub directories etc and it still throws up the error.

    So I decide to try and install v1.3 again.

    And this is where I have ground to a halt.

    I have no idea what has happened.

    www.thefewgoodmen.com points to this...

    http://www.thefewgoodmen.com/install/index.php?install/

    www.thefewgoodmen.com/home goes to the proper home page.

    Does anyone have any ideas at all about this? Where do I start to unscramble this mess. :(
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    First of all, you should have read this resource, which would have alerted you to the add-on issue: http://xenforo.com/community/resources/how-to-upgrade-to-xenforo-1-3.2810/

    The problem you have now is the /data and /internal_data directories must be chmod 777 recursively.

    When you say you rolled back, how did you do it exactly?
    Have you confirmed you haven't lost any data from those directories?
     
  3. Shane Greer

    Shane Greer Member

    Yeah... it would have made things so much simpler.

    Not sure what this means but I have 777'd them.

    I reinstalled the v1.25 upgrade over the 1.30 install. Like installing v1.3 but in reverse.

    Both directories look pretty much as they should.

    Any idea why my homepage path has changed to that v1.25 error?
     
  4. Shane Greer

    Shane Greer Member

    Ok well disregarding the rest of the problems how do I get 1.3 to install after it throws up this error.

    Server Error
    Mysqli prepare error: Unknown column 'display_order' in 'order clause'

    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 XenForo/Model.php at line 219
    5. XenForo_Model->fetchAllKeyed() in XenForo/Model/Smilie.php at line 87
    6. XenForo_Model_Smilie->getAllSmiliesForCache() in XenForo/Model/Smilie.php at line 113
    7. XenForo_Model_Smilie->rebuildSmilieCache() in XenForo/Deferred/ImportMasterData.php at line 40
    8. XenForo_Deferred_ImportMasterData->execute() in XenForo/Deferred/Atomic.php at line 66
    9. XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 256
    10. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
    11. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 316
    12. XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
    13. XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Upgrade.php at line 221
    14. XenForo_Install_Controller_Upgrade->actionRunDeferred() in XenForo/FrontController.php at line 347
    15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    16. XenForo_FrontController->run() in /home/linweb24/t/thefewgoodmen.com-1068658282/user/htdocs/thefgmforum/install/index.php at line 18

    I really need assistance in laymans terms....
     
  5. Chris D

    Chris D XenForo Developer Staff Member

    Well it's there in laymans terms. Brogan already linked you to the FAQ which tells you where you can get help sorting the Smiley Manager issue.
     
  6. Mike

    Mike XenForo Developer Staff Member

  7. Shane Greer

    Shane Greer Member

    Thanks.... in laymans terms I mean... how do I do this. Apologies guys I really am a beginner. :)


    RUN QUERY

    ALTER TABLE xf_smilie
    DROP smilie_category_id,
    ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0,
    ADD display_order INT UNSIGNED NOT NULL DEFAULT 1,
    ADD display_in_editor TINYINT UNSIGNED NOT NULL DEFAULT 1,
    ADD INDEX display_order (display_order)
     
  8. Mike

    Mike XenForo Developer Staff Member

    You would use a tool like phpMyAdmin to run that query against the database.
     
  9. Shane Greer

    Shane Greer Member

  10. Mike

    Mike XenForo Developer Staff Member

  11. Shane Greer

    Shane Greer Member

  12. Mike

    Mike XenForo Developer Staff Member

    If you uploaded the XF files to the root, that would happen.
     
  13. Shane Greer

    Shane Greer Member

    Hi Mike... I had a check and the xf files arent uploaded to route.

    Its a strange problem...

    My website homepage is built with wordpress.

    Default homepage is www.thefewgoodmen.com

    Now when I go to this page it shows a xenforo v1.25 error (Im using v1.3 however) and the link is...

    www.thefewgoodmen.com/install/index.php?install/

    If I type in http://www.thefewgoodmen.com/home/ it works fine....

    As does http://www.thefewgoodmen.com/thefgmforum/

    How do I fix it so that typing in www.thefewgoodmen.com takes me to the homepage instead of the v1.25 install error page. (Pic below).

    Capture.JPG

    Here is the code for the error page if it is any use.

    Code:
    <!DOCTYPE html>
    <html id="XenForo" class="Install">
    <head>
        <meta charset="utf-8" />
        <title>XenForo 1.2.5 - Errors | XenForo</title>
    
        <link rel="stylesheet" type="text/css" href="install.css" />
    
        <script src="../js/jquery/jquery-1.10.2.min.js"></script>
        <script src="../js/jquery/jquery.xenforo.rollup.js"></script>
        <script src="../js/xenforo/xenforo.js"></script>
    
        <script>
        jQuery.extend(true, XenForo, {
                });
        </script>
    </head>
    <body>
    
    <div id="header">
    
        <div id="logoLine">
            <div class="pageWidth">
                <a href="http://xenforo.com" target="XenForo"><img src="../styles/default/xenforo/XenForo-small.png" id="logo" /></a>
                <h2 id="version"><a href="http://xenforo.com" target="XenForo">XenForo</a> 1.2.5</h2>
            </div>
        </div>
    
        <div id="tabsNav">
            <div class="pad"></div>
        </div>
    
    </div>
    
    <div id="body" class="pageWidth">
      
    <div id="contentContainer">
        <div id="content">
            <div class="titleBar">
                                <h1>XenForo 1.2.5 - Errors</h1>
                        </div>
    
          
        <p class="text">The following errors occurred while verifying that your server can run XenForo:</p>
        <div class="baseHtml">
            <ul>
                        <li>The directory /home/linweb24/t/thefewgoodmen.com-1068658282/user/htdocs/data must be writable. Please change the permissions on this directory to be world writable (chmod 0777). If the directory does not exist, please create it.</li>
                        <li>The directory /home/linweb24/t/thefewgoodmen.com-1068658282/user/htdocs/internal_data must be writable. Please change the permissions on this directory to be world writable (chmod 0777). If the directory does not exist, please create it.</li>
                    </ul>
        </div>
        <p class="text">Please correct these errors and try again.</p>
        </div>
    
        <div id="footer">
            <div id="copyright"><a href="http://xenforo.com" class="concealed" target="XenForo">Forum software by XenForo&trade;</a>, &copy;2013 XenForo Ltd.</div>
        </div>
    </div>
    
    <ol id="sideNav">
        <li><span  class="selected">Welcome</span></li>
        <li><span >Verify Configuration</span></li>
        <li><span >Install</span></li>
        <li><span >Setup Administrator</span></li>
        <li><span >Setup Options</span></li>
        <li><span >Complete</span></li>
    </ol></div>
    
    </body>
    </html>
    Something somewhere is pointing my www.thefewgoodmen.com to the install file and I cant for the life of me find it. Very irritating and completely my own fault somewhere along the way. :)
     
    Last edited: Mar 15, 2014
  14. Mike

    Mike XenForo Developer Staff Member

    It looks like WP is installed in a home/ directory under the root. If the XF files themselves aren't at the root, then something else must be configured to trigger it -- it's redirecting to the install because it can't find a library/config.php file (but the install directory must exist to serve that page).
     

Share This Page