Conversation Essentials

Conversation Essentials [Paid] 1.14.1

No permission to buy ($45.00)
  • Thread starter Thread starter Syndol
  • Start date Start date
Overview FAQ Updates (79) Reviews (47) History Discussion
The server is stuck wanting to finish the rebuild manually, but for some reason is unable to continue. I'm getting these errors when trying to view PC's.

Code: 
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'convess.filtered' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: The Sandman, 5 minutes ago
Stack Trace
#0 /srv/www/theadminzone.com/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\t\t\tSELECT c...')
#1 /srv/www/theadminzone.com/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\t\t\tSELECT c...')
#2 /srv/www/theadminzone.com/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\t\t\tSELECT c...')
#3 /srv/www/theadminzone.com/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\r\n\t\t\t\t\tSELECT c...', 3, 2)
#4 /srv/www/theadminzone.com/public_html/library/ConvEss/Model/Conversation.php(2229): XenForo_Model->fetchAllKeyed('\r\n\t\t\t\t\tSELECT c...', 'conversation_id', 3)
#5 /srv/www/theadminzone.com/public_html/library/XenForo/ControllerPublic/Conversation.php(155): ConvEss_Model_Conversation->getConversationsForUser(3, Array, Array)
#6 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Conversation->actionPopup()
#7 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /srv/www/theadminzone.com/public_html/index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
  ["url"] => string(167) "https://theadminzone.com/conversations/popup?&_xfRequestUri=%2F&_xfNoRedirect=1&_xfToken=3%2C1422612346%2C978b696b40d0cf908a02a447b6ab3e3172b294f5&_xfResponseType=json"
  ["_GET"] => array(5) {
    ["/conversations/popup"] => string(0) ""
    ["_xfRequestUri"] => string(1) "/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(53) "3,1422612346,978b696b40d0cf908a02a447b6ab3e3172b294f5"
    ["_xfResponseType"] => string(4) "json"
  }
  ["_POST"] => array(0) {
  }
}

Code: 
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'filtered' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: The Sandman, 5 minutes ago
Stack Trace
#0 /srv/www/theadminzone.com/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tSELECT *\r\n...')
#1 /srv/www/theadminzone.com/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tSELECT *\r\n...')
#2 /srv/www/theadminzone.com/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tSELECT *\r\n...')
#3 /srv/www/theadminzone.com/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tSELECT *\r\n...', Array, 2)
#4 /srv/www/theadminzone.com/public_html/library/ConvEss/Model/Conversation.php(648): XenForo_Model->fetchAllKeyed('\r\n\t\t\tSELECT *\r\n...', 'conversation_id', Array)
#5 /srv/www/theadminzone.com/public_html/library/ConvEss/Model/Conversation.php(2464): ConvEss_Model_Conversation->getConvessByUserIdFilterState(184, 1)
#6 /srv/www/theadminzone.com/public_html/library/ConvEss/Model/Permission.php(37): ConvEss_Model_Conversation->deleteAllFiltersByUserId(184)
#7 /srv/www/theadminzone.com/public_html/library/XenForo/Model/Permission.php(1504): ConvEss_Model_Permission->rebuildPermissionCombination(Array, Array, Array)
#8 /srv/www/theadminzone.com/public_html/library/WidgetFramework/XenForo/Model/Permission.php(14): XenForo_Model_Permission->rebuildPermissionCache(7.9999358654022, 508)
#9 /srv/www/theadminzone.com/public_html/library/XenForo/Deferred/Permission.php(19): WidgetFramework_XenForo_Model_Permission->rebuildPermissionCache(7.9999358654022, 508)
#10 /srv/www/theadminzone.com/public_html/library/Bookmarks/Deferred/Permission.php(7): XenForo_Deferred_Permission->execute(Array, Array, 7.9999358654022, 'Rebuilding... P...')
#11 /srv/www/theadminzone.com/public_html/library/XenForo/Deferred/Atomic.php(66): Bookmarks_Deferred_Permission->execute(Array, Array, 7.9999358654022, 'Rebuilding... P...')
#12 /srv/www/theadminzone.com/public_html/library/XenForo/Model/Deferred.php(294): XenForo_Deferred_Atomic->execute(Array, Array, 7.9999988079071, 'Rebuilding... P...')
#13 /srv/www/theadminzone.com/public_html/library/XenForo/Model/Deferred.php(428): XenForo_Model_Deferred->runDeferred(Array, 7.9999988079071, 'Rebuilding... P...', false)
#14 /srv/www/theadminzone.com/public_html/library/XenForo/Model/Deferred.php(373): XenForo_Model_Deferred->_runInternal(Array, NULL, 'Rebuilding... P...', false)
#15 /srv/www/theadminzone.com/public_html/library/XenForo/ControllerAdmin/Tools.php(159): XenForo_Model_Deferred->run(true, NULL, 'Rebuilding... P...', false)
#16 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_Tools->actionRunDeferred()
#17 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#18 /srv/www/theadminzone.com/public_html/admin.php(13): XenForo_FrontController->run()
#19 {main}
Request State
array(3) {
  ["url"] => string(53) "https://theadminzone.com/admin.php?tools/run-deferred"
  ["_GET"] => array(1) {
    ["tools/run-deferred"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["redirect"] => string(43) "https://theadminzone.com/admin.php?add-ons/"
    ["execute"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 
Okay, was able to complete the rebuild process after disabling the add-on. Once that was completed and the add-on re-enabled everything appears to have gone back to normal. :)
 
Rob said:
@Daniel Hood , I need an option to turn off the "search" feature of this mod. Basically, I do not want any conversations in the search indexes at all because they are taking up a mammoth amount of the search index and is also really impacting on search relevancy (since 99% of results are disregarded) and also performance. Please can you tell me how to disable this feature and also flush the indexed conversations from the search index (I'm using enhanced / elastic search).

I need the other features but need to disable the conversation search
Click to expand...

Daniel Hood said:
Deleting the searchhandler from the xf_content_type_field table should work.
Click to expand...

@Rob did this work for you?

I'd also appreciate an option to disable the search feature :)
 
I haven't removed the handler Joe as I'm waiting for the mod to include this natively.
 
Export would be useful, especially when boards have a conversation pruning policy for older convos. Not sure it should be in the mod core though, sounds like a separate add on to me.
 
Rob said:
sounds like a separate add on to me.
Click to expand...

There is already a seperate add-on for that. ;-)

To be or not to be in the core mod should be a decision based on being useful in the majority of the installations. A criteria which "Inbox Filter" does not match IMHO, but "Export" would. ;-)
 
I agree it's more useful, but feature creep is a fine balance. Neither function helps me personally nor more than 99% of my members.
 
Stuart Wright said:
Conversation spam is very rare.
Click to expand...

It depends what kind of community you're running! :) I've asked Daniel to include the filter function because for my community (teenager community where A LOT of girls get really "weird" conversations from guys) it's a must have.

I'm totally on your side, i don't like either when an addon get's bloated but you always have to see both sides.
 
I'm using Conversation Essentials and I'm about to upgrade from 1.1 to 1.4. I can see in my installation that current version 1.1.2 is relying on TMS. I intend to remove this add-on. Is the new version of Conversation Essentials relying on this add-on?
 
No, everything uses template modifications (xf core as of 1.2). You should probably update conversation essentials just to be safe though before you uninstall tms
 
Daniel Hood said:
No, everything uses template modifications (xf core as of 1.2). You should probably update conversation essentials just to be safe though before you uninstall tms
Click to expand...
That was going to be my next question. Even though ConvEss does not support 1.1 it's best practice to update the product before going to Xf 1.4?
 
Hmm no more recent versions are incompatible with 1.1 so that won't work. You should probably disable add ons while you update xenforo and then update your addons.
 
You must log in or register to reply here.

Similar threads

Stuart Wright
Trophy Essentials [Paid]
3 4 5
Replies
82
Views
4K
Stuart Wright
Stuart Wright
Wutime
Search Limit Essentials - Boost Registrations and Upgrades [Paid]
Replies
4
Views
750
Wutime
Wutime
Wutime
Advanced Quote/Reply Essentials [Paid]
2 3 4
Replies
69
Views
4K
Rangers Fans
Rangers Fans
AddonFlare
[AddonFlare] XF2 Ignore/Block Essentials [Paid]
10 11 12
Replies
233
Views
16K
Forsaken
Forsaken
X
Conversation Essentials [Paid]
24 25 26
Replies
501
Views
25K
Xon
X
Back
Top Bottom