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

Shane Greer · Mar 14, 2014

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'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/Smilie.php at line 87
XenForo_Model_Smilie->getAllSmiliesForCache() in XenForo/Model/Smilie.php at line 113
XenForo_Model_Smilie->rebuildSmilieCache() in XenForo/Deferred/ImportMasterData.php at line 40
XenForo_Deferred_ImportMasterData->execute() in XenForo/Deferred/Atomic.php at line 66
XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 256
XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 316
XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Upgrade.php at line 221
XenForo_Install_Controller_Upgrade->actionRunDeferred() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
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.

Paul B · Mar 14, 2014

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?

Shane Greer · Mar 14, 2014

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/

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

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

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

When you say you rolled back, how did you do it exactly?

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

Have you confirmed you haven't lost any data from those directories?

Both directories look pretty much as they should.

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

Shane Greer · Mar 14, 2014

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'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/Smilie.php at line 87
XenForo_Model_Smilie->getAllSmiliesForCache() in XenForo/Model/Smilie.php at line 113
XenForo_Model_Smilie->rebuildSmilieCache() in XenForo/Deferred/ImportMasterData.php at line 40
XenForo_Deferred_ImportMasterData->execute() in XenForo/Deferred/Atomic.php at line 66
XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 256
XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 316
XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Upgrade.php at line 221
XenForo_Install_Controller_Upgrade->actionRunDeferred() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
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....

Chris D · Mar 14, 2014

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.

Mike · Mar 14, 2014

The add-on author has suggested this: http://xenforo.com/community/threads/smiley-manager.63098/page-9#post-709864

Though the ideal would be to restore to a 1.2.5 backup (DB and files) and remove the add-on before upgrading. If you've started the 1.3 upgrade, you can't restore to 1.2.5 unless you revert to a backup.

Shane Greer · Mar 14, 2014

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)

Mike · Mar 14, 2014

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

Shane Greer · Mar 14, 2014

Thankyou ... I have my forum back... however the last outstanding problem is this....

www.thefewgoodmen.com

seems to be pointing to this....

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

However if I pop in www.thefewgoodmen.com/home it works fine.

Mike · Mar 14, 2014

According to the link on your site, your forum is actually http://www.thefewgoodmen.com/thefgmforum/

So whatever is at the root is not part of that forum. Did you upload XF files to the root perhaps?

Shane Greer · Mar 14, 2014

Ah yes... my homepage is wordpress.

So I wonder why going to www.thefewgoodmen.com

sends me...

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

here?

Mike · Mar 14, 2014

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

Shane Greer · Mar 15, 2014

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).

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.

Mike · Mar 15, 2014

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).

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

Shane Greer

Active member

Paul B

XenForo moderator

Shane Greer

Active member

Shane Greer

Active member

Chris D

XenForo developer

Mike

XenForo developer

Shane Greer

Active member

Mike

XenForo developer

Shane Greer

Active member

Mike

XenForo developer

Shane Greer

Active member

Mike

XenForo developer

Shane Greer

Active member

Mike

XenForo developer

Similar threads

We value your privacy