Settings disappear after change from IP to domain name

[njprrogers]

Hi,

I've set up my s2member installation and got my wordpress up and running on my IP address.

Using SQL I have changed occurrences of my ip address htttp:\\444.44.44.44 to www.myaddress.com.

When I do this and upload the resulting SQL, my s2member settings disappear although the site is functional.

What should I do?

Thanks!

Nick

[Cristián Lávaque]

Did you update every instance of your address in the database? Also, if that is in a serialized array, you'll need to update the string's length too.

[njprrogers]

Hi Cristian,

Thanks for the reply!

I have done a global search / replace to change the string from the IP address to the domain name.

I'm not too sure about serialized arrays though... does s2member serialize the domain before storing it in the database? Would it even be possible for me to find this in SQL output if it did?

What tables / records should I be looking at?

Thanks!

Nick

[njprrogers]

Hi Christian,

Just as an added suggestion, it's nothing to do with the security encryption or anything like that? The domain is not used?

Thanks,

Nick

[njprrogers]

Resolved! Serialized arrays were the cause of the issue.

thanks again for your help.

[Cristián Lávaque]

Thanks for reporting back! I'm very glad you solved it.