Duplicate Status Update Deletion Error

[MistaMike]

I was permanently deleting a test status update on my website and got the following error:

Server Error

Mysqli prepare error: Unknown column 'position' in 'where 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 XenForo/DataWriter/DiscussionMessage.php at line 933
   5. XenForo_DataWriter_DiscussionMessage->_adjustPositionListForRemoval() in XenForo/DataWriter/DiscussionMessage.php at line 698
   6. XenForo_DataWriter_DiscussionMessage->_postDelete() in XenForo/DataWriter.php at line 1645
   7. XenForo_DataWriter->delete() in XenForo/ControllerPublic/ProfilePost.php at line 142
   8. XenForo_ControllerPublic_ProfilePost->actionDelete() in XenForo/FrontController.php at line 310
   9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  10. XenForo_FrontController->run() in /home/adminsl/domains/carbinecentral.com/public_html/index.php at line 15

 

[Paul B]

Are you running RC1 or Beta 6?

This was fixed in RC1: http://xenforo.com/community/threads/fixed-delete-a-message-in-user-profile.10469/

 

[MistaMike]

Hey Brogan, I'm running Beta 6 and it seems like the error is only appearing when I'm deleting older status updates, which would of been around the time of RC1.

 

[Vincent]

Hey Brogan, I'm running Beta 6 and it seems like the error is only appearing when I'm deleting older status updates, which would of been around the time of RC1.

RC1 is newer than Beta 6

 

[Mike]

You need to upgrade, that's a known bug in beta 6.

 

[MistaMike]

RC1 is newer than Beta 6

Lmao! See kids... this is what a lack of sleep does to you.