Post Ratings - taking likes to the next level [Deleted]
- Thread starter Luke F
- Start date
TheLaw
Well-known member
I have an error:
Post Thank You Hack import:
insert ignore into xfxfxf.dark_postrating select null, postid, userid, content_userid, THANKS_RATING_ID, date from vbvbvbvb.post_thanks
Unknown column 'content_userid' in 'field list'
That's because it doesn't exist in dark_postrating. Is there a replacement field for this or was it extra? I've noticed that it's a field from table xf_liked_content.
EDIT - Just noticed someone else asked the same question but can't find an answer yet. May want to edit this query in your first post on this thread.
Post Thank You Hack import:
insert ignore into xfxfxf.dark_postrating select null, postid, userid, content_userid, THANKS_RATING_ID, date from vbvbvbvb.post_thanks
Unknown column 'content_userid' in 'field list'
That's because it doesn't exist in dark_postrating. Is there a replacement field for this or was it extra? I've noticed that it's a field from table xf_liked_content.
EDIT - Just noticed someone else asked the same question but can't find an answer yet. May want to edit this query in your first post on this thread.
Luke F
Well-known member
This might work:
Code:
insert ignore into XENFORO_DB_NAME.dark_postrating
select null, ty.postid, ty.userid, po.userid, THANKS_RATING_ID, ty.date
from VBULLETIN_DB_NAME.post_thanks ty
left join VBULLETIN_DB_NAME.post po on ty.postid = po.postidHi. Is it possible to add elements to the postbit so that it shows individual stats for each button that is added with post ratings? So for example lets say I have "useful rating"" and "Information rating" enabled, the post bit would show how many of each the user has
likes receive = x
Information Ratings received = x
Useful Ratings received = x
I see the option for total ratings and the total ratings as a bar, but not something like I mentioned above
likes receive = x
Information Ratings received = x
Useful Ratings received = x
I see the option for total ratings and the total ratings as a bar, but not something like I mentioned above
JamesBrown
Well-known member
Is anyone using this on large boards 1m +posts, 000's of members? Thanks
clove28
Active member
Hi @Luke F ,
I'm receiving this error..What could be the problem?
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Table definition has changed, please retry transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Today at 7:00 AM
Stack Trace
#0 /pefcommunity.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /pefcommunity.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /pefcommunity.com/public/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tSELECT MIN...', Array)
#3 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(172): Zend_Db_Adapter_Abstract->fetchOne('\r\n\t\t\tSELECT MIN...')
#4 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(145): XenForo_Model_Deferred->updateNextDeferredTime()
#5 /pefcommunity.com/public/library/XenForo/Application.php(1457): XenForo_Model_Deferred->defer('AdminTemplatePa...', Array, NULL, false, NULL)
#6 /pefcommunity.com/public/library/XenForo/Model/AdminTemplate.php(739): XenForo_Application::defer('AdminTemplatePa...', Array, NULL, true)
#7 /pefcommunity.com/public/library/XenForo/DataWriter/Phrase.php(368): XenForo_Model_AdminTemplate->compileAdminTemplatesThatIncludePhrase('trophy_points')
#8 /pefcommunity.com/public/library/XenForo/DataWriter/Phrase.php(273): XenForo_DataWriter_Phrase->_recompileTemplatesIncludingPhrase()
#9 /pefcommunity.com/public/library/XenForo/DataWriter.php(1409): XenForo_DataWriter_Phrase->_postSave()
#10 /pefcommunity.com/public/library/Dark/PostRating/CronEntry.php(23): XenForo_DataWriter->save()
#11 [internal function]: Dark_PostRating_CronEntry::runDailyOptimisation(Array)
#12 /pefcommunity.com/public/library/XenForo/Model/Cron.php(357): call_user_func(Array, Array)
#13 /pefcommunity.com/public/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#14 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(294): XenForo_Deferred_Cron->execute(Array, Array, 7.9999971389771, '')
#15 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(428): XenForo_Model_Deferred->runDeferred(Array, 7.9999971389771, '', false)
#16 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(373): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#17 /pefcommunity.com/public/deferred.php(23): XenForo_Model_Deferred->run(false)
#18 {main}
I'm receiving this error..What could be the problem?
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Table definition has changed, please retry transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Today at 7:00 AM
Stack Trace
#0 /pefcommunity.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /pefcommunity.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /pefcommunity.com/public/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tSELECT MIN...', Array)
#3 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(172): Zend_Db_Adapter_Abstract->fetchOne('\r\n\t\t\tSELECT MIN...')
#4 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(145): XenForo_Model_Deferred->updateNextDeferredTime()
#5 /pefcommunity.com/public/library/XenForo/Application.php(1457): XenForo_Model_Deferred->defer('AdminTemplatePa...', Array, NULL, false, NULL)
#6 /pefcommunity.com/public/library/XenForo/Model/AdminTemplate.php(739): XenForo_Application::defer('AdminTemplatePa...', Array, NULL, true)
#7 /pefcommunity.com/public/library/XenForo/DataWriter/Phrase.php(368): XenForo_Model_AdminTemplate->compileAdminTemplatesThatIncludePhrase('trophy_points')
#8 /pefcommunity.com/public/library/XenForo/DataWriter/Phrase.php(273): XenForo_DataWriter_Phrase->_recompileTemplatesIncludingPhrase()
#9 /pefcommunity.com/public/library/XenForo/DataWriter.php(1409): XenForo_DataWriter_Phrase->_postSave()
#10 /pefcommunity.com/public/library/Dark/PostRating/CronEntry.php(23): XenForo_DataWriter->save()
#11 [internal function]: Dark_PostRating_CronEntry::runDailyOptimisation(Array)
#12 /pefcommunity.com/public/library/XenForo/Model/Cron.php(357): call_user_func(Array, Array)
#13 /pefcommunity.com/public/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#14 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(294): XenForo_Deferred_Cron->execute(Array, Array, 7.9999971389771, '')
#15 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(428): XenForo_Model_Deferred->runDeferred(Array, 7.9999971389771, '', false)
#16 /pefcommunity.com/public/library/XenForo/Model/Deferred.php(373): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#17 /pefcommunity.com/public/deferred.php(23): XenForo_Model_Deferred->run(false)
#18 {main}
clove28
Active member
Any news on this? This error shows for almost eveeryday now..
Luke F
Well-known member
This could be either a conflict with another addon or a server issue. You can safely disable the Post Ratings daily cron in Admin CP > Tools > Cron Entries - it only serves to provide a very minor performance optimisation
D3NYMoTiioN
Member
I bought this resource about an hour or two ago and for some reason I cannot download it, it just asks me to purchase it again?! I can provide a transaction ID and proof of purchase.
BobbyWibowo
Well-known member
As far as I know, yes.
Luke F
Well-known member
There is no particular style property for this. It uses a standard XF CSS selector - .secondaryContent - which should look consistent with your style
If you want to override it, the CSS selector is .dark_postrating
This should only affect the member card, where post ratings uses the trophy points phrase to identify the middle of the member card info line. I will add an option to just put it at the end of the member card info so there is no requirement for trophies being intact
Steve Brewer
Member
Post ratings aren't showing up anywhere. I've noticed people have had this issue and you've said it's permissions but my permissions are explicitly set to allow for registered users, I've also since set it to allow for all groups and it's still not showing up.
I can see the bar when someone's already liked a post, there's just nothing else in that bar.
I've tried the Xenporta2 line of code (although I'm using Xenporta) and that didn't help. I've tried reinstalling. I've checked every option I can find :/
Here's a thread on my forums:
Ranks | Redstone Rangers
I can see the bar when someone's already liked a post, there's just nothing else in that bar.
I've tried the Xenporta2 line of code (although I'm using Xenporta) and that didn't help. I've tried reinstalling. I've checked every option I can find :/
Here's a thread on my forums:
Ranks | Redstone Rangers
Last edited: