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

XF 1.3 Errors after 1.3.2 upgrade

Discussion in 'Installation, Upgrade, and Import Support' started by Temexter, Jun 18, 2014.

  1. Temexter

    Temexter Member

    After very succesful upgrade to 1.3.2 from 1.2.1, couple of errors appeared in sever error log:
    Code:
    Server Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum.find_new' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, 3 minutes ago
    Stack Trace
    #0 /var/www/prteamwork.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT thr...')
    #1 /var/www/prteamwork.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT thr...')
    #2 /var/www/prteamwork.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT thr...')
    #3 /var/www/prteamwork.com/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', Array, 2)
    #4 /var/www/prteamwork.com/library/XenForo/Model/Thread.php(527): XenForo_Model->fetchAllKeyed('?????SELECT thr...', 'thread_id')
    #5 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(163): XenForo_Model_Thread->getThreads(Array, Array)
    #6 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(35): XenForo_ControllerPublic_FindNew->findNewPosts()
    #7 /var/www/prteamwork.com/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_FindNew->actionPosts()
    #8 /var/www/prteamwork.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/prteamwork.com/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(50) "http://prteamwork.com/find-new/129580/posts?page=2"
    ["_GET"] => array(2) {
    ["/find-new/129580/posts"] => string(0) ""
    ["page"] => string(1) "2"
    }
    ["_POST"] => array(0) {
    }
    }
    Code:
    Server Error Log
    Error Info
    ErrorException: Undefined index: node_name - library/XenForo/ControllerPublic/FindNew.php:77
    Generated By: Unknown Account, 12 minutes ago
    Stack Trace
    #0 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(77): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/prteam...', 77, Array)
    #1 /var/www/prteamwork.com/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_FindNew->actionPosts()
    #2 /var/www/prteamwork.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #3 /var/www/prteamwork.com/index.php(13): XenForo_FrontController->run()
    #4 {main}
    Request State
    array(3) {
    ["url"] => string(47) "http://www.prteamwork.com/find-new/233119/posts"
    ["_GET"] => array(1) {
    ["/find-new/233119/posts"] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }
    Any idea of reason for these or way to fix?

    Cheers,

    Temexter
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Which add-ons do you have installed or have had installed in the past?

    You appear to be missing at least one column from a table.
     
  3. Temexter

    Temexter Member

    Installed Add-ons
    1. AVForums Moderator Checkpoint System 1.0.3
    2. Bb Codes & Buttons Manager 2.8.0
    3. Bb Codes & Buttons Manager - Advanced Bb Codes 3.6.1
    4. BBM - Button Bb Code 1.2
    5. Cliptheapex.com's Countdown Timer 1.7.5.00_EQnoble
    6. Custom Fields by Waindigo 2.0.6
    7. Digital Point Syntax Highlighter 1.3.0
    8. Display Staff Members 1.1.2
    9. Donation Manager 1.2.0
    10. Double Post Merge 1.0.9
    11. Downloads Manager 1.0.2
    12. Install and Upgrade by Waindigo 1.1.4
    13. LiquidPro Simple Forms 2.1.3
    14. Nodes As Tabs 1.2.2
    15. Roster 1.0.0
    16. Separate Sticky and Normal Threads 1.0
    17. Show XenForo Version 1.0.0
    18. Steam Auth 1.4.4
    19. TaigaChat Pro 1.2.0
    20. Tapatalk 2.1.0
    21. Teamspeak 1.3.8 Alpha
    22. Template Modification System 1.3.0
    23. XF QapTcha 1.1
    24. [8wayRun.Com] XenPorta (Portal) 1.6.0
    25. [bd] Medal 1.4.5b
    26. [bd] Medal - Trophy Extension 0.9.2
    27. [RT] Online Status Ribbon 1.3.7
    The 0nes with strike-through are disabled.

    All add-ons are most recent versions, except TaigaChat Pro 1.2.0...

    Both errors started after 1.3.2 upgrade.

    Add-ons installed after upgrade:
    Show XenForo Version 1.0.0
    LiquidPro Simple Forms 2.1.3 (version for XF 1.3)
    Custom Fields by Waindigo to version 2.0.6. (upgrade)
    Install and Upgrade by Waindigo 1.1.4 (upgrade)


    I disabled those for a while and errors kept coming in :/

     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Do you know how to use phpMyAdmin?

    Can you run this query?
    Code:
    show create table xf_forum;
    Then select full texts and post the output here in a code box.
     
  5. Temexter

    Temexter Member

    Here you are:
    Code:
    xf_forum CREATE TABLE `xf_forum` (
    `node_id` int(10) unsigned NOT NULL,
    `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_messages` 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',
    `require_prefix` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allowed_watch_notifications` varchar(10) NOT NULL DEFAULT 'all',
    `default_sort_order` varchar(25) NOT NULL DEFAULT 'last_post_date',
    `default_sort_direction` varchar(5) NOT NULL DEFAULT 'desc',
    `field_cache` mediumblob COMMENT 'Serialized data from xf_forum_field, [group_id][field_id] => field_id',
    `custom_fields` mediumblob,
    `required_fields` mediumblob,
    `post_field_cache` mediumblob COMMENT 'Serialized data from xf_forum_post_field, [group_id][field_id] => field_id',
    `custom_post_fields` mediumblob,
    `required_post_fields` mediumblob,
    `social_forum_field_cache` mediumblob COMMENT 'Serialized data from xf_social_forum_field, [group_id][field_id] => field_id',
    `custom_social_forum_fields` mediumblob,
    `required_social_forum_fields` mediumblob,
    `bbm_bm_editor` varchar(25) NOT NULL DEFAULT 'disable',
    PRIMARY KEY (`node_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Can you disable all listeners by adding this to your config.php file?

    PHP:
    $config['enableListeners'] = false;
    Then perform the same action to try and trigger the error again, presumably by clicking on New Posts.
     
  7. Temexter

    Temexter Member

    After disabling listeners, no errors, i hit "New posts" with two user accounts and created new posts, waited a while, like 5 minutes...
    when i changed it back, both errors instantly came back.
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    In which case the problem is due to an add-on.

    Disable them all and re-enable one at a time to determine which one.

    Then contact the developer.
     
  9. Temexter

    Temexter Member

    Okay. Thanks for your help :)
     

Share This Page