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

Updated, but got about 50 identical server errors during the process:

Code:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'theadminzone.dark_postrating_post_cache' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 12:53 PM
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 pos...')
#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 pos...')
#2 /srv/www/theadminzone.com/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tSELECT pos...')
#3 /srv/www/theadminzone.com/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tSELECT pos...', 101582, 2)
#4 /srv/www/theadminzone.com/public_html/library/XenForo/Model/Post.php(243): XenForo_Model->fetchAllKeyed('\r\n\t\t\tSELECT pos...', 'post_id', 101582)
#5 /srv/www/theadminzone.com/public_html/library/XenForo/ControllerPublic/Thread.php(68): XenForo_Model_Post->getPostsInThread(101582, Array)
#6 /srv/www/theadminzone.com/public_html/library/Waindigo/Trophies/Extend/XenForo/ControllerPublic/Thread.php(17): XenForo_ControllerPublic_Thread->actionIndex()
#7 /srv/www/theadminzone.com/public_html/library/ModEss/ControllerPublic/Thread.php(17): Waindigo_Trophies_Extend_XenForo_ControllerPublic_Thread->actionIndex()
#8 /srv/www/theadminzone.com/public_html/library/ChangeThreadStarter/ControllerPublic/Thread.php(7): ModEss_ControllerPublic_Thread->actionIndex()
#9 /srv/www/theadminzone.com/public_html/library/Borbole/ThreadReaders/ControllerPublic/Thread.php(7): ChangeThreadStarter_ControllerPublic_Thread->actionIndex()
#10 /srv/www/theadminzone.com/public_html/library/CTA/FeaturedThreads/ControllerPublic/Thread.php(208): Borbole_ThreadReaders_ControllerPublic_Thread->actionIndex()
#11 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(347): CTA_FeaturedThreads_ControllerPublic_Thread->actionIndex()
#12 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#13 /srv/www/theadminzone.com/public_html/index.php(13): XenForo_FrontController->run()
#14 {main}
Request State
array(3) {
  ["url"] => string(67) "https://theadminzone.com/threads/ipb-email-activation-email.101582/"
  ["_GET"] => array(1) {
    ["/threads/ipb-email-activation-email_101582/"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}

That can be expected, these will have been generated in the time between uploading the new PHP files and applying the addon xml upgrade. They can be safely ignored.

It automatically did a post ratings rebuild immediately after upgrade for me.

The upgrade will only build the cache - the full recount ratings process does a couple of other things (recounting totals and rating-like conversion)
 
Just upgraded and now get this server error:
Code:
ErrorException: Fatal Error: Cannot redeclare class XFCP_Dark_TaigaChat_Model_SessionOverride - /home/ftvworld/public_html/forums/library/XenForo/Application.php(520) : eval()'d code:1
Generated By: Nationwide Communications, 18 minutes ago
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}
Request State
array(3) {
["url"] => string(95) "http://ftvworld.net/wp-content/plugins/ultimate-under-construction/includes/js/flipclock.min.js"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
Just upgraded and now get this server error:
Code:
ErrorException: Fatal Error: Cannot redeclare class XFCP_Dark_TaigaChat_Model_SessionOverride - /home/ftvworld/public_html/forums/library/XenForo/Application.php(520) : eval()'d code:1
Generated By: Nationwide Communications, 18 minutes ago
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}
Request State
array(3) {
["url"] => string(95) "http://ftvworld.net/wp-content/plugins/ultimate-under-construction/includes/js/flipclock.min.js"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

Nothing has changed that could have caused that, and the fact you are getting that error on a request for a wordpress javascript file would suggest an external cause, as php shouldn't even be executing on such a request
 
Tried to upgrade but rebuild process stops with:
Rich (BB code):
ErrorException: Fatal Error: Call to undefined method XenForo_Model_Post::getPagedPostsPR() -library/Dark/PostRating/Deferred/PostCache.php:18
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}
Request State
array(3) {
  ["url"] => string(64) "http://www.tuxreports.com/community/admin.php?tools/run-deferred"
  ["_GET"] => array(1) {
    ["tools/run-deferred"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["redirect"] => string(45) "http://www.tuxreports.com/community/admin.php"
    ["execute"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 
Tried to upgrade but rebuild process stops with:
Rich (BB code):
ErrorException: Fatal Error: Call to undefined method XenForo_Model_Post::getPagedPostsPR() -library/Dark/PostRating/Deferred/PostCache.php:18
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}
Request State
array(3) {
  ["url"] => string(64) "http://www.tuxreports.com/community/admin.php?tools/run-deferred"
  ["_GET"] => array(1) {
    ["tools/run-deferred"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["redirect"] => string(45) "http://www.tuxreports.com/community/admin.php"
    ["execute"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
Try reuploading the PHP files, as that undefined method is added by Post Ratings
 
trying to upgrade to 1.7.0 and get this error
Code:
Fatal error: Call to undefined method Bookmarks_Model_Post::getPagedPostsPR() in /home/xxxxxxxx/public_html/library/Dark/PostRating/Deferred/PostCache.php on line 18
 
trying to upgrade to 1.7.0 and get this error
Code:
Fatal error: Call to undefined method Bookmarks_Model_Post::getPagedPostsPR() in /home/xxxxxxxx/public_html/library/Dark/PostRating/Deferred/PostCache.php on line 18

Try reuploading the PHP files and also temporarily disabling the Bookmarks addon
 
Try reuploading the PHP files and also temporarily disabling the Bookmarks addon
Code:
Server Error

Mysqli statement execute error : Table 'dark_postrating_post_cache' already exists

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Dark/PostRating/Install.php at line 275
    Dark_PostRating_Install->_installVersion34() in Dark/PostRating/Install.php at line 63
    Dark_PostRating_Install::install()
    call_user_func() in XenForo/Model/AddOn.php at line 215
    XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
    XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 187
    XenForo_ControllerAdmin_AddOn->actionInstall() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/xxxxxx/public_html/admin.php at line 13
 
Code:
Server Error

Mysqli statement execute error : Table 'dark_postrating_post_cache' already exists

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Dark/PostRating/Install.php at line 275
    Dark_PostRating_Install->_installVersion34() in Dark/PostRating/Install.php at line 63
    Dark_PostRating_Install::install()
    call_user_func() in XenForo/Model/AddOn.php at line 215
    XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
    XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 187
    XenForo_ControllerAdmin_AddOn->actionInstall() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/xxxxxx/public_html/admin.php at line 13

You will need to drop the table 'dark_postrating_post_cache' via phpmyadmin as the database is in an inconsistent state due to the failed upgrade
 
Where can I change the spacing of the icons my members have fat fingers!
I added extra padding to the icons in the template dark_postrating.css
I changed this line:
Code:
/* IB added padding */
.dark_postrating_inputlist li { display: inline; padding-right: 10px; opacity: 0.5; -ms-filter:'alpha(opacity=50)'; filter:alpha(opacity=50); zoom:1; }
 
@Luke Foreman

Under what circumstances should one use the Recount option?

Should it be run everytime a user is deleted, for example?

Like the various XF cache rebuild/recount options, you should not need to run it manually except during upgrades, imports, manual DB changes, etc. You do not need to run it after deleting a user unless you want rating totals to be reduced accordingly
 
the full recount ratings process does a couple of other things (recounting totals and rating-like conversion)
I have had this running for days and it's still nowhere near done. Often it just doesn't run any more when I run the deferred jobs. Sometimes it pops up and just continues. I think maybe the job doesn't finish and somewhere the system sort of forgets about it for a while and then remembers.
Is there anything you can do to optimise the recount so that it takes a reasonable amount of time? With 300,000 members and 20 million posts?
 
I had a quick question @Luke Foreman . Is there a way we can see which was the most liked, funniest, most thanked, most disliked post/thread for a specific time frame. Like the last week or month or year, etc?
 
I have had this running for days and it's still nowhere near done. Often it just doesn't run any more when I run the deferred jobs. Sometimes it pops up and just continues. I think maybe the job doesn't finish and somewhere the system sort of forgets about it for a while and then remembers.
Is there anything you can do to optimise the recount so that it takes a reasonable amount of time? With 300,000 members and 20 million posts?
For me, it took ~4.5 hours for ~2 million posts with ~670k ratings.
 
Back
Top Bottom