Thread

Hiya,

Well I managed to break my EE installation… basically I renamed the domain to a new one, then changed all the paths to match, then tracked down all the references to the old domain in the database and changed them to match the new domain…

Before I edited the database, I could still login to the CP, although it was doing some weird things, like saying I didnt have permission to do anything..

Basically I am left with the following login page: http://andy.net.nz/cp/index.php

And this error when I try and login:

The username you submitted was not found in the database

I’ve checked, and my standard admin account is still listed in the member table…

I ‘thought’ it would be a simple process of changing all the references to the old domain, but looks like Im gonna lose a few hours sleep over this :(

If someone can help me troubleshoot this, it would be greatly appreciated… unfortunately, because I am running MSM, all my sites are down…

This is the error I get when I try and login from one of my other sites (note: I changed the domain paths to suit in the path.php too)

Notice: unserialize() [function.unserialize]: Error at offset 400 of 3448 bytes in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Notice: unserialize() [function.unserialize]: Error at offset 571 of 1865 bytes in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php on line 129

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.prefs.php:129) in /var/www/vhosts/andy.net.nz/httpdocs/cp/core/core.functions.php on line 726
  ExpressionEngine  v 1.6.3

Site preferences are stored in a serialized array, so doing a find/replace in your database will break those arrays unless the new information is the same length of characters.  I’m afraid you will need to restore your database prior to your making these changes manually, and then update these preferences directly in the control panel.

Thanks for the prompt reply Derek.

Unfortunately I reverted the database back, but still have the same issue, Ive definately screwed something up, prolly in the config or path settings. Im thinking my best bet is to export my database, reinstall EE from scratch and reimport into the database the sites etc I think…

Ok, that fixed it.

Basically I dumped the old database.

Reinstalled EE from scratch on the new domain, then imported only the field, template and weblog tables so that I retained all my sites from the previous install.

Worked like a charm, thanks.

Glad you’re up and running, Andy!