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

XF 1.5 Issues after upgrading

Discussion in 'Installation, Upgrade, and Import Support' started by leslie dow, Dec 10, 2015.

  1. leslie dow

    leslie dow Active Member

    Hi all
    I upgraded to 1.5.3 yesterday (from 1.5.2) and all seemed fine. Ran a few tests, board seemed okay, then had an odd problem. I did also upgrade one addon ( after the 1.5.3, but again then all seemed to check out.) and these problems are happening nearly 12 hours after the upgrade and after multiple posts have been made. The addon I upgraded is PostRating by @Luke F . Any help in figuring this out will be greatly appreciated.

    Now nearly 12 hours after the latest change I am getting this error from the logs (I can access the admin panel) and when I try to access the site I get the following:
    An unexpected error occurred. Please try again later.

    Viewing source of that error I see this:
    <body xmlns="http://www.w3.org/1999/xhtml" data-pinterest-extension-installed="cr1.39.1">An unexpected error occurred. Please try again later.</body>

    Here is the error from the Admin panel.

    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum.node_id' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, 43 minutes ago
    Stack Trace
    #0 /home/savvyauthors/public_html/Community/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tSELECT thr...')
    #1 /home/savvyauthors/public_html/Community/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tSELECT thr...')
    #2 /home/savvyauthors/public_html/Community/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tSELECT thr...')
    #3 /home/savvyauthors/public_html/Community/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT thr...', Array, 2)
    #4 /home/savvyauthors/public_html/Community/library/XenForo/Model/Thread.php(563): XenForo_Model->fetchAllKeyed('\n\t\t\t\tSELECT thr...', 'thread_id')
    #5 /home/savvyauthors/public_html/Community/library/XenForo/ControllerPublic/Forum.php(104): XenForo_Model_Thread->getThreads(Array, Array)
    #6 /home/savvyauthors/public_html/Community/library/Waindigo/CustomFields/Extend/XenForo/ControllerPublic/Forum.php(16): XenForo_ControllerPublic_Forum->actionIndex()
    #7 /home/savvyauthors/public_html/Community/library/WidgetFramework/XenForo/ControllerPublic/Forum.php(13): Waindigo_CustomFields_Extend_XenForo_ControllerPublic_Forum->actionIndex()
    #8 /home/savvyauthors/public_html/Community/library/XenForo/FrontController.php(351): WidgetFramework_XenForo_ControllerPublic_Forum->actionIndex()
    #9 /home/savvyauthors/public_html/Community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /home/savvyauthors/public_html/Community/index.php(13): XenForo_FrontController->run()
    #11 {main}
    Request State
    array(3) {
    ["url"] => string(51) "http://savvyauthors.com/Community/index.php?forums/"
    ["_GET"] => array(1) {
    ["forums/"] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }

    Delete...Close
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    If you disable the widget framework & Waindigo's Custom Fields add-on, are you able to access your site? Have you unisntalled or installed any add-ons lately?
     
  3. leslie dow

    leslie dow Active Member

    Just upgraded the PostRatings, like I mentioned above. i will disable those other ones and check.
    thanks
     
  4. leslie dow

    leslie dow Active Member

    Hmm.. might be the custom fields, I get the following when I try to disable it:
    The following error occurred:
    An exception occurred: Mysqli prepare error: Unknown column 'forum.node_id' in 'on clause' in /home/savvyauthors/public_html/Community/library/Zend/Db/Statement/Mysqli.php on line 77

    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/Forum.php at line 106
    6. XenForo_Model_Forum->getForums() in XenForo/Deferred/Forum.php at line 21
    7. XenForo_Deferred_Forum->execute() in XenForo/Model/Deferred.php at line 295
    8. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
    9. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 374
    10. XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
    11. XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() inXenForo/ViewRenderer/Json.php at line 147
    12. XenForo_ViewRenderer_Json::_addDefaultParams() in XenForo/ViewRenderer/Json.php at line 185
    13. XenForo_ViewRenderer_Json::jsonEncodeForOutput() in XenForo/ViewRenderer/Json.phpat line 37
    14. XenForo_ViewRenderer_Json->renderRedirect() in XenForo/FrontController.php at line 616
    15. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    16. XenForo_FrontController->run() in /home/savvyauthors/public_html/Community/admin.phpat line 13
     
  5. leslie dow

    leslie dow Active Member

    And I still cannot access the site with it disabled. Is this the issue do I need to uninstall this?
    thanks
     
  6. Jeremy

    Jeremy XenForo Moderator Staff Member

    That stack trace does not include any add-ons, so it may be a database issue.

    What does the query "SHOW CREATE TABLE xf_forum" return?
     
  7. leslie dow

    leslie dow Active Member

    SQL result
    Host: localhost3306
    Database: savvyaut_XF_r
    Generation Time: Dec 10, 2015 at 06:25 AM
    Generated by: phpMyAdmin 4.0.10.7 / MySQL 5.6.27
    SQL query: SHOW CREATE TABLE xf_forum;
    Rows: 1


    Table Create Table
    xf_forum CREATE TABLE `xf_forum` (
    `discussion_count` int(10) unsigned NOT NULL DEFAULT '0',
    `message_count` int(10) unsigned NOT NULL DEFAULT '0',
    `last_post_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent post_id',
    `last_post_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of most recent post',
    `last_post_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User_id of user posting most recently',
    `last_post_username` varchar(50) NOT NULL DEFAULT '' COMMENT 'Username of most recently-posting user',
    `last_thread_title` varchar(150) NOT NULL DEFAULT '' COMMENT 'Title of thread most recent post is in',
    `moderate_replies` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allow_posting` tinyint(3) unsigned NOT NULL DEFAULT '1',
    `count_messages` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'If not set, messages posted (directly) within this forum will not contribute to user message totals.',
    `find_new` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Include posts from this forum when running /find-new/threads',
    `prefix_cache` mediumblob NOT NULL COMMENT 'Serialized data from xf_forum_prefix, [group_id][prefix_id] => prefix_id',
    `default_prefix_id` int(10) unsigned NOT NULL DEFAULT '0',
    `default_sort_order` varchar(25) NOT NULL DEFAULT 'last_post_date',
    `default_sort_direction` varchar(5) NOT NULL DEFAULT 'desc',
    `require_prefix` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allowed_watch_notifications` varchar(10) NOT NULL DEFAULT 'all',
    `bdimage_last_post_image` text,
    `moderate_threads` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allow_poll` tinyint(3) unsigned NOT NULL DEFAULT '1',
    `list_date_limit_days` smallint(5) unsigned NOT NULL DEFAULT '0',
    `field_cache` mediumblob,
    `custom_fields` mediumblob,
    `required_fields` mediumblob,
    `social_forum_field_cache` mediumblob,
    `custom_social_forum_fields` mediumblob,
    `required_social_forum_fields` mediumblob,
    `member_permissions` text,
    `moderator_permissions` text,
    `creator_permissions` text,
    `min_tags` smallint(5) unsigned NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
     
  8. Mike

    Mike XenForo Developer Staff Member

    Was there a database restore done or anything like that? You're missing a core field in that table -- not one that would ever be touched by XF. I couldn't really begin to guess why or how it has been removed.

    Unfortunately, I would have to recommend restoration of a backup that doesn't have this issue to get it back.
     
  9. leslie dow

    leslie dow Active Member

    Thanks Mike
    Something did happen last night but it was to a Wordpress blog. I didnt think the two were related, but I suspect so. I'll get the database restored.

    Leslie
     
  10. leslie dow

    leslie dow Active Member

    Ok this is just getting weirder. Now my ISP is telling me that the past couple of backups are corrupted. Apparently (and we are now way beyond my understanding technically) there are issues with InnoDB? Does this make sense to you guys?

    Oh and the site was fully functional until 3am today. So these corrupted backups were before anything was amiss and also before I upgraded.

    Thanks,
    Leslie


    "As stated, we tried restoring the database from the most recent backup at 12 A.M.12/10/15. We are attempting to manually restore the database by obtaining the data directory, all necessary files from the backup, and restoring on a local MySQL instance. After doing so, it appears there is an issue with all tables using InnoDB, as MyISAM tables are showing up fine. Reference link below to screenshot:

    http://hostek.tk/i/1d568409a112a3195031

    We've already tried the same with the backup from the 9th. If you would like us to attempt to go further back let us know.
    "
     
    Last edited: Dec 10, 2015
  11. Brogan

    Brogan XenForo Moderator Staff Member

    If the backups have been taken correctly, there's no reason why they can't be restored.

    It sounds though as if the process your host is using is flawed, to result in corrupt/unusable backups.

    Unfortunately, without a viable backup/database, there's not really much you can do.
     
  12. leslie dow

    leslie dow Active Member

    Yes, I agree. And am obviously kicking myself for relying on the host's backups. Never do that again...what a great cautionary tale, eh?

    If anyone can think of something, please let me know.
    Leslie
     
  13. wang

    wang Well-Known Member

    I have learnt that the hard way too, in my beginnings as a webmaster. If you do not have a backup yourself and your host 's backups are corrupted, then there is not much that you can do I am afraid. Can you ask your host to check their backups and see if they find a good one? Then they can restore that. You might loose some data, but there is nothing that can be done about that Ma`am.
     
  14. leslie dow

    leslie dow Active Member

    thanks for the comments. Yes, the host is looking for a good backup. The issue is the the backup system they use does not play well with InnoDB. So the really scary thing is this would have been a problem in any situation where I needed a restore, and the more I poke into this the more certain I am that its not due to the upgrade but some other tampering. Always frustrating. That said, if anyone knows any solutions for restoring InnoDB tables let me know.

    What they are telling me now is that its not at all related to the upgrade, but related to their backup system. They ahve someone coming in who has experience and they think he can do the restore.

    Yeah, assuming I get out of this mess I am looking for a new ISP and likely a third party backup service to boot.
     
  15. wang

    wang Well-Known Member

    To me it looks like your host has messed up really bad. Any professional host should not cause these kind of problems. What is your host 's name if one can ask? What exactly is not playing well with their backups and InnoDB according to your host? This is a very vague explanation, or better said, excuse.
     
  16. leslie dow

    leslie dow Active Member

    Hostek managed to get a backup restored and I'm now checking things out. I've asked for technical details on what happened and will post them here. Part of the issue seems to be that my VPS is Linux and they were trying to restore on a Windows machine.

    Just to be clear, this was an issue of their backup system and had nothing to do with the 1.5.3 upgrade (which I have now reapplied and went just fine). That said, had I followed my own processes and not relied on theirs for normal backups, I would have been able to recover far more quickly since I had recently upgraded to 1.5.3. So the take home for me, is to not rely on the hosting service backup (sad, that).

    Its really frustrating because one of the things I think we should be able to rely on from a hosting service is effing backups (and quick and reliable restoration of those backups).
     
  17. leslie dow

    leslie dow Active Member

    OK. This has happened again. A new database, a presumably successful upgrade to 1.5.3, no other changes.
    Most recently, I was able to do the upgrade and then saved the upgraded database. And it worked for about an hour and then more columns were dropped.
    According to my ISP, there is nothing that has happened on the server side, they insist it has to be the application.

    Thanks for any help.

    I am getting the same error message in the server error logs:
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum.node_id' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, 48 minutes ago

    Stack Trace
    #0 /home/savvyauthors/public_html/Community/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tSELECT thr...')
    #1 /home/savvyauthors/public_html/Community/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tSELECT thr...')
    #2 /home/savvyauthors/public_html/Community/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tSELECT thr...')
    #3 /home/savvyauthors/public_html/Community/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT thr...', Array, 2)
    #4 /home/savvyauthors/public_html/Community/library/XenForo/Model/Thread.php(563): XenForo_Model->fetchAllKeyed('\n\t\t\t\tSELECT thr...', 'thread_id')
    #5 /home/savvyauthors/public_html/Community/library/XenForo/ControllerPublic/Forum.php(104): XenForo_Model_Thread->getThreads(Array, Array)
    #6 /home/savvyauthors/public_html/Community/library/Waindigo/CustomFields/Extend/XenForo/ControllerPublic/Forum.php(16): XenForo_ControllerPublic_Forum->actionIndex()
    #7 /home/savvyauthors/public_html/Community/library/WidgetFramework/XenForo/ControllerPublic/Forum.php(13): Waindigo_CustomFields_Extend_XenForo_ControllerPublic_Forum->actionIndex()
    #8 /home/savvyauthors/public_html/Community/library/XenForo/FrontController.php(351): WidgetFramework_XenForo_ControllerPublic_Forum->actionIndex()
    #9 /home/savvyauthors/public_html/Community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /home/savvyauthors/public_html/Community/index.php(13): XenForo_FrontController->run()
    #11 {main}
    Request State
    array(3) {
    ["url"] => string(51) "http://savvyauthors.com/Community/index.php?forums/"
    ["_GET"] => array(1) {
    ["forums/"] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }

    and when I browse to the forums I see this error in the Forum Pane:

    Server Error
    Mysqli prepare error: Unknown column 'forum.node_id' in 'on 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 Zend/Db/Adapter/Abstract.php at line 753
    5. Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/Forum.php at line 29
    6. XenForo_Model_Forum->getForumById() in XenForo/ControllerHelper/ForumThreadPost.php at line 179
    7. XenForo_ControllerHelper_ForumThreadPost->getForumOrError() in XenForo/ControllerHelper/ForumThreadPost.php at line 38
    8. XenForo_ControllerHelper_ForumThreadPost->assertForumValidAndViewable() in XenForo/ControllerPublic/Forum.php at line 181
    9. XenForo_ControllerPublic_Forum->actionForum() in Waindigo/CustomFields/Extend/XenForo/ControllerPublic/Forum.php at line 29
    10. Waindigo_CustomFields_Extend_XenForo_ControllerPublic_Forum->actionForum() in LiquidPro/SimpleForms/Listener/Proxy/ControllerForum.php at line 7
    11. LiquidPro_SimpleForms_Listener_Proxy_ControllerForum->actionForum() in Andy/ForumModerators/ControllerPublic/Forum.php at line 13
    12. Andy_ForumModerators_ControllerPublic_Forum->actionForum() in XenForo/FrontController.php at line 351
    13. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    14. XenForo_FrontController->run() in /home/savvyauthors/public_html/Community/index.php at line 13

    When I run the SQL: "SHOW CREATE TABLE xf_forum"
    I get this:
    SQL result
    Host: localhost3306
    Database: savvyaut_XF2015
    Generation Time: Dec 11, 2015 at 11:12 AM
    Generated by: phpMyAdmin 4.0.10.7 / MySQL 5.6.27
    SQL query: SHOW CREATE TABLE xf_forum;
    Rows: 1


    Table Create Table
    xf_forum CREATE TABLE `xf_forum` (
    `discussion_count` int(10) unsigned NOT NULL DEFAULT '0',
    `message_count` int(10) unsigned NOT NULL DEFAULT '0',
    `last_post_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent post_id',
    `last_post_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of most recent post',
    `last_post_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User_id of user posting most recently',
    `last_post_username` varchar(50) NOT NULL DEFAULT '' COMMENT 'Username of most recently-posting user',
    `last_thread_title` varchar(150) NOT NULL DEFAULT '' COMMENT 'Title of thread most recent post is in',
    `moderate_replies` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allow_posting` tinyint(3) unsigned NOT NULL DEFAULT '1',
    `count_messages` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'If not set, messages posted (directly) within this forum will not contribute to user message totals.',
    `find_new` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Include posts from this forum when running /find-new/threads',
    `prefix_cache` mediumblob NOT NULL COMMENT 'Serialized data from xf_forum_prefix, [group_id][prefix_id] => prefix_id',
    `default_prefix_id` int(10) unsigned NOT NULL DEFAULT '0',
    `default_sort_order` varchar(25) NOT NULL DEFAULT 'last_post_date',
    `default_sort_direction` varchar(5) NOT NULL DEFAULT 'desc',
    `require_prefix` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allowed_watch_notifications` varchar(10) NOT NULL DEFAULT 'all',
    `bdimage_last_post_image` text,
    `moderate_threads` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allow_poll` tinyint(3) unsigned NOT NULL DEFAULT '1',
    `list_date_limit_days` smallint(5) unsigned NOT NULL DEFAULT '0',
    `field_cache` mediumblob,
    `custom_fields` mediumblob,
    `required_fields` mediumblob,
    `social_forum_field_cache` mediumblob,
    `custom_social_forum_fields` mediumblob,
    `required_social_forum_fields` mediumblob,
    `member_permissions` text,
    `moderator_permissions` text,
    `creator_permissions` text,
    `tabs_position_threads` varchar(20) NOT NULL DEFAULT '',
    `min_tags` smallint(5) unsigned NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
     
  18. Brogan

    Brogan XenForo Moderator Staff Member

    If you are sure the column was there after the restore then I would suspect an add-on is involved.

    There is nothing in the core software which would cause a column to be dropped like that.
     
  19. leslie dow

    leslie dow Active Member

    I know that the application ran for some period of time and yes that column was there. I guess I can restore again and disable all the addons and see if that works, right?
    thanks
     
  20. leslie dow

    leslie dow Active Member

    All
    After a few days of this problem recurring, I now have a installation with 1.5.2 (before I tried to upgrade to 1.5.3 or upgrade postratings addon). My hosting provider was able to restore both a database and files that correspond to the software running a full 12 hours before any changes were made.

    I am still getting the same column dropping and the same errors after the site is up for about 4-6 hours. Please note that this did not happen at all until after I upgraded 1.5.2 to 1.5.3, and upgraded a single addon: postratings.

    The only other thing I can think of is that before I started to upgrade I set up a test or staging site. It did not use the same database, but I'm beginning to wonder if something in that test site is triggering or causing something that results in these database table drops.

    To test this I am deleting the test site and removing the db that was used for that site.

    I am literally at my wits end here. Nothing seems to make any sense.
    Suggestions?

    Thanks
     

Share This Page