FUDforum: FUDforum Installation Issues » Problems Importing 2.3.2 Datadump

Home » FUDforum » FUDforum Installation Issues » Problems Importing 2.3.2 Datadump

Show: Today's Messages :: Polls :: Message Navigator

Problems Importing 2.3.2 Datadump [message #18601]

Sun, 30 May 2004 05:47

Wipeout667

Messages: 6
Registered: May 2004

Karma: 0

Junior Member

Hello everyone,

I had a message board set up a while back using version 2.3.2 that eventually had to be moved.

I've installed 2.3.2 on another server, but when I try to import the .gz datadump file, nothing happens. I point the import script in the control panel to the file, click 'Import Data', and it sends me back to admimport.php with the navigation on the left and no information whatsoever on the right.

Can anyone help? We've recently had a member pass away and many people would like to retrieve the PMs sent by this user.

Thank you very much!

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18603 is a reply to message #18601]

Sun, 30 May 2004 17:36

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Does your new server have zlib extension enabled for PHP?

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18607 is a reply to message #18603]

Sun, 30 May 2004 18:23

Wipeout667

Messages: 6
Registered: May 2004

Karma: 0

Junior Member

phpinfo shows:

zlib
ZLib Support enabled
Compiled Version 1.2.1
Linked Version 1.2.1

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

I appreciate any assistance you can provide.

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18613 is a reply to message #18607]

Mon, 31 May 2004 13:27

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Hmm when you get the white page does your browser appear to be doing anything? The import process is quite slow and if you have output buffering enabled it could be quite a while before you see any messages.

Also check your forum's & php's error log files to see if any errors can be found there.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18616 is a reply to message #18613]

Mon, 31 May 2004 16:59

Wipeout667

Messages: 6
Registered: May 2004

Karma: 0

Junior Member

It doesn't appear that it's doing anything because the second screen appears almost immediately (with no apparent activity forthcoming).

Checked and there is nothing at all in the Error or Action logs.

Other things I've tried:
- Relocating the .gz file to various other directories (web root, etc)
- Unzipping and trying to import the .fud file (same result).

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18617 is a reply to message #18616]

Mon, 31 May 2004 18:14

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

If the old forum is still active it would be a good idea to upgrade that forum to 2.6.3 and the make a dump of that and import it into new 2.6.3 install. The code base you are using is quite old and I am not entirely sure what could be wrong with it.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18618 is a reply to message #18617]

Mon, 31 May 2004 18:35

Wipeout667

Messages: 6
Registered: May 2004

Karma: 0

Junior Member

Unfortunately the old boards are no longer up (server was wiped quite some time ago). Any other ideas on things I could try? I could care less about themes and such at this point... I'd just like to get the users & messages back.

Thank you.

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18619 is a reply to message #18618]

Mon, 31 May 2004 18:43

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Does your server have PHP's memory_limit enabled?
How big is the datadump file?

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18620 is a reply to message #18619]

Mon, 31 May 2004 19:00

Wipeout667

Messages: 6
Registered: May 2004

Karma: 0

Junior Member

PHP Info shows: memory_limit 40M 40M

Unfortunately, I can't change these parameters as they are set by the host.

The file is 19,727,818 bytes gzipped and 83,120,013 bytes unzipped.

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18621 is a reply to message #18620]

Mon, 31 May 2004 19:06

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Hmmm it is likely that the problem is due to the script hitting the memory limit. To determine if that is the case turn on php's error logging facility and make it write the errors to some file you can later check.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18633 is a reply to message #18621]

Tue, 01 June 2004 01:03

Wipeout667

Messages: 6
Registered: May 2004

Karma: 0

Junior Member

Pardon my ignorance, as I don't have much experience with PHP, but how would I enable PHP error logging when I can't change php.ini as it's controlled by the hosting facility?

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #18636 is a reply to message #18633]

Tue, 01 June 2004 01:41

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

If you are using PHP/Apache (not PHP-CGI) then you can usually put .htaccess file that would set various options

php_value error_log "/path/to/log_file/"
php_flag log_errors 1

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21900 is a reply to message #18601]

Mon, 27 December 2004 21:02

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

I'm moving on another hosting!
But there's a huge problems! I can't make a datadump to save my forum!

The server says http 500 error

I was trying to use Gzip and not using still the same !

here's info sys to display server info:

PHP built On: FreeBSD server29.donhost.co.uk 4.8-STABLE FreeBSD 4.8-STABLE #5: Fri Mar i386
Database Version: 3.23.54-log
PHP Version: 4.3.10
Web Server: Apache/1.3.28 (Unix)
WebServer to PHP interface: cgi
Forum Version: 2.6.9
Relavent PHP Settings: Safe Mode: OFF
Open basedir: none
Display Errors: ON
File Uploads: ON
Magic Quotes: ON
Register Globals: ON
Output Buffering: Yes
Disabled Functions: none
Tokenizer Support: Yes
PSpell Support: No
Zlib Support: Yes

Is there any other way to save data and import them to another hoster !
Domain name will be kept!

Or could anyone help me with that?

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21903 is a reply to message #21900]

Mon, 27 December 2004 21:22

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Dump the data from mysql manually and make an archive of all the forum directories. Then decompress this data on the server, import database data and modify GLOBALS.php to reflect the new paths & database settings.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21908 is a reply to message #21903]

Tue, 28 December 2004 13:31

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Quote:

Dump the data from mysql manually and make an archive of all the forum directories. Then decompress this data on the server, import database data and modify GLOBALS.php to reflect the new paths & database settings.

You mean save .sql file import that file to another hosting
to local sql server!?

Then I should compress all data and decompress to local host!
That's clear!

One more thing when I making dump the forum dumps some data in tmp dir! My forums weghts about 24M
The output file after dumping with Gzip ~ 1.8M
Whithout ~ 9M

Is that enought to import these files to another hoster ? with http 500 error!

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21924 is a reply to message #21908]

Tue, 28 December 2004 21:49

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

When I refered to mysql dump I was talking about making one manually via mysqldump or phpmyadmin.

It sounds to me like the automated dump tool is being terminated before it has a chance to complete. Non-the-less you can certainly try importing the dump on to a fresh forum.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21928 is a reply to message #21924]

Wed, 29 December 2004 13:47

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Yes I know about that but this hosting old like an earth!
The cp panel doesen't have php admin!

I dumped sql data in sql file !

But the data base weghts ~ 4.1 M
Now in sql file only ~ 1.21 M is that OK?
I'm not strong in sql Sad

Sad

I will try to impord half of that data in fud dump!

I was talking with my hoster and he said I dont know:( f.... Sad

Sad

the process terminate dumping process with that error!

Is there any possible ways to deal with that kind of situation?

Maybe I got something wrong any advice would be great!

What kind of problem with that error and how to deal with it doe's anybody got a clue?

[Updated on: Wed, 29 December 2004 15:25]

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21935 is a reply to message #21903]

Tue, 04 January 2005 16:38

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Quote:

Dump the data from mysql manually and make an archive of all the forum directories. Then decompress this data on the server, import database data and modify GLOBALS.php to reflect the new paths & database settings.

I did that thing! But the The requested file globals.php should be in +include+ folder bud the forum requests globals.php
in +forum+ folder! In my old forum in +forum+ directory globals.php exists but this is not a file some kind of pointer!

Then I put globals.php in +forum+ dir and everething whent smoose!

Is that ok or I did something wrong!

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21945 is a reply to message #21935]

Tue, 04 January 2005 19:56

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The GLOBALS.php inside forum's main dir and adm dir are symlinks to the original file inside the include directory.

if you do not have shell access you can rebuild theme using the symlink() PHP function described here:
http://ca3.php.net/symlink

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21954 is a reply to message #21945]

Tue, 04 January 2005 21:20

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Quote:

The GLOBALS.php inside forum's main dir and adm dir are symlinks to the original file inside the include directory.

if you do not have shell access you can rebuild theme using the symlink() PHP function described here:
http://ca3.php.net/symlink

Ok! This fine!

One more quest

A got an old forum! Phpbb
I got a sql dump from that forum!

What kind of tricks should I use?

The main problem I got only one database on sql server available!

Would it be possible to restore forum and use two forums on
one sql server!

the possible ways to restore sql dump for phpbb then convert
it to Fud forum
but would it be possible to run two forums on one sql server
What about mixing tables ?

Any kind of ideas would be great!

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21955 is a reply to message #21954]

Tue, 04 January 2005 21:21

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

All fudforum tables have a prefix you specified, which means it is not going to conflict with anything else asuming you pick a different table prefix for that application.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21956 is a reply to message #21955]

Tue, 04 January 2005 21:29

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

If I got it right!

I will change prefix for an old forum tables for phpbb!

But I should Install a new forum or I can use the same one ?

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #21958 is a reply to message #21956]

Tue, 04 January 2005 21:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

you can use the one running now.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22049 is a reply to message #21958]

Tue, 11 January 2005 12:55

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Finally I moved to another hoster!
Before that was temp dom created such as ~domain but now everething moved to my ordinary domain www.domain.com

I moved all my data to a new goster like you said!
Restored dutadump of sql!

The forum works but I could'n log in in to the forum?
It shows the main page after i loggin in?

Any Idias? Or I did some mistekes?

I checked GLOBALS.PHP all is good I think!

Everething works exept loggin into the forum!

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22062 is a reply to message #22049]

Tue, 11 January 2005 23:04

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Did the forum's location & domain change? if so you need to update the GLOBALS.php with proper cookie & url.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22075 is a reply to message #22062]

Wed, 12 January 2005 16:03

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Quote:

Did the forum's location & domain change? if so you need to update the GLOBALS.php with proper cookie & url.

The domain's the same nothing changed!
The ways I changed take a look!

<?php
$FORUM_TITLE = "************";
$DISABLED_REASON = "Undergoing maintenance, please come back later.";
$WWW_ROOT = "http://www.domain.com";
$CUSTOM_AVATAR_MAX_SIZE = 10000;
$CUSTOM_AVATAR_MAX_DIM = "64x64";
$COOKIE_PATH = "/home2/domain/public_html/forum/";
$COOKIE_TIMEOUT = 604800;
$SESSION_TIMEOUT = 1800;
$COOKIE_DOMAIN = ".domain.com";
$COOKIE_NAME = "fud_session_1096497967";//here???
$DBHOST = "localhost";
$DBHOST_USER = "domain";
$DBHOST_PASSWORD = "********";
$DBHOST_DBNAME = "domain_";
$DBHOST_TBL_PREFIX = "fud26_";
$FUD_SMTP_SERVER = "";
$FUD_SMTP_TIMEOUT = 10;
$FUD_SMTP_LOGIN = "";
$FUD_SMTP_PASS = "";
$PRIVATE_ATTACHMENTS = 3;
$PRIVATE_ATTACH_SIZE = 300000;
$MAX_PMSG_FLDR_SIZE = 50000;
$FORUM_IMG_CNT_SIG = 2;
$FORUM_SIG_ML = 256;
$ADMIN_EMAIL = "domain(at)yandex(dot)ru";
$POSTS_PER_PAGE = 40;
$THREADS_PER_PAGE = 40;
$WORD_WRAP = 60;
$FLOOD_CHECK_TIME = 600;
$SERVER_TZ = "Europe/Minsk";
$MEMBERS_PER_PAGE = 40;
$THREAD_MSG_PAGER = 5;
$GENERAL_PAGER_COUNT = 15;
$EDIT_TIME_LIMIT = 0;
$LOGEDIN_TIMEOUT = 5;
$MAX_IMAGE_COUNT = 10;
$NOTIFY_FROM = "domain(at)yandex(dot)ru";
$ANON_NICK = "Anonymous Coward";
$MAX_LOGIN_SHOW = 25;
$MAX_LOCATION_SHOW = 25;
$UNCONF_USER_EXPIRY = 10;
$MOVED_THR_PTR_EXPIRY = 3;
$DATA_DIR = "/home2/domain/public_html/FUDforum/";
$WWW_ROOT_DISK = "/home2/domain/public_html/forum/";
$SHOW_N_MODS = 2;
$MAX_SMILIES_SHOWN = 15;
$POLLS_PER_PAGE = 40;
$TREE_THREADS_MAX_DEPTH = 15;
$TREE_THREADS_MAX_SUBJ_LEN = 75;
$REG_TIME_LIMIT = -1;
$SEARCH_CACHE_EXPIRY = 172800;
$STATS_CACHE_AGE = 600;
$POST_ICONS_PER_ROW = 9;
$MAX_LOGGEDIN_USERS = 25;
$PHP_COMPRESSION_LEVEL = 9;
$MNAV_MAX_DATE = 31;
$MNAV_MAX_LEN = 256;
$RDF_AUTH_ID = 0;
$RDF_MAX_N_RESULTS = 100;
$PDF_PAGE = "letter";
$PDF_WMARGIN = 15;
$PDF_HMARGIN = 15;
$PDF_MAX_CPU = 60;
$FUD_OPT_2 = 695676991;
$FUD_OPT_1 = 1202648255;
$FUD_OPT_3 = 288;
$INCLUDE = "/home2/domain/public_html/FUDforum/include/";
$ERROR_PATH = "/home2/domain/public_html/FUDforum/errors/";
$MSG_STORE_DIR = "/home2/domain/public_html/FUDforum/messages/";
$TMP = "/home2/domain/public_html/FUDforum/tmp/";
$FILE_STORE = "/home2/domain/public_html/FUDforum/files/";
$FORUM_SETTINGS_PATH = "/home2/domain/public_html/FUDforum/cache/";
require($INCLUDE.'core.inc');
?>

Or should I install a new forum then change the sql prefix in Globals?
Will that work?

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22078 is a reply to message #22075]

Wed, 12 January 2005 17:31

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Actually what you should try, is upgrading it to 2.6.10.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22081 is a reply to message #22078]

Wed, 12 January 2005 18:30

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Quote:

Actually what you should try, is upgrading it to 2.6.10.

?????

2.6.10 - ????
The latiest release 2.6.9 ?

Or I can find something ??? PM url or the way I can find It or Should I wait till the next release!?

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22082 is a reply to message #22081]

Wed, 12 January 2005 19:26

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Err sorry, I ment 2.6.9

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22101 is a reply to message #22082]

Sat, 15 January 2005 00:29

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Ok I finally logged In:) But now there's onother problems
Sinse I changed the hoster the pass for domain was changed!

Now while restoring archive back up the chmod for all directories had changed

When I'm trying to do some staff It's write :

Warning: fopen(/home2/domain/public_html/FUDforum/messages/msg_1): failed to open stream: Permission denied in /home2/domain/public_html/forum/theme/default/post.php on line 1797

Or another actions the same!Forum does'n have permissions to change write ... When I tried to upgrade from 2.6.9 to 2.6.9
That was the same problems permisions is low!

Is there any globals to change my permissions or I should change
admin pass for a hosting pass but this the way I don't want to do so!

Any Idias!

One more question! If I create the dir with anought eccess and make a dump of the forum thanks god now I can do that
then install the new one and import old one with those bad permissions and other staff Wil that work?

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22107 is a reply to message #22101]

Sat, 15 January 2005 16:04

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Mode Owner Group Size Date Time Name Action
drwxrwxrwx- (777) domain domain 4 KB Jan 15 10:43:37 . chmod download delete
drwxr-x---- (750) domain nobody 12 KB Jan 15 10:46:24 .. n/a download n/a
-rwx--x--x- (711) nobody nobody 4 KB Jan 15 09:53:56 adm chmod download delete
-rwx--x--x- (711) nobody nobody 4 KB Jan 15 09:53:56 images chmod download delete
-rwx------- (700) nobody nobody 4 KB Jan 15 09:58:14 theme chmod download delete

Tell me how it can be while installing new forum
the owner for some dirs or files could be nobody?????

Doesn't have a clue at all Sad

Sad

Now I can't access for some reason this files under owner priveleges!

Any Idias ?

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22134 is a reply to message #22107]

Mon, 17 January 2005 15:19

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Here is the thing, the files created by the forum are created as the Apache user (nobody) because that is who PHP runs as. So you need to make sure that this account has access to all forum files. So if you are getting permissions errors, chmod the affected files/directories 777 via FTP or SSH.

FUDforum Core Developer

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22140 is a reply to message #22134]

Mon, 17 January 2005 18:19

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Quote:

Here is the thing, the files created by the forum are created as the Apache user (nobody) because that is who PHP runs as. So you need to make sure that this account has access to all forum files. So if you are getting permissions errors, chmod the affected files/directories 777 via FTP or SSH.

Yes I now than now! But try to understand all the files needs to be changed that took huge amount of time! Before I dont know about that after several attemts while upgrading again like you said to 2.6.9 again I was told by installation script that I can't do that can't do that Ok I started changing all permissions!
That took about 3 hours And stiil huge amounts of files left
But then what about security mesures changing that Is not the point! I become so careful After previous hucking 2 times of my forums (phpbb)
Thats peased me off thats why I choosed yours now I think this is the right choose ! Smile

Smile

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22148 is a reply to message #22140]

Mon, 17 January 2005 18:44

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

You can change the mode of all files with a single command (using the -R recursive flag):

chmod -R 777 TopFUDForumDir

The same applies to user and group names:

chown -R nobody.nobody TopFUDForumDir

Best regards.

Frank

Report message to a moderator

Re: Problems Importing 2.3.2 Datadump [message #22189 is a reply to message #22148]

Wed, 19 January 2005 11:58

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Now finally forum works properly!

special Thanks to Ilia and Frank Smile

Smile

Report message to a moderator

Previous Topic:	Problems with install on version 2.6.9
Next Topic:	error ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 01:31:30 GMT 2024

Total time taken to generate the page: 0.03113 seconds