bx_spy_data question

I'm getting annoyed :(  I change my whole website url from http://mysite.com/main TO http://mysite.com (without main)  and now all the spy links greetings, wall spys  etc etc are still pointing to http://mysite.com/main How can I change them all to http://www.mysite.com?

I exported bx_spy_data.. in text, i replaced all "http://.mysite.com/main" with "http://mysite.com"  automatically.  Here's one example

a:6:{s:12:"profile_link";s:34:"http://mysite.com/main/Patrick";s:12:"profile_nick";s:7:"Patrick";s:9:"entry_url";s:55:"http://mysite.com/main/m/photos/view/Mac-is-my-life";s:13:"entry_caption";s:15:"Mac is my life!";s:16:"recipient_p_link";s:34:"http://mysite.com/main/Patrick";s:16:"recipient_p_nick";s:7:"Patrick";}

TO

a:6:{s:12:"profile_link";s:34:"http://mysite.com/Patrick";s:12:"profile_nick";s:7:"Patrick";s:9:"entry_url";s:55:"http://mysite.com/m/photos/view/Mac-is-my-life";s:13:"entry_caption";s:15:"Mac is my life!";s:16:"recipient_p_link";s:34:"http://mysite.com/Patrick";s:16:"recipient_p_nick";s:7:"Patrick";}

I only edited those links and why i'm getting this error....

I added "/main" back and it worked great.  Am i miss something.  I did clear cache, tmp, and cache_public.  It just doesn't make sense.  :/

Did you change the url location and path in the header.inc.php file too?

yep i did.. in header.inc.php.. this is what i did

$site['url']               = "http://mysite.com/";

and path too.. if i didn't do this, i would see errors everywhere.  :P

True enough. Just making sure.

hmmmm...
And like you sed you cleared cache etc.

yeah I did hmmm thats one thing i don't understand.  How could this ruin the image and missing links. :x  something sensitive about bx_spy_data. :/

I need to try that for my site. See if it blows up too ;D

It would be good to know why.

Thanks man!  :D  It should be that simple but it's not. well... to me. ha  :/

I decided to export the entire database and replace ALL http://mysite.com/main WITH http://mysite.com

saved and imported it.  cleared all cache (including my browsers).  The website came on good but I still have the same issue. *pulling my hair out*  So if they're not in DB then where are they?

I just notice that all smilies in shoutbox aren't showing anymore. However smilies in simple messager are working  :S

bump!  Anyone?

you may not be hosting with Arvixe but i belive this is still relevent information. But please don't take any of these steps if you think it might put your site installation at risk.

http://blog.arvixe.com/move-dolphin-installation-to-public_html-2/

I apprecaite your respond womiweb. I don't have an issue with moving from one folder to another.  I got everything straighten up pretty good.  I just have an issue with spy thing.  I think it has to do with database.  :/

It's really simple... on my wall.. I see this

Patrick

commented Photo of Patrick

If I click Patrick, It will take me to http://mysite.com/main/Patrick    I just want to change the link to http://mysite.com/Patrick.  That's it. I've been struggling with this all day!!  I tried in bx_spy_data like you see up above. It just doesn't work. :/

Hi Patrick, I got your pm try this sql query to replace the string :

update bx_spy_data set params=replace(params,'http://mysite.com/main','http://mysite.com')

beleive it or not, that doesn't work either.  Unbelievable!!

bumpabompbomp

I fixed it but it requires to write a script  to do the job, I'll give an idea what are the values all about :

when you see this example : s:34:"http://mysite.com/main/Patrick"

it means :

s = string

s:34 = the lengh of the string which is 34 characters -- http://mysite.com/main/Patrick

so if you change the string you need to change also the lengh value

Thanks for that.

patrick81 machead guy - please let us know if it works for you. Thanks bro :D