Internal Server Error while importing posts

[tobsel88]

Hello,

I always got an 500 Server Error when I try to import the posts from the IPBoard. (About 70.000 posts). In the VBulletin Database all posts are imported.Then the reload an the error.

Is there any solution?

I also increased the php values but it didnt help.

EDIT: I deleted posts with more than 50k chars. The largest post has about 37k chars

[tobsel88]

Is there any help? I wasnt able to solve the problem until now

[Wayne Luke]

You need to look at your server logs to find out what the error is. Either your httpd or php error logs should contain the error. Without that, there really isn't much to go on. Internal Server Error is vague and applied to many different issues.

[tobsel88]

These 2 errors are in the log file:

[Wed Mar 13 19:07:10 2013] [warn] [client my ip] mod_fcgid: read data timeout in 45 seconds, referer: http://www.mydomain.de/impex/index.php

	[Wed Mar 13 19:07:10 2013] [error] [client my ip] Premature end of script headers: index.php, referer: http://www.mydomain.de/impex/index.php

I already deleted:



pp.notes (Line 703, 000.php) because otherwise I got another error and the import doesnt start
Also I changed TYPE=MyISAM to ENGINE=MyISAM (line 271, index.php )

[tobsel88]

In the Web I found this:

http://rickchristie.com/blog/2011/note/apache-mod_fcgid-read-data-timeout-error/

So I tried to reproduce the error with the following php script:

<?php

    echo 'go<br />';

    $sleep = 120;

    echo $sleep . ' sleep<br />';

    sleep($sleep);

    echo 'finished<br />';

    ?>

Same problem So I need to increase theese values. But the next problem ist that I don´t know how to do this.

(Ubuntu + Plesk 11)

[tobsel88]

In the Web I found this:

http://rickchristie.com/blog/2011/note/apache-mod_fcgid-read-data-timeout-error/

So I tried to reproduce the error with the following php script:

<?php

    echo 'go<br />';

    $sleep = 120;

    echo $sleep . ' sleep<br />';

    sleep($sleep);

    echo 'finished<br />';

    ?>

Same problem So I need to increase theese values. But the next problem ist that I don´t know how to do this.

(Ubuntu + Plesk 11)

[tobsel88]

In the Web I found this:

http://rickchristie.com/blog/2011/note/apache-mod_fcgid-read-data-timeout-error/

So I tried to reproduce the error with the following php script:

<?php

	echo 'go<br />';


	$sleep = 120;


	echo $sleep . ' sleep<br />';


	sleep($sleep);


	echo 'finished<br />';


	?>

Same problem So I need to increase theese values. But the next problem ist that I don´t know how to do this.

(Ubuntu + Plesk 11)

[tobsel88]

In the Web I found this:

http://rickchristie.com/blog/2011/note/apache-mod_fcgid-read-data-timeout-error/

So I tried to reproduce the error with the following php script:

<?php

	echo 'go<br />';


	$sleep = 120;


	echo $sleep . ' sleep<br />';


	sleep($sleep);


	echo 'finished<br />';


	?>

Same problem So I need to increase theese values. But the next problem ist that I dont know how to do this.

(Ubuntu + Plesk 11)

[BirdOPrey5]

If you're on a shared host you may need to contact your host to increase the timeout value.

[tobsel88]

I increased the value now but now I get "Bad Gateway" there isnt any information in the log. Do you know anything to solve the problem?

[BirdOPrey5]

Do you have any type of caching enabled?

502 Errors Explained: http://www.checkupdown.com/status/E502.html

[tobsel88]

Well now I "rebuilded" the cache of everything and the posts appeared. But I am not able to import the other stuff like pm´s or polls because when i try to open /impex/index.php the error appears. Is there any way to imports PMs whithout import Users?

[Trevor Hannant]

No, PMs need to be associated with users otherwise how will the software know whose PM is whose...

[tobsel88]

The users are already imported. The error appears while importing the posts. When i try to open /impex/index.php i couldnt import the pms because the error appears again. I have to delete the session and posts ... via help.php