UBB.Developers Forums UBB.threads 7 Development How Do I? Importing the Database

Hmm close-160 rows affected by query but not fixed

can I include wildcards since the avatar urls looks kinda like this?

http://emeraldforestseattle.com/attachments/79039-th_9.jpg

UPDATE w3t_Users
SET U_Picture = REPLACE(U_Picture, 'emeraldforestseattle.com/*','emeraldforestseattle.nuclearfallout.net/*');

or somthing like that?

N/M it worked fine-I just need to refresh the cached Entrance Page-THANKYOU EVERYONE

okay so the old one is

http://emeraldforestseattle.com/attachments/79039-th_9.jpg

and the new one is

http://emeraldforestseattle.nuclearfallout.net/attachments/79039-th_9.jpg

so you would have to put this

UPDATE w3t_Users
SET U_Picture = REPLACE(U_Picture, 'emeraldforestseattle.com','emeraldforestseattle.nuclearfallout.net');

need to know exactly what the old path says and what the new path says

Ok I will let this thread die out soon but one more question here. The links on my Entrance page wont work it says No Input File Specified. Is this something wrong I did when I installed IIP.


http://emeraldforestseattle.nuclearfallout.net

Have you got spider friendly urls turned on for your forums?

The frontpage appears to be using them, but the forums are not - hence the problems.

I think you will find alternative 'non spider friendly' files in the installation files.

yeah make sure you are using the nonspider ones cause

http://emeraldforestseattle.nuclearfallout.net/ubbthreads/showflat.php?Cat=0&Number=79895

works for you but

http://emeraldforestseattle.nuclearfallout.net/ubbthreads/showflat.php/Cat/0/Number/79895

doesn't...

So if I enabled spider friendly in the control panel is their also a spot in IIP as well or only one location. I tried enabling it in UBBTHreads then my Main Index link stopped working as well

If the spider friendly pages fail in threads then they will also fail for the IIP. By default IIP is spider friendly, so you will need to user the non-spider friendly files.

Have a search for spider on these forums, you might pick up one or two tips to get yours working (not sure if you are on on your own server or not). I know that mine initially failed, but I made a change to the server and all was well (that fix is posted somewhere, can't dig it out at the mo)

I just re-read this thread again and was comparing how I felt at the time (frustrated) and how I am feeling now and I wanted to thank all of you one more time