XF 1.5 Impossible posting and creating new thread

[Klaudius]

Hi again guys,

Solved a problem at once happens another

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

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

 

[Paul B]

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

 

[Klaudius]

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

 

[Klaudius]

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

 

[Paul B]

It could indicate a table missing from the database.
Run this query in phpMyAdmin and post the full output:

SHOW CREATE TABLE `xf_post`

Have you recently upgraded XF or removed an add-on?

 

[Klaudius]

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

 

[Paul B]

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.

 

[Klaudius]

Query result

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

 

[Paul B]

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

Try running this query:

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]

Works! Thank you Brogan

 

[Paul B]

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.

 

[Klaudius]

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

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) {
  }
}

 

[Paul B]

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

 

[Klaudius]

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