Icy Phoenix

Old Support Topics - Quick Question About Changing Db Server

Vortex [ Thu 25 Jan, 2007 20:01 ]
Post subject: Quick Question About Changing Db Server

I have to move my database to a different database server. It is enough to change infos in config.php and config_xs.php, right?

brandsrus [ Thu 25 Jan, 2007 20:14 ]
Post subject: Re: Quick Question About Changing Db Server

Yes, you must changes the files what you have said no more

Vortex [ Thu 25 Jan, 2007 20:24 ]
Post subject: Re: Quick Question About Changing Db Server

Just wanted to be sure...

Thanks a lot

Vortex [ Tue 30 Jan, 2007 13:33 ]
Post subject: Re: Quick Question About Changing Db Server

Uhm...

Quote:
Critical Error

Error: Seek Help

DEBUG MODE

SQL Error : 1048 Column 'login_id' cannot be null

INSERT INTO phpbb_logins (login_id, login_userid, login_ip, login_user_agent, login_time) VALUES (NULL, -1, '97254ab6', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9', 1170160267)

Line : 227
File : sessions.php

How could this be related to? I imported the new database, than changed config e and config_xs ...

Mighty Gorgon [ Wed 31 Jan, 2007 03:05 ]
Post subject: Re: Quick Question About Changing Db Server

If you are moving only the DB you have to change only config.php... nothing else.

The error is not related to config... try to empty sessions table.

Vortex [ Mon 05 Feb, 2007 13:48 ]
Post subject: Re: Quick Question About Changing Db Server

Ok, clearing sessions table wasn't necessary... it was a corrupted backup

Can you please explain to me why it is not necessary to change config_xs.php? I don't understand... I changed db address, doesn't it become useless if don't don't update it?

Mighty Gorgon [ Mon 12 Feb, 2007 02:27 ]
Post subject: Re: Quick Question About Changing Db Server

Vortex wrote: [View Post]
Can you please explain to me why it is not necessary to change config_xs.php? I don't understand... I changed db address, doesn't it become useless if don't don't update it?

config_xs.php is not part of XS... I don't know why you have that file...

Vortex [ Mon 12 Feb, 2007 08:31 ]
Post subject: Re: Quick Question About Changing Db Server

Ah... interesting

Well, thanks for help anyway