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

Re: Transfering hosts - HELP!

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

Ok, in phpbb_config default_lang is english.

And these files are in language/lang_english
lang_admin.php
lang_bbcode.php
lang_faq.php
lang_main.php
and 2 txt files.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66230
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Transfering hosts - HELP!

Post by Lumpy Burgertushie » Sat Aug 02, 2008 7:20 pm

using phpmyadmin, check the config table, look for "default_lang" and edit it.
put english in for the default.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

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

Re: Transfering hosts - HELP!

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

NickSButler wrote:Ok, in phpbb_config default_lang is english.

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 9:10 pm

NickSButler wrote:Ok, in phpbb_config default_lang is english.
I just want to make sure, it should be the 08news_config table.

Actually, it doesn't matter what default language is listed in the config table. phpBB is able to work around an incorrect value.

Exactly when did the error happen? Were you able to log in to the board?

Check that the language directory is in the phpBB root directory. In this directory also will be admin, includes and templates.

Look in the 08news_users table and make sure there is a user_lang column and english is set for the Anonymous user and for your user.
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 11:39 pm

D¡cky wrote:
NickSButler wrote:Ok, in phpbb_config default_lang is english.
I just want to make sure, it should be the 08news_config table.

Actually, it doesn't matter what default language is listed in the config table. phpBB is able to work around an incorrect value.

Exactly when did the error happen? Were you able to log in to the board?

Check that the language directory is in the phpBB root directory. In this directory also will be admin, includes and templates.

Look in the 08news_users table and make sure there is a user_lang column and english is set for the Anonymous user and for your user.
Image

Thats what I see for user_lang.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66230
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Transfering hosts - HELP!

Post by Lumpy Burgertushie » Sun Aug 03, 2008 1:06 am

what usually causes the previous error about the lang file is when there is no default set for the language in the config table.

it may not matter what language is there, but it must have one listed.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

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

Re: Transfering hosts - HELP!

Post by NickSButler » Sun Aug 03, 2008 1:13 am

I'm not sure I know what you mean.

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 » Sun Aug 03, 2008 1:27 am

NickSButler wrote:Thats what I see for user_lang.
That isn't what I meant. Browse the users table so that you see the list of users. Is a language listed for the Anonymous user?

You didn't answer my questions.
D¡cky wrote:Exactly when did the error happen? Were you able to log in to the board?
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 » Sun Aug 03, 2008 1:46 am

D¡cky wrote:
NickSButler wrote:Thats what I see for user_lang.
That isn't what I meant. Browse the users table so that you see the list of users. Is a language listed for the Anonymous user?

You didn't answer my questions.
D¡cky wrote:Exactly when did the error happen? Were you able to log in to the board?
After I fixed the session_logged_in error. (so in all, these errors have occured since the transfer of the database/forum).

And its set to english. Also, the usernames from the original forum aren't there... is that normal? I would guess not.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66230
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Transfering hosts - HELP!

Post by Lumpy Burgertushie » Sun Aug 03, 2008 2:00 am

no, that is not normal and that means that you are missing a lot more as well.

if you open up your database backup file in a text editor ( do NOT use anything but a real TEXT editor) and look at the end of the file, I bet you will see some html.

that means that your backup failed and is missiong about half of the tables.
'

if you can not get a better backup you will be out of luck.

rboert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

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

Re: Transfering hosts - HELP!

Post by NickSButler » Sun Aug 03, 2008 2:24 am

Ok, I'm going to attempt to re-upload the database, since I used bigdump (the file was way to big for PHPBBMyAdmin). Maybe I did something wrong.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50405
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Transfering hosts - HELP!

Post by stevemaury » Sun Aug 03, 2008 2:31 am

Before doing that, post the last 50 lines of the backup file here, using the code tags.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

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 » Sun Aug 03, 2008 2:45 am

There isn't much you can do wrong when importing with BigDump. Use Notepad++ or a similar text editor to open the backup file and look at the last few lines. If you are not sure what you are looking at, paste the last 25 or so lines here in code tags, or you can PM me with a link to the file and I can take a look.
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 » Sun Aug 03, 2008 2:51 am

I hope you mean the last 25 of the backup database.

Code: Select all

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274669', '17303', '1');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274670', '4081', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274671', '216548', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274671', '288', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '4922', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '47874', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '509', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '364', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '172', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '1083', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '257', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274672', '2435', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274673', '2724', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274673', '959', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '1210', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '24311', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '4053', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '288', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '75716', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '702', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '1232', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274674', '11547', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274675', '2077', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274675', '1659', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274675', '44507', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274676', '5202', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274676', '2567', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274676', '7475', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274679', '11225', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274679', '1094', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274680', '337', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274680', '4332', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274680', '102317', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274681', '17303', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274681', '22454', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274681', '813', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274681', '66', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274682', '3034', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274682', '4572', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274682', '14304', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274682', '609', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274682', '257', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274682', '31550', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274683', '319', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274684', '103253', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274684', '364', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274684', '164907', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274684', '337', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274684', '68121', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274684', '1340', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274685', '67022', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274685', '37790', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274685', '12203', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274685', '549', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274685', '4594', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274685', '4252', '0');
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('274685', '54405', '0');
#
# TABLE: phpbb_sessions
#
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/psthrunl/public_html/1-18-08news/forum/admin/admin_db_utilities.php:808) in <b>/home/psthrunl/public_html/1-18-08news/forum/admin/page_header_admin.php</b> on line <b>143</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/psthrunl/public_html/1-18-08news/forum/admin/admin_db_utilities.php:808) in <b>/home/psthrunl/public_html/1-18-08news/forum/admin/page_header_admin.php</b> on line <b>145</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/psthrunl/public_html/1-18-08news/forum/admin/admin_db_utilities.php:808) in <b>/home/psthrunl/public_html/1-18-08news/forum/admin/page_header_admin.php</b> on line <b>146</b><br />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"  />
<link rel="stylesheet" href="../templates/ClanzDarkness2/ClanzDarkness2.css" type="text/css">

<title>1-18-08News.com/Forum - </title>
</head>
<body bgcolor="#E5E5E5" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF">

<a name="top"></a>


<br /><br />

<table width="100%" cellpadding="4" cellspacing="1" border="0" class="forumline">
	<tr>
		<th class="thHead" align="center">General Error</th>
	</tr>
	<tr>
		<td class="row1" width="100%" align="center"><span class="gen">Failed in get_table_def (show fields)<br /><br /><b><u>DEBUG MODE</u></b><br /><br />SQL Error : 2006 MySQL server has gone away<br /><br />SHOW FIELDS FROM phpbb_sessions<br /><br />Line : 375<br />File : admin_db_utilities.php</span></td>
	</tr>
</table>

<br />
Now in the database, this information:

Code: Select all

<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/psthrunl/public_html/1-18-08news/forum/admin/admin_db_utilities.php:808) in <b>/home/psthrunl/public_html/1-18-08news/forum/admin/page_header_admin.php</b> on line <b>146</b><br />
Wouldnt be in the same directory that its listed there, do I actually have to change those to the directory its in now?

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 » Sun Aug 03, 2008 3:08 am

Your backup is incomplete. Those last few lines should not be there. This happens when using thhe phpBB backup utility in the Admin Panel on a large database.

You are missing some tables, like the topics table, the users table and a few others. Without these tables, the forum is not going to work. If you have access to the old database with phpMyAdmin, use it to create a new backup by exporting the tables
Have you hugged someone today?

Locked

Return to “2.0.x Support Forum”