Post Ratings - taking likes to the next level [Deleted]

Unable to copy posts in Xenforo 1.3 Beta 2 due to this error. I have to disable it for it to work.

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'dark_postrating_1_count' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: DRE, Today at 6:23 PM
Stack Trace
#0 /home/dre/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/yo/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/yo/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/yo/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/yo/public_html/library/XenForo/Model/Post.php(1543): Zend_Db_Adapter_Abstract->insert('xf_post', Array)
#5 /home/yo/public_html/library/XfAddOns/Blogs/Override/Model/Post.php(42): XenForo_Model_Post->_copyPost(Array, Array, Array)
#6 /home/yo/public_html/library/XenForo/Model/Post.php(1421): XfAddOns_Blogs_Override_Model_Post->_copyPost(Array, Array, Array)
#7 /home/yo/public_html/library/XenForo/Model/Post.php(1329): XenForo_Model_Post->_moveOrCopyPosts('copy', Array, Array, Array, Array)
#8 /home/yo/public_html/library/XenForo/Model/InlineMod/Post.php(459): XenForo_Model_Post->copyPosts(Array, Array, Array, Array)
#9 /home/yo/public_html/library/XenForo/Model/InlineMod/Post.php(410): XenForo_Model_InlineMod_Post->_moveOrCopyPosts('copy', Array, Array, Array, Array, NULL)
#10 /home/yo/public_html/library/XenForo/ControllerPublic/InlineMod/Post.php(223): XenForo_Model_InlineMod_Post->copyPosts(Array, Array, NULL)
#11 /home/yo/public_html/library/XenForo/ControllerPublic/InlineMod/Post.php(153): XenForo_ControllerPublic_InlineMod_Post->_moveOrCopyPostsAction('canCopyPosts', 'copyPosts', 'XenForo_ViewPub...', 'inline_mod_post...')
#12 /home/yo/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_InlineMod_Post->actionCopy()
#13 /home/yo/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /home/yo/public_html/index.php(13): XenForo_FrontController->run()
#15 {main}
Request State
array(3) {
["url"] => string(35) "https://8th.us/inline-mod/post/copy"
["_GET"] => array(0) {
}
["_POST"] => array(7) {
["thread_type"] => string(8) "existing"
["existing_url"] => string(44) "https://8th.us/topic/personal-boycotts.1340/"
["save"] => string(10) "Copy Posts"
["posts"] => array(1) {
[0] => string(6) "172649"
}
["_xfConfirm"] => string(1) "1"
["redirect"] => string(49) "https://8th.us/topic/star-trek.17398/#post-172649"
["_xfToken"] => string(8) "********"
}
}
 
DRE said:
Unable to copy posts in Xenforo 1.3 Beta 2 due to this error. I have to disable it for it to work.

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'dark_postrating_1_count' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: DRE, Today at 6:23 PM
Stack Trace
#0 /home/dre/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/yo/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/yo/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/yo/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/yo/public_html/library/XenForo/Model/Post.php(1543): Zend_Db_Adapter_Abstract->insert('xf_post', Array)
#5 /home/yo/public_html/library/XfAddOns/Blogs/Override/Model/Post.php(42): XenForo_Model_Post->_copyPost(Array, Array, Array)
#6 /home/yo/public_html/library/XenForo/Model/Post.php(1421): XfAddOns_Blogs_Override_Model_Post->_copyPost(Array, Array, Array)
#7 /home/yo/public_html/library/XenForo/Model/Post.php(1329): XenForo_Model_Post->_moveOrCopyPosts('copy', Array, Array, Array, Array)
#8 /home/yo/public_html/library/XenForo/Model/InlineMod/Post.php(459): XenForo_Model_Post->copyPosts(Array, Array, Array, Array)
#9 /home/yo/public_html/library/XenForo/Model/InlineMod/Post.php(410): XenForo_Model_InlineMod_Post->_moveOrCopyPosts('copy', Array, Array, Array, Array, NULL)
#10 /home/yo/public_html/library/XenForo/ControllerPublic/InlineMod/Post.php(223): XenForo_Model_InlineMod_Post->copyPosts(Array, Array, NULL)
#11 /home/yo/public_html/library/XenForo/ControllerPublic/InlineMod/Post.php(153): XenForo_ControllerPublic_InlineMod_Post->_moveOrCopyPostsAction('canCopyPosts', 'copyPosts', 'XenForo_ViewPub...', 'inline_mod_post...')
#12 /home/yo/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_InlineMod_Post->actionCopy()
#13 /home/yo/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /home/yo/public_html/index.php(13): XenForo_FrontController->run()
#15 {main}
Request State
array(3) {
["url"] => string(35) "https://8th.us/inline-mod/post/copy"
["_GET"] => array(0) {
}
["_POST"] => array(7) {
["thread_type"] => string(8) "existing"
["existing_url"] => string(44) "https://8th.us/topic/personal-boycotts.1340/"
["save"] => string(10) "Copy Posts"
["posts"] => array(1) {
[0] => string(6) "172649"
}
["_xfConfirm"] => string(1) "1"
["redirect"] => string(49) "https://8th.us/topic/star-trek.17398/#post-172649"
["_xfToken"] => string(8) "********"
}
}
Click to expand...

Is this meant to go in the better blogs thread?
 
oman said:
Is this meant to go in the better blogs thread?
Click to expand...
You can copy n paste it there if you want. The error does say post rating in it though and I wasn't able to copy posts. When I disabled it, it worked. I didn't have to disable better blogs for it to work.
 
Does this plugin have any capabilities that allow members to search, sort, or filter content by these ratings? For instance, I want to do a Search and find only posts or content that was rated "funny" or "helpful". Or maybe just sort results by a certain rating so that content with that rating shows up first?

If not, I think this would be the next logical step for this plugin, as rated posts are nice but if you can't easily find them what's the point, right? Part of the problem on forums is finding the best content fast.
 
No it doesn't do that. But this add on was not designed to be used as a thread or post organizer. You ask what is the point of the add on if not to organize certain rated posts? The point is to rate posts and it does a bang up job of it. My members love this add on it's one of their favorites, and maybe *the* favorite.
 
I'm not saying it isn't useful now (sorry, wasn't meant to be a dig) but when I think of rating content it just makes sense to have an easy way of finding top rated content later. A way of bubbling all those ratings to the top somehow. Just seems like a logical next step.
 
Is there a way to view the posts that get rated? Let's say I have 50 rated posts, can other users click a link somewhere to see those rated posts? How exactly do you quickly find all rated posts for each user? Or is there no way of doing so?
 
That's not a feature either. This is a pretty straight forward add on. In order to possibily get your ideas implemented you should ask Luke what the feasibility is to do it. A premium add on usually means the author would want to be paid to modifiy the add on. Who can blame them it's not easy to write these things - takes a lot time to learn all the things necessary to do it. Even if the add on itself is a simple one and didn't take all that long to write, the author still had to invest many many hours in learning how to do them.

I'm not saying your ideas are not good though, I think they are both quite good.
 
I might put in a request, but was more just trying to find out about default functionality of the plugin. I'm completely familiar with the premium add-on model and dealing with plugin authors. I definitely have come to appreciate what a solid developer community does for a script like XF.

Another question - is there a setting that allows certain sprites/icons to be used for certain forums and different sprites for other forums (defined by the admin)?
 
Ludachris said:
... Another question - is there a setting that allows certain sprites/icons to be used for certain forums and different sprites for other forums (defined by the admin)?
Click to expand...

You can enable or disable the group as a whole in certain forums but I don't know about splitting up certain ones to certain forums. That might be doable but I don't know how. One thing you might really like about it is how easy it is to customize your own icons. I had one of my members make these for us and you can add more quite easily.

RatingIcons.webp
 
@Luke Foreman our customer received following error with your addon Post Rating.

Details of the Error :

Error Info
Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Column 'like_count' in field list is ambiguous - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 10:22 AM

Stack Trace :

Code: 
#0 /home/nullse/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT use...')
#1 /home/nullse/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT use...')
#2 /home/nullse/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT use...')
#3 /home/nullse/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT use...', Array, 2)
#4 /home/nullse/public_html/library/XenForo/Model/User.php(297): XenForo_Model->fetchAllKeyed('?????SELECT use...', 'user_id')
#5 /home/nullse/public_html/library/*******/ReferralCreditSystem/CronEntry/Referral.php(29): XenForo_Model_User->getUsers(Array, Array)
#6 [internal function]: *******_ReferralCreditSystem_CronEntry_Referral::runPromotions(Array)
#7 /home/nullse/public_html/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#8 /home/nullse/public_html/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#9 /home/nullse/public_html/library/XenForo/Model/Deferred.php(252): XenForo_Deferred_Cron->execute(Array, Array, 9.99999499321, '')
#10 /home/nullse/public_html/library/XenForo/Model/Deferred.php(378): XenForo_Model_Deferred->runDeferred(Array, 9.99999499321, '', false)
#11 /home/nullse/public_html/library/XenForo/Model/Deferred.php(331): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#12 /home/nullse/public_html/deferred.php(23): XenForo_Model_Deferred->run(false)
#13 {main}

Request State
Code: 
array(3) {
["url"] => string(35) "http://www.null-sec.ru/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(79) "/index.php?threads/what-sub-sections-would-you-like-in-the-gaming-sections.296/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

We found at library/Dark/PostRating/Model/User.php you used like_count without specifying a table name. Please fix this on next release.

Regards,
 
Last edited:
Hi @Luke Foreman ,

Have you considered putting in a positive/negative post rating ratio in the User Group Promotions rules? Something like the like ratio that exists there currently? This seems like it would be a great addition.

Thanks!
 
Luke Foreman updated Post Ratings - taking likes to the next level with a new update entry:

Version 1.6.3

Please expand post to view the update instructions.


Changelog:

1.6.3 (28/02/2014):

  • Fixed issue with copy posts in XenForo 1.3
  • Added an invisible retry mechanism in case of database locks (e.g. previously sometimes having to click undo rating multiple times for it to register)
  • Added ‘Hide post negative post percentage’ option, making the ‘Hide...
Click to expand...

Read the rest of this update entry...
 
Hi @Luke Foreman ,

What I tried to say above was almost exactly what you changed here:

Luke Foreman said:
Added ‘Hide post negative post percentage’ option, making the ‘Hide post after x negative ratings’ option more useful especially on larger forums by applying an (optional) additional ratio of negative to total ratings on a post.
Click to expand...

Something like this for user group promotions options from:
  • User has received at least X negative post ratings:
to
  • User has received at least X negative post percentage ratings:
This would be really helpful and cool! :D

A happy post ratings customer!
 
You must log in or register to reply here.
Back
Top Bottom