Icy Phoenix

Old Support Topics - Problem On Trasfer Server

greekpc [ Fri 27 Apr, 2007 21:33 ]
Post subject: Problem On Trasfer Server

Hello !

I try to move my domain on a new webhosting server, but after when i restore files and database, when i try to access my website i get this error page:

Critical Error!
message_die() was called multiple times.
Error #1
Unable to access the Users Table.

Error #2
Error doing DB query userdata row fetch

Line : 472
File : /home/greekpcc/public_html/forum/includes/sessions.php
SQL : SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_ip = '57cb3a37' AND s.session_user_id = -1 AND u.user_id = s.session_user_id LIMIT 0, 1
Please, contact the webmaster. Thank you.

Any help ?

greekpc [ Sat 28 Apr, 2007 08:24 ]
Post subject: Re: Problem On Trasfer Server

Please help me anybody ?

jz [ Sat 28 Apr, 2007 08:51 ]
Post subject: Re: Problem On Trasfer Server

reload your user_table from the back up

greekpc [ Sat 28 Apr, 2007 08:59 ]
Post subject: Re: Problem On Trasfer Server

jz wrote: [View Post]
reload your user_table from the back up

Please help me more. How can i do that ?

jz [ Sat 28 Apr, 2007 09:02 ]
Post subject: Re: Problem On Trasfer Server

How did you move your database to the new server?

you can use phpMyAdmin and reload your users_table.

greekpc [ Sat 28 Apr, 2007 09:08 ]
Post subject: Re: Problem On Trasfer Server

jz wrote: [View Post]
How did you move your database to the new server?

you can use phpMyAdmin and reload your users_table.

I have go on CPANEL | BACKUP | and then restore the database.

If i go to restore from phpMyAdmin i can't because is accept only 51KB and my database is about 800KB and i get error timeout message if i try to restore from there.

What i would do now ?

jz [ Sat 28 Apr, 2007 09:18 ]
Post subject: Re: Problem On Trasfer Server

simply split your databse, and upload it into smaller chunks.

open your db backup file and look for something like;

Code: [Hide] [Select]

## `phpbb_users`

CREATE TABLE `phpbb_users` (

  `user_id` mediumint(8) NOT NULL default '0',

greekpc [ Sat 28 Apr, 2007 12:23 ]
Post subject: Re: Problem On Trasfer Server

Nothing i have upload, but i get the same error page

pepi [ Sat 28 Apr, 2007 13:41 ]
Post subject: Re: Problem On Trasfer Server

Hi

I think you must edit the server_name = yoursite in your db
in phpbb_config with phpMyAdmin

Pepi

greekpc [ Sat 28 Apr, 2007 13:59 ]
Post subject: Re: Problem On Trasfer Server

pepi wrote: [View Post]
Hi

I think you must edit the server_name = yoursite in your db
in phpbb_config with phpMyAdmin

Pepi

I try it. Sorry nothing

Mighty Gorgon [ Tue 01 May, 2007 19:44 ]
Post subject: Re: Problem On Trasfer Server

Your DB is not either configured properly or have no datas... try to check via phpMyAdmin.