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

XF 1.5 Impossible posting and creating new thread

Discussion in 'Troubleshooting and Problems' started by Klaudius, Feb 16, 2016.

  1. Klaudius

    Klaudius Member

    Hi again guys,

    Solved a problem at once happens another :cry:

    After the solution for the cache by @Chris D here https://xenforo.com/community/threads/cache-problem-after-upgrade-1-5-5.112581/, now is impossible to create new thread or new post.

    This is the error

    Code:
    
    Mysqli prepare error: Unknown column 'last_edit_user_id' in 'field list'
    [LIST=1]
    [*]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 Zend/Db/Adapter/Abstract.php at line 574
    [*]Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
    [*]XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
    [*]XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
    [*]XenForo_DataWriter->save() in Dark/TaigaChat/DataWriter/DiscussionMessage/Post.php at line 7
    [*]Dark_TaigaChat_DataWriter_DiscussionMessage_Post->save() in XenForo/ControllerPublic/Thread.php at line 578
    [*]XenForo_ControllerPublic_Thread->actionAddReply() in XenForo/FrontController.php at line 351
    [*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    [*]XenForo_FrontController->run() in /home/wzlryriv/public_html/index.php at line 13
    [/LIST]
    
    XF 1.5.5
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It looks to be related to the chat add-on you have installed.
     
  3. Klaudius

    Klaudius Member

    If I disable taigachat, the error is a bit different

    Mysqli prepare error: Unknown column 'last_edit_user_id' 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 574
    5. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
    6. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
    7. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
    8. XenForo_DataWriter->save() in XenForo/ControllerPublic/Thread.php at line 578
    9. XenForo_ControllerPublic_Thread->actionAddReply() in XenForo/FrontController.php at line 351
    10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    11. XenForo_FrontController->run() in /home/wzlryriv/public_html/index.php at line 13
     
  4. Klaudius

    Klaudius Member

    To be sure I tried to disable all add-on, the error is the same

    Mysqli prepare error: Unknown column 'last_edit_user_id' 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 574
    5. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
    6. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
    7. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
    8. XenForo_DataWriter->save() in XenForo/ControllerPublic/Thread.php at line 578
    9. XenForo_ControllerPublic_Thread->actionAddReply() in XenForo/FrontController.php at line 351
    10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    11. XenForo_FrontController->run() in /home/wzlryriv/public_html/index.php at line 13
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    It could indicate a table missing from the database.
    Run this query in phpMyAdmin and post the full output:
    Code:
    SHOW CREATE TABLE `xf_post`
    Have you recently upgraded XF or removed an add-on?
     
  6. Klaudius

    Klaudius Member

    Yes, XF upgraded yesterday to 1.5.5 (from 1.2 if I remember well)

    However this problem happened after the modify done to solve the cache problem, you can see here https://xenforo.com/community/threads/cache-problem-after-upgrade-1-5-5.112581/

    Do you think can be related?

    This is the log-story-problem :)

    - Upgraded XF to 1.5.5 (from 1.2)
    - Cache problem
    - Solved with Chris D https://xenforo.com/community/threads/cache-problem-after-upgrade-1-5-5.112581/
    - Problem for posting, creating new thread and also rating
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    That field was actually added in 1.2.0 Beta 1 so it should exist if you were already running 1.2.

    Can you run the query and paste the output.
     
  8. Klaudius

    Klaudius Member

    Query result

    Code:
    CREATE TABLE `xf_post` (
     `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
     `thread_id` int(10) unsigned NOT NULL,
     `user_id` int(10) unsigned NOT NULL,
     `username` varchar(50) NOT NULL,
     `post_date` int(10) unsigned NOT NULL,
     `message` mediumtext NOT NULL,
     `ip_id` int(10) unsigned NOT NULL DEFAULT '0',
     `message_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
     `attach_count` smallint(5) unsigned NOT NULL DEFAULT '0',
     `position` int(10) unsigned NOT NULL,
     `likes` int(10) unsigned NOT NULL DEFAULT '0',
     `like_users` blob NOT NULL,
     `warning_id` int(10) unsigned NOT NULL DEFAULT '0',
     `warning_message` varchar(255) NOT NULL DEFAULT '',
     PRIMARY KEY (`post_id`),
     KEY `thread_id_post_date` (`thread_id`,`post_date`),
     KEY `thread_id_position` (`thread_id`,`position`),
     KEY `user_id` (`user_id`),
     KEY `post_date` (`post_date`)
    ) ENGINE=InnoDB AUTO_INCREMENT=96603 DEFAULT CHARSET=utf8
    
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    You have three fields missing from the table, all added by the 1.2.0 Alpha upgrade script.

    Try running this query:
    Code:
    ALTER TABLE xf_post
        ADD last_edit_date INT UNSIGNED NOT NULL DEFAULT 0,
        ADD last_edit_user_id INT UNSIGNED NOT NULL DEFAULT 0,
        ADD edit_count INT UNSIGNED NOT NULL DEFAULT 0
    
     
    Klaudius likes this.
  10. Klaudius

    Klaudius Member

    Works! Thank you Brogan (y)
     
  11. Brogan

    Brogan XenForo Moderator Staff Member

    It's possible other errors may manifest themselves, if any other portions of the upgrade script failed to execute.

    Keep an eye on the server error log for the next day or so.
     
  12. Klaudius

    Klaudius Member

    Hi @Brogan , after 24hrs there is only one error:

    Code:
    Log Server Error
    Info Errore
    ErrorException: Declaration of XenPlus_Dom_Document::loadHTML() should be compatible with DOMDocument::loadHTML($source, $options = NULL) - library/XenPlus/Dom/Document.php:0
    Generato Da: Account Sconosciuto, Oggi alle 01:19
    
    Analisi dello Stack
    #0 /home/wzlryriv/public_html/library/XenForo/Autoloader.php(119): XenForo_Application::handlePhpError(2048, 'Declaration of ...', '/home/wzlryriv/...', 0, Array)
    #1 /home/wzlryriv/public_html/library/XenForo/Autoloader.php(119): XenForo_Autoloader::autoload()
    #2 [internal function]: XenForo_Autoloader->autoload('XenPlus_Dom_Doc...')
    #3 /home/wzlryriv/public_html/library/XenPlus/Dom/Query.php(11): spl_autoload_call('XenPlus_Dom_Doc...')
    #4 /home/wzlryriv/public_html/library/XenPlus/Dom/Query.php(31): XenPlus_Dom_Query->getDom()
    #5 /home/wzlryriv/public_html/library/Zend/Dom/Query.php(231): XenPlus_Dom_Query->queryXpath('//*[contains(co...', '.discussionList...')
    #6 /home/wzlryriv/public_html/library/XenTrader/Listener/TemplatePostRender.php(95): Zend_Dom_Query->query('.discussionList...')
    #7 /home/wzlryriv/public_html/library/XenPlus/Listener/TemplatePostRender.php(13): XenTrader_Listener_TemplatePostRender->_forumView('\n\n\n\n\t\n\n\n\n\n\n\n\n\n\n...', Array)
    #8 /home/wzlryriv/public_html/library/XenPlus/Listener/Abstract.php(21): XenPlus_Listener_TemplatePostRender->execute('forum_view', '\n\n\n\n\t\n\n\n\n\n\n\n\n\n\n...', Array, Object(XenForo_Template_Public), NULL, NULL, NULL, NULL, NULL, NULL)
    #9 [internal function]: XenPlus_Listener_Abstract::listen('forum_view', '\n\n\n\n\t\n\n\n\n\n\n\n\n\n\n...', Array, Object(XenForo_Template_Public))
    #10 /home/wzlryriv/public_html/library/XenForo/CodeEvent.php(58): call_user_func_array(Array, Array)
    #11 /home/wzlryriv/public_html/library/XenForo/Template/Abstract.php(195): XenForo_CodeEvent::fire('template_post_r...', Array, 'forum_view')
    #12 /home/wzlryriv/public_html/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
    #13 /home/wzlryriv/public_html/library/XenForo/ViewRenderer/HtmlPublic.php(123): XenForo_Template_Public->render()
    #14 /home/wzlryriv/public_html/library/XenForo/FrontController.php(637): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
    #15 /home/wzlryriv/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
    #16 /home/wzlryriv/public_html/index.php(13): XenForo_FrontController->run()
    #17 {main}
    
    Stato Richiesta
    array(3) {
      ["url"] => string(59) "http://pesol.it/forums/vendo-compro-scambio.63/?prefix_id=6"
      ["_GET"] => array(1) {
        ["prefix_id"] => string(1) "6"
      }
      ["_POST"] => array(0) {
      }
    }
    
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    Looks like an error related to the xen plus add-on.
     
  14. Klaudius

    Klaudius Member

    XenTrader? I see the last update is Nov 2013... better disabling it I think
     

Share This Page