whynot
Well-known member
They occurred after the uploading of the files but ceased after the upgrade.Updated, but got about 50 identical server errors during the process:
They occurred after the uploading of the files but ceased after the upgrade.Updated, but got about 50 identical server errors during the process:
It automatically did a post ratings rebuild immediately after upgrade for me.[...] so it is recommended to recount ratings after upgrading if your users abused it.
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) { } }
It automatically did a post ratings rebuild immediately after upgrade for me.
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) { } }
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 RatingsTried 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
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
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
Awesome thank you..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
I added extra padding to the icons in the template dark_postrating.cssWhere can I change the spacing of the icons my members have fat fingers!
/* 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?
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.the full recount ratings process does a couple of other things (recounting totals and rating-like conversion)
For me, it took ~4.5 hours for ~2 million posts with ~670k ratings.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?
We use essential cookies to make this site work, and optional cookies to enhance your experience.