Transfering hosts - HELP!

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
NickSButler
Registered User
Posts: 17
Joined: Fri Aug 01, 2008 2:20 pm

Transfering hosts - HELP!

Post by NickSButler » Sat Aug 02, 2008 1:47 am

I was switching hosts and I encountered this problem.
phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'aladygma_08forum.phpbb_users' doesn't exist

SELECT * FROM phpbb_users WHERE user_id = -1

Line : 136
File : sessions.php
I followed these instructions:
http://www.phpbb.com/kb/article/moving- ... hpmyadmin/

And the forum is PHPBB 2

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Transfering hosts - HELP!

Post by D¡cky » Sat Aug 02, 2008 3:21 am

The instructions you pointed to are for phpBB3, but the instructions for moving are basically the same.

The users table may be missing because of a faulty import or a faulty backup. Browse your database with phpMyAdmin and see if the users table does exist.
Have you hugged someone today?

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Transfering hosts - HELP!

Post by ric323 » Sat Aug 02, 2008 4:30 am

-- topic moved from "[2.0.x] Convertors" to "[2.0.x] Support".
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

NickSButler
Registered User
Posts: 17
Joined: Fri Aug 01, 2008 2:20 pm

Re: Transfering hosts - HELP!

Post by NickSButler » Sat Aug 02, 2008 1:07 pm

I fixed the user part, but now this is happening:

http://www.1-18-08news.com/forum2/

janmyszkier
Registered User
Posts: 294
Joined: Tue Oct 09, 2007 4:53 pm

Re: Transfering hosts - HELP!

Post by janmyszkier » Sat Aug 02, 2008 1:22 pm

something in the database is still missing, check your tables for 'session_logged_in' column seems it is missing,
haven't you just moved your database to new script and host ?

NickSButler
Registered User
Posts: 17
Joined: Fri Aug 01, 2008 2:20 pm

Re: Transfering hosts - HELP!

Post by NickSButler » Sat Aug 02, 2008 1:46 pm

janmyszkier wrote:something in the database is still missing, check your tables for 'session_logged_in' column seems it is missing,
haven't you just moved your database to new script and host ?
I didn't own the website before. The previous owner sent me the database and the forum directory files. Although, we both had the same registar.

And I don't see sessions_logged_in.

janmyszkier
Registered User
Posts: 294
Joined: Tue Oct 09, 2007 4:53 pm

Re: Transfering hosts - HELP!

Post by janmyszkier » Sat Aug 02, 2008 2:17 pm

are you sure you have the exact same version of phpbb you had in previous host? I think it's important since script was designed for certain database too. If your old forum is still somewhere there check what version of phpbb it has, then install the same version on your new host
(i advise copying all the forum files from old host to new host and changing the config file)

NickSButler
Registered User
Posts: 17
Joined: Fri Aug 01, 2008 2:20 pm

Re: Transfering hosts - HELP!

Post by NickSButler » Sat Aug 02, 2008 2:21 pm

janmyszkier wrote:are you sure you have the exact same version of phpbb you had in previous host? I think it's important since script was designed for certain database too. If your old forum is still somewhere there check what version of phpbb it has, then install the same version on your new host
(i advise copying all the forum files from old host to new host and changing the config file)
I did copy all the old files and changed the config, this is what happened.

janmyszkier
Registered User
Posts: 294
Joined: Tue Oct 09, 2007 4:53 pm

Re: Transfering hosts - HELP!

Post by janmyszkier » Sat Aug 02, 2008 2:45 pm

now i remember i recieved this kind of error when my phpbb couldn't connect to database (bad config file).
I had host move several days back. Try to figure config out. if not i may be able to help you over icq(257701007)

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Transfering hosts - HELP!

Post by D¡cky » Sat Aug 02, 2008 3:22 pm

You are either connecting to the wrong database or your database is corrupt.

You can add the session_logged_in field by entering this query in phpMyAdmin

Code: Select all

ALTER TABLE 08news_sessions ADD COLUMN session_logged_in tinyint(1) DEFAULT '0' NOT NULL
Have you hugged someone today?

NickSButler
Registered User
Posts: 17
Joined: Fri Aug 01, 2008 2:20 pm

Re: Transfering hosts - HELP!

Post by NickSButler » Sat Aug 02, 2008 4:00 pm

After trying to add it, I got this.

I must be doing something wrong.
SQL query: Documentation

SELECT `08news_sessions` . *
FROM 08news_sessions
WHERE (
`08news_sessions` . *
ALTER TABLE 08news_sessions ADD COLUMN session_logged_in tinyint( 1 ) DEFAULT '0' NOT NULL
) LIMIT 0 ,
30

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* ALTER TABLE 08news_sessions ADD CoLUMN session_logged_in tinyint(1) DEFAULT '0' at line 3

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Transfering hosts - HELP!

Post by D¡cky » Sat Aug 02, 2008 4:37 pm

What version of MySQL are you using?
How did you enter the query?

Executing SQL Queries in phpMyAdmin

Open phpMyAdmin
Select your database. Your tables should now be showing on the right side.
Click the SQL tab at the top of the page
Enter the query into the "Run SQL query/queries on database" window
Click Go
Have you hugged someone today?

NickSButler
Registered User
Posts: 17
Joined: Fri Aug 01, 2008 2:20 pm

Re: Transfering hosts - HELP!

Post by NickSButler » Sat Aug 02, 2008 6:10 pm

ok, now I got this error:
phpBB : Critical Error

Could not locate valid language pack

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Transfering hosts - HELP!

Post by D¡cky » Sat Aug 02, 2008 6:19 pm

If your board uses English, you need to have a language/lang_english directory with some files in there, particularly lang_main.php to start with.

Then check the phpbb_config table and see the the default_language is set to english.
Have you hugged someone today?

janmyszkier
Registered User
Posts: 294
Joined: Tue Oct 09, 2007 4:53 pm

Re: Transfering hosts - HELP!

Post by janmyszkier » Sat Aug 02, 2008 6:29 pm

in my opinion, for his own good he should reinstall the forum (not via copy but via install) and import all important database data via phpmyadmin, for now it looks like his forum is installed the wrong way, and scripts will have a lot of errors

Locked

Return to “2.0.x Support Forum”