XF 1.5 Upgrade to 1.5.1 failed (but it hasn't?)

[Alexander Firth]

The upgrade from 1.4.4 failed and gave me an error message, saying I'd need to restore a backup etc. It cited 3 tables which I failed to log down (because I am an idiot). However, my site seems to be running 1.5.1 perfectly fine?

https://youthdebates.org/forums

XenWord no longer works - perhaps that was the culprit?

Should I be worried about anything?

 

[Paul B]

The tables it would have listed would be core tables, so it's possible one or more queries have failed.

Which version did you upgrade from?

 

[Alexander Firth]

The tables it would have listed would be core tables, so it's possible one or more queries have failed.

Which version did you upgrade from?

1.4.4.

 

[Alexander Firth]

The tables it would have listed would be core tables, so it's possible one or more queries have failed.

Which version did you upgrade from?

Error on profile posts:

Mysqli prepare error: Unknown column 'profile_post_comment.message_state' in 'where clause'

 

[Paul B]

See the bottom of this post for how to resolve that: https://xenforo.com/community/threads/xenforo-1-5-discussion-and-feedback.101111/

 

[Alexander Firth]

See the bottom of this post for how to resolve that: https://xenforo.com/community/threads/xenforo-1-5-discussion-and-feedback.101111/

Thanks, will backup database and give that a go.

 

[Alexander Firth]

See the bottom of this post for how to resolve that: https://xenforo.com/community/threads/xenforo-1-5-discussion-and-feedback.101111/

I successfully performed those queries but I still get the following error when I want to do anything relating to profile posts:

Server Error

Mysqli prepare error: Unknown column 'profile_post_comment.message_state' in 'where 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/ProfilePost.php at line 1100
XenForo_Model_ProfilePost->getProfilePostComments() in XenForo/Model/ProfilePost.php at line 1329
XenForo_Model_ProfilePost->addProfilePostCommentsToProfilePosts() in XenForo/ControllerPublic/FindNew.php at line 298
XenForo_ControllerPublic_FindNew->actionProfilePosts() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/youthdebates/public_html/forums/index.php at line 13

 

[Alexander Firth]

Never mind! I found an extra query that fixed it. Thanks for your help

 

[Alexander Firth]

@Brogan

Just came across one last stray error. Perhaps you can help?

It occurs when trying to comment on a profile post:

Mysqli prepare error: Unknown column 'likes' in 'field list'
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 1624
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
XenForo_DataWriter->save() in XenForo/ControllerPublic/ProfilePost.php at line 519
XenForo_ControllerPublic_ProfilePost->actionComment() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/youthdebates/public_html/forums/index.php at line 13

I can't find a query to run for this one, but it seems to be the only error remaining now, so if you can fix it I'll love you forever.

 

[Mike]

Are you sure you ran all of the queries here? https://xenforo.com/community/threads/unable-to-like-profile-post-comments.102220/#post-963671 (If so, did you run them and then uninstall the offending add-on? That may have re-removed the columns.)