Transfering hosts - HELP!

NickSButler · 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

D¡cky · 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.

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

-- topic moved from "[2.0.x] Convertors" to "[2.0.x] Support".

NickSButler · 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 · 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 · 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 · 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 · 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 · 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)

D¡cky · 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

NickSButler · 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

D¡cky · 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

NickSButler · 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

D¡cky · 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.

janmyszkier · 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