Forums

Moved database, home page goes to login now

Permalink
I've moved (synchronized from phpmysqladmin) my c5 database to a new server. I updated my config/site.php settings to point to new server. Everything works great, except I can no longer browse anonymously, and admin is the only user that has access.

In Sitewide Settings/Access, it has Viewing Permissions set to Public

Please advise, need to move mysql off of localhost.

Thanks in advance
gene
McPadawan
 
Mnkras replied on at Permalink Reply
Mnkras
make sure maintenance mode is off
McPadawan replied on at Permalink Reply
McPadawan
Thanks, checked that and both databases show Maintenance Mode disabled (from the web)

stumped...
McPadawan replied on at Permalink Best Answer Reply
McPadawan
Turns out it was something in the way I moved the database that caused it. Was able to reproduce with another project also. Looks like some fields that were null originally became non null, just empty, and some were even zeroes.

Removed the db, did a straight data dump and imported to the new database, and things now work just as expected.

Thanks for anyone that looked at this.