XenCentral Feedback System 2

XenCentral Feedback System 2 [Paid] 2.3.5

No permission to buy (€54.99)
You should allow download of add-on versions which were released when the license was active. Just like we have on xenForo.
 
ErrorException: [E_NOTICE] Trying to access array offset on value of type null src/addons/XenCentral/Feedback/Repository/Activity.php:131

I have XF 2.2 and Feedback System 2.3.1, but I am still getting these errors (should have been fixed in 2.2.7.1).

XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x92\xAA' for column matkap_20201006.xf_xc_feedback_comment.message at row 1 src/XF/Db/AbstractStatement.php:228

Another error message.

Also, the table xf_xc_feedback_acivity is huge, 3.4 GB (xf_post is 1.5 GB).
 
Getting this error after upgrading to XF2.2:

  • ErrorException: Template error: Method canViewFeedbackXcfs is not callable on the given object (XF\Entity\User)
  • src/XF/Template/Templater.php:1161
  • Generated by: Unknown account
  • 10/18/20 at 2:32 PM

Stack trace​

#0 [internal function]: XF\Template\Templater->handleTemplateError(512, 'Method canViewF...', '/home/oakleyfo/...', 1161, Array)
#1 src/XF/Template/Templater.php(1161): trigger_error('Method canViewF...', 512)
#2 internal_data/code_cache/navigation_cache.php(541): XF\Template\Templater->method(Object(XF\Entity\User), 'canViewFeedback...', Array)
#3 src/XF/Template/Templater.php(7311): XF\Pub\App->{closure}(Object(XF\Template\Templater), 'forums', Array)
#4 src/XF/Pub/App.php(575): XF\Template\Templater->renderNavigationClosure(Object(Closure), 'forums', Array)
#5 src/XF/Pub/App.php(526): XF\Pub\App->getNavigation(Array, 'forums')
#6 src/XF/App.php(2105): XF\Pub\App->renderPageHtml('<div class="blo...', Array, Object(XF\Mvc\Reply\Message), Object(XF\Mvc\Renderer\Html))
#7 src/XF/Mvc/Dispatcher.php(402): XF\App->renderPage('<div class="blo...', Object(XF\Mvc\Reply\Message), Object(XF\Mvc\Renderer\Html))
#8 src/XF/Mvc/Dispatcher.php(58): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\Message), 'html')
#9 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#10 src/XF.php(465): XF\App->run()
#11 index.php(20): XF::runApp('XF\\Pub\\App')
#12 {main}

Request state​

array(4) {
["url"] => string(56) "/threads/searching-texas-for-display.107189/post-1358784"
["referrer"] => bool(false)
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
The developers of this addon seem to be AWOL. I left a ticket at https://xencentral.com/ a couple of days ago, but unusually, they haven't responded.
There is at least one significantly slow query in this addon.
The query to find threads in the specified (trading) forums which two users have posted to is
SELECT thread.* FROM xf_thread AS thread

INNER JOIN xf_post AS post1 ON post1.thread_id=thread.thread_id AND post1.user_id=48749
INNER JOIN xf_post AS post2 ON post2.thread_id=thread.thread_id AND post2.user_id=134693

WHERE 1=1 AND thread.node_id IN('198', '62', '90', '338', '185', '153', '85', '51', '93', '329', '380', '353', '99', '538', '340', '402', '341', '492', '539', '339', '409', '241', '243', '391', '358', '154', '330', '476', '343', '531', '541', '394', '344', '252', '268', '121') AND thread.user_id IN(48749, '134693')
GROUP BY thread.thread_id
ORDER BY thread.post_date DESC
LIMIT 30;
Which is horrendous at 14.2 seconds to execute.
I had a play this morning following a suggestion from @Xon to use xf_thread_user_post and came up with
SELECT thread.* FROM xf_thread AS thread
INNER JOIN
(SELECT thread_id, count( *) c from xf_thread_user_post where user_id in (48749,134693) group by thread_id having c > 1) as thread_users
ON thread.thread_id = thread_users.thread_id
WHERE 1=1 AND thread.node_id IN('198', '62', '90', '338', '185', '153', '85', '51', '93', '329', '380', '353', '99', '538', '340', '402', '341', '492', '539', '339', '409', '241', '243', '391', '358', '154', '330', '476', '343', '531', '541', '394', '344', '252', '268', '121')
ORDER BY thread.post_date DESC
LIMIT 30
Which takes .01 seconds to execute. And I'm not an SQL expert.

We're also getting slow queries when feedback is being added.
Hopefully we can get a new release with optimised queries.
 
Last edited:
There seems to be an issue with the xcfs_unique_deal_url option. The option is described as "Do not allow users to leave feedback twice for the same thread." But it seems that I can leave feedback twice by using multiple browsers. The add-on does not seem to check for unique feedback when saving the feedback to the database, but only when generating the user interface.
 
I'm using this addon with xenForo 2.2.1. It happens quite often that the feedback is written to the database twice, with 1 second difference. So far I could not reproduce it myself, e.g. by double-clicking the submit button. Any idea why this happens?
This did not happen with xenForo 2.1.
 
Top Bottom