XF 1.1 Globally change directory "home" path...

[vVv]

Since moving to new Mike Edge's host, which is amazing actually, the "/home/myuser/public_html/" paths aren't including the "/home/" but now "/home2/ ... which all my resources, everything were installed originally for "/home/myuser/public_html/" .. getting errors in debug mode... some resources, are lagging, slowing down site... Is there a way to globally change / update BLOBs in database for the home path change?

Viewing thread gives... I tried disabling ALL resources, and the site speeds up amazingly... But the below error still exists and another error for "thread_view" as well..

Template Errors: thread_online
 
    Illegal string offset 'thumbnailUrl' in /home/myuser/public_html/library/XenForo/Template/Abstract.php(529) : eval()'d code, line 2076:
 
    2075: <li id="' . (($__compilerVar74) ? ('AttachedFileTemplate') : ('attachment' . htmlspecialchars($__compilerVar75['attachment_id']))) . '"
    2076:    class="AttachedFile ' . (($__compilerVar75['thumbnailUrl']) ? ('AttachedImage') : ('')) . ' secondaryContent">
    2077:
 
    Illegal string offset 'thumbnailUrl' in /home/myuser/public_html/library/XenForo/Template/Abstract.php(529) : eval()'d code, line 2080:
 
    2079:        ';
    2080: if ($__compilerVar75['thumbnailUrl'])
    2081: {
 
    Illegal string offset 'filename' in /home/myuser/public_html/library/XenForo/Template/Abstract.php(529) : eval()'d code, line 2095:
 
    2094: $__compilerVar76 .= '
    2095:            <!--<img src="' . XenForo_Template_Helper_Core::styleProperty('imagePath') . '/xenforo/widgets/page.png" alt="' . htmlspecialchars($__compilerVar75['filename']) . '" />-->
    2096:            <span class="genericAttachment"></span>
 
    Illegal string offset 'filename' in /home/myuser/public_html/library/XenForo/Template/Abstract.php(529) : eval()'d code, line 2103:
 
    2102:    <div class="AttachmentText">
    2103:        <div class="Filename"><a href="' . XenForo_Template_Helper_Core::link('attachments', $__compilerVar75, array()) . '" target="_blank">' . htmlspecialchars($__compilerVar75['filename']) . '</a></div>
    2104:

Also, when having "Borbole's guest/invalid thread view limit" resource installed, it gives white page when trying to search my own "messages" from the member card... but if I view someone with lesser message count, it works. Disabling that resource, it all works too.

Thread thumbnails, post as user, avatar of last poster, login as user, disabling alot of the "thread related" resources, really speeds up the site too. I'm just assuming / guessing, the home path needs changed globally, and not sure how to do it?

Also, viewing this page: http://feetfotos.com/admin.php?tools/phpinfo

says the "Include_path" is /home/ not /home2/ and I dunno how to change that either lol! I also rebuilt master data as well. Still no go. Do I have to reinstall all the resources FRESH again? Or is there query to run some where, to update ALL BLOBS in database with new home paths or what-not..

NOT: /home/
BUT: /home2/

 

[vVv]

I'm starting to think, upload fresh copies of XF software files again.. making sure to not overwrite special changes or whatever.. and uninstall resources, upload new files of them.. then reinstall them too. >_<. export styles, and reimport.. or install them fresh again as well.

 

[Dan]

Have you tried to just rebuild the Caches? I don't think rebuilding master data includes this function. Worth a shot. I don't think there is a variable to store the server path.

 

[vVv]

Have you tried to just rebuild the Caches? I don't think rebuilding master data includes this function. Worth a shot. I don't think there is a variable to store the server path.

Hey Dan.. Yeah, I've been Tools > Rebuilding Caches .. since I did the conversion of site, from localhost/ copy lol. I ran a database "find and replace" script.. to find "/home/" and replace with "/home2/" and some changes were made in database. But still getting errors in debug mode though. resources make it lag like crazy.. sigh. I'm just not sure what else to do though, except uninstall all resources, reupload their files fresh, install them again... same with styles maybe.. but that still leaves the "include_path" wrong lol

 

[Dan]

Sit tight and let the XenForo guru's make their way to this thread. I am sure Jake will be along shortly to figure this out.

 

[vVv]

Sit tight and let the XenForo guru's make their way to this thread. I am sure Jake will be along shortly to figure this out.

Yeah, will do and hopefully someone can figure it out haha. I still plan to remove the "Thread Thumbnails" and "Avatar for last poster" or whatever it is, cause that really slows down page loading too. Since I merged two different old copies of the site from before, into existing more recent one.. it's trying to query all those thread thumbnails and etc.. and i have tons and tons of sub forums... 33,xxx posts... 6,xxx threads.. 15,xxx users.. and it only slows down site when i'm trying to do moderation duties, removing duplicate threads... merges .. change post/thread authors.. etc etc. It's nightmare lmao... I might add those two resources back later though, once all the "clean up" is done.

 

[Jake Bunce]

That's a bug that affects XenForo forums running in debug mode on PHP 5.4:

http://xenforo.com/community/threads/php-5-4-bug.29835/

There is a fix posted in that thread. Or disable debug mode.

 

[vVv]

oh, okay... but doesn't turning off debug mode, just "hide" the error.. and the paths still need changed? I tried finding others issues on here, and some said about adding new "include_path" path in .htaccess. I guess I'm more concerned about the "include_path" issue... i disabled that "thread thumbnails" for now, to help speed up site.. Lol!

 

[Jake Bunce]

What path problem? I see no path problem.

Disabling debug mode avoids the error. The code fix in that thread fixes the error.

 

[vVv]

Illegal string offset 'thumbnailUrl' in /home/myuser/public_html/library/XenForo/Template/Abstract.php(529) : eval()'d code, line 2076:

should be:
Illegal string offset 'thumbnailUrl' in /home2/myuser/public_html/library/XenForo/Template/Abstract.php(529) : eval()'d code, line 2076:

in admin control panel > tools > phpInfo > "include_path" = home/myuser/public_html/library:.:.:/usr/lib/php:/usr/local/lib/php

 

[Jake Bunce]

The path is incidental to this error and has no relevance.

The path indicates the web site that you are accessing. Are you accessing the wrong site? The full server path is not specified anywhere in XenForo. It's not a XenForo problem.

 

[vVv]

ah okay, gotcha.. and I'm accessing the right site.. lmfao. But okay then..

 

[Mike Edge]

This only happened after he merged a old database/site with his current site. His old host uses /home we use /home2 I too am stumped on what is causing this as he said he fully uninstalled and re-installed his thumbnail add-on.

 

[vVv]

well, the thumbnail plugin is what made the site super slow for me, i disable it, and it's super fast for loading. i guess that's cause of the thousand threads and posts lol. but Borbole's "invalid users/ guest thread view limit" resource, is what prevented me from view members threads/posts from their member cards "message" thread and post count link.. it gave me white page.. well, it worked for members with messages less than 25 threads/posts to their names.. but anything higher than that.. gave me "white" page.. So disabling his plugin helped with that.

I did however, get a few more errors earlier in the day...This might have been when Mike restarted Mysql or whatever though..

ErrorException: unserialize(): Error at offset 93343 of 127818 bytes - library/XenForo/Model/NewsFeed.php:487
Generated By: tic01, Today at 6:51 PM
Stack Trace
 
#0 [internal function]: XenForo_Application::handlePhpError(8, 'unserialize(): ...', '/home2/myuser/...', 487, Array)
#1 /home2/myuser/public_html/library/XenForo/Model/NewsFeed.php(487): unserialize('a:15:{i:4023;a:...')
#2 /home2/myuser/public_html/library/XenForo/Model/NewsFeed.php(55): XenForo_Model_NewsFeed->getNewsFeedCache(17526)
#3 /home2/myuser/public_html/library/XenForo/ControllerPublic/Account.php(3049): XenForo_Model_NewsFeed->getNewsFeedForUser(Array, 0)
#4 /home2/myuser/public_html/library/XenForo/FrontController.php(619): XenForo_ControllerPublic_Account->actionNewsFeed()
#5 /home2/myuser/public_html/library/XenForo/FrontController.php(263): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#6 /home2/myuser/public_html/index.php(25): XenForo_FrontController->run()
#7 {main}
 
Request State
 
array(3) {
  ["url"] => string(38) "http://feetfotos.com/account/news-feed"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '346-2' for key 'definition_id_style_id' - library/Zend/Db/Statement/Mysqli.php:214
 
Generated By: vVv, Today at 6:36 PM
 
Stack Trace
 
#0 /home2/myuser/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
 
#1 /home2/myuser/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
 
#2 /home2/myuser/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_styl...', Array)
 
#3 /home2/myuser/public_html/library/XenForo/Model/StyleProperty.php(4565): Zend_Db_Adapter_Abstract->update('xf_style_proper...', Array, 'property_defini...')
 
#4 /home2/myuser/public_html/library/XenForo/Model/StyleProperty.php(4373): XenForo_Model_StyleProperty->importStylePropertiesFromArray(Array, Array, 0, 'XenForo')
 
#5 /home2/myuser/public_html/library/XenForo/Model/StyleProperty.php(4239): XenForo_Model_StyleProperty->importStylePropertyXml(Object(SimpleXMLElement), 0, 'XenForo')
 
#6 /home2/myuser/public_html/library/XenForo/CacheRebuilder/ImportMasterData.php(89): XenForo_Model_StyleProperty->importStylePropertyDevelopmentXml('/home2/myuser/...', 0)
 
#7 /home2/myuser/public_html/library/XenForo/ControllerHelper/CacheRebuild.php(51): XenForo_CacheRebuilder_ImportMasterData->rebuild(2, Array, ' .  .  . ')
 
#8 /home2/myuser/public_html/library/XenForo/Install/Controller/Upgrade.php(463): XenForo_ControllerHelper_CacheRebuild->rebuildCache(Array, 'index.php?upgra...', 'index.php?upgra...', true)
 
#9 /home2/myuser/public_html/library/XenForo/FrontController.php(619): XenForo_Install_Controller_Upgrade->actionRebuild()
 
#10 /home2/myuser/public_html/library/XenForo/FrontController.php(263): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
 
#11 /home2/myuser/public_html/install/index.php(35): XenForo_FrontController->run()
 
#12 {main}
 
Request State
 
array(3) {
 
  ["url"] => string(54) "http://feetfotos.com/install/index.php?upgrade/rebuild"
 
  ["_GET"] => array(1) {
 
    ["upgrade/rebuild"] => string(0) ""
 
  }
 
  ["_POST"] => array(8) {
 
    ["process"] => string(1) "1"
 
    ["caches"] => string(219) "[["ImportMasterData",{"root":"\/home\/myuser\/public_html\/install\/data"}],"Permission","ImportPhrase","Phrase","ImportTemplate","Template","ImportAdminTemplate","AdminTemplate","ImportEmailTemplate","EmailTemplate"]"
 
    ["position"] => string(1) "2"
 
    ["redirect"] => string(26) "index.php?upgrade/complete"
 
    ["_xfToken"] => string(53) "1,1357861000,75ad7c839858ad48a42540d1408d705912bbe73b"
 
    ["_xfRequestUri"] => string(34) "/install/index.php?upgrade/rebuild"
 
    ["_xfNoRedirect"] => string(1) "1"
 
    ["_xfResponseType"] => string(4) "json"
 
  }
 
}

notice reference to "/home/" again lol
["caches"] => string(219) "[["ImportMasterData",{"root":"\/home\/myuser\/public_html\/install\/data"}],"Permission","ImportPhrase","Phrase","ImportTemplate","Template","ImportAdminTemplate","AdminTemplate","ImportEmailTemplate","EmailTemplate"]"

 

[vVv]

FYI; I never said it was the host's fault, I actually said it was amazing...

Since moving to new Mike Edge's host, which is amazing actually,

I just figured, it was something from the merging of previous old sites, into current and recent copy of live site.. that might have gotten things wonky. A couple resources were needing reinstalled apparently, but yet with thousands of threads/posts some duplicates, same with forums/sub forums, it made some issues and lag, slow time too. But it's lightening fast now, no "issues".. since disabling those two plugins/resources.

I still encourage people to go with his hosting though, good reliable hosting that's fast and good, reasonably priced.

 

[Jake Bunce]

This only happened after he merged a old database/site with his current site.

Yeah he's having lots of problems with that. I disapproved of his plan but he did it anyways, and now he has many of the expected problems.

ErrorException: unserialize(): Error at offset 93343 of 127818 bytes - library/XenForo/Model/NewsFeed.php:487

...

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '346-2' for key 'definition_id_style_id' - library/Zend/Db/Statement/Mysqli.php:214

Those both indicate problems with your data. You can clear the news feed cache by running this query:

TRUNCATE TABLE xf_user_news_feed_cache;

That should fix the first error.

Is the second error still happening when you run the upgrade?

 

[vVv]

Yeah he's having lots of problems with that. I disapproved of his plan but he did it anyways, and now he has many of the expected problems.

There really wasn't that many problems though, except that php 5.4 bug that you pointed out, and I fixed that. And me assuming, or thinking.. the "includes_path" needed adjusted. The other "issues", were resource related.. because after merging, and having tons and tons of threads and nodes/sub nodes... .trying to query "thumbnails" in my many duplicate forums where images are posted in... Um yeah, it gonna take while to load and etc. Lol! The PHP bug or whatever, I fixed that.. So that's good.

Those both indicate problems with your data. You can clear the news feed cache by running this query:

TRUNCATE TABLE xf_user_news_feed_cache;

That should fix the first error.

Thanks, will try it. I didn't even get that myself actually, just happened to see server error logs lol.

Is the second error still happening when you run the upgrade?

Dunno, didn't run it again since.. Want me to try once more? Haha..