XF 1.1 More errors... oh what fun... not...

[vVv]

Just got this one couple minutes ago on index page, nothing in ACP server error logs about it.. then last one was 34 minutes ago.. which was found in ACP server error logs..

I never had so many errors running forum software before.. wth? Is it XenForo, the shytty host... crap resources that lack resource author support or what? I submitted error to that resource author about Separate Sticky and Normal threads other day and nothing for response.. seems to be the norm here anymore.

An exception occurred: Mysqli statement execute error : Prepared statement needs to be re-prepared in /home/myuser/public_html/library/Zend/Db/Statement/Mysqli.php on line 214
 
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
    Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 50
    XenForo_Error::unexpectedException() in XenForo/Application.php at line 295
    XenForo_Application::handleException()

ErrorException: Undefined index: stickyThreads - library/SeparateStickyAndNormal/Listener.php:7
Generated By: cplbeowolf, 34 minutes ago
Stack Trace
 
#0 /home/myuser/public_html/library/SeparateStickyAndNormal/Listener.php(7): XenForo_Application::handlePhpError(8, 'Undefined index...', '/home/myuser/...', 7, Array)
#1 [internal function]: SeparateStickyAndNormal_Listener::templateHook('waindigo_search...', '<li id="thread-...', Array, Object(XenForo_Template_Public))
#2 /home/myuser/public_html/library/XenForo/CodeEvent.php(54): call_user_func_array(Array, Array)
#3 /home/myuser/public_html/library/XenForo/Template/Abstract.php(285): XenForo_CodeEvent::fire('template_hook', Array)
#4 /home/myuser/public_html/library/Waindigo/ThreadThumbnails/Search/DataHandler/Thread.php(65): XenForo_Template_Abstract->callTemplateHook('waindigo_search...', '<li id="thread-...', Array)
#5 /home/myuser/public_html/library/XenForo/ViewPublic/Helper/Search.php(16): Waindigo_ThreadThumbnails_Search_DataHandler_Thread->renderResult(Object(XenForo_ViewPublic_Member_RecentContent), Array, Array)
#6 /home/myuser/public_html/library/XenForo/ViewPublic/Member/RecentContent.php(9): XenForo_ViewPublic_Helper_Search::renderSearchResults(Object(XenForo_ViewPublic_Member_RecentContent), Array)
#7 /home/myuser/public_html/library/XenForo/ViewRenderer/Abstract.php(215): XenForo_ViewPublic_Member_RecentContent->renderHtml()
#8 /home/myuser/public_html/library/XenForo/ViewRenderer/Json.php(220): XenForo_ViewRenderer_Abstract->renderViewObject('XenForo_ViewPub...', 'Html', Array, 'member_recent_c...')
#9 /home/myuser/public_html/library/XenForo/ViewRenderer/Json.php(97): XenForo_ViewRenderer_Json->getDefaultOutputArray('XenForo_ViewPub...', Array, 'member_recent_c...')
#10 /home/myuser/public_html/library/XenForo/FrontController.php(533): XenForo_ViewRenderer_Json->renderView('XenForo_ViewPub...', Array, 'member_recent_c...', NULL)
#11 /home/myuser/public_html/library/XenForo/FrontController.php(156): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_Json), Array)
#12 /home/myuser/public_html/index.php(13): XenForo_FrontController->run()
#13 {main}
 
Request State
 
array(3) {
  ["url"] => string(217) "http://footish.xxx/members/troublechild76.18651/recent-content?_xfRequestUri=%2Fmembers%2Ftroublechild76.18651%2F&_xfNoRedirect=1&_xfToken=5%2C1355466389%2C93d45632c126590bb5eda4d62ee294bb4c02a067&_xfResponseType=json"
  ["_GET"] => array(4) {
    ["_xfRequestUri"] => string(30) "/members/troublechild76.18651/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(53) "5,1355466389,93d45632c126590bb5eda4d62ee294bb4c02a067"
    ["_xfResponseType"] => string(4) "json"
  }
  ["_POST"] => array(0) {
  }
}

 

[vVv]

uninstalled that damned resource... so no more of that error lol. still not sure about first error.. guess my host is really ****ty.. what else is new..

 

[Jake Bunce]

First error is a server issue. See this thread, and specifically my post where I posted some possible fixes:

http://xenforo.com/community/threads/error-on-install.17901/#post-236565

Second error names the "SeparateStickyAndNormal" addon.

 

[vVv]

First error is a server issue. See this thread, and specifically my post where I posted some possible fixes:

http://xenforo.com/community/threads/error-on-install.17901/#post-236565

Second error names the "SeparateStickyAndNormal" addon.

Thanks Jake, and yeah.. if I remember right.. you linked me to that before...
http://xenforo.com/community/thread...red-please-try-again-later.40886/#post-443567

The host response in quote:
http://xenforo.com/community/thread...red-please-try-again-later.40886/#post-443819

I seriously need new host though.. the current one said about giving refund for me.. just not sure what other shared hosting companies won't screw with me and lack me in important features/things..

As for addon, I uninstalled it totally... The resource author must have jumped ship on it.. but that's normal now so...
http://xenforo.com/community/threads/separate-sticky-and-normal-threads.30263/#post-453257

Left that Tuesday... He/she hasn't been around since Nov 4th http://xenforo.com/community/members/vinavb.7122/

Maybe someone else, reliable coder/ author take it over.. lol

 

[vVv]

Well, the second error is fixed now, thanks to Chris fixing someone elses resource.. lol
http://xenforo.com/community/threads/separate-sticky-and-normal-threads.30263/#post-454371

The first error, which Jake provided link to possible fixes.. can't be done/applied because of the crappy host limiting shared hosting accounts for it.

I'm not sure this can be done on a shared server but we'll look into this.

Unfortunately these mysql customizations are not an option on shared hosting.

If you are interested in upgrading to a dedicated server we could customize the specific
mysql build to your needs.

http://certifiedhosting.com/managed-dedicated-servers/

Please let us know if there is anything else.

So now, it's time to look for another shared host and get full refund (because I can't afford dedicated hosting nor VPS or whatever).. and hopefully not result in hours of downtime to move to another host after getting refund and paying for new host etc etc.