CGI error when converting 2.0.22 to phpBB3 RC1

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
simonfletcher2003
Registered User
Posts: 7
Joined: Sun Aug 06, 2006 5:57 pm

CGI error when converting 2.0.22 to phpBB3 RC1

Post by simonfletcher2003 »

When upgrading to phpBB3 I get the error when converting to phpBB 3 RC1...
CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers.
I am running phpBB 2.0.22, IIS 6.0, PHP 4.3.4 and Microsoft SQL Server 2005 Express.

The conversion process appears to be ok for around 3-4 minutes then causes this error. I have tried adding
set_time_limit(40);
to the install_convert.php file, this made no difference.

I suspect this is a timeout problem, is there any log files kept anywhere during the conversion process?

Thanks

User avatar
nickenyfiken
Registered User
Posts: 68
Joined: Sun Jan 30, 2005 9:00 pm
Location: Sweden

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by nickenyfiken »

Hi, do also get a CGI error message after a few min. I am using iis 5.1
CGI Timeout
The specified CGI application exceeded the allowed time for processing. The server has deleted the process.

Does anyone have a clue on how to solve these CGI errors, any hints are appreciated.

Regards
NN

simonfletcher2003
Registered User
Posts: 7
Joined: Sun Aug 06, 2006 5:57 pm

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by simonfletcher2003 »

I increased the timeout value to 3000 seconds by editing the CGITimeout value in the IIS metabase. However the problem remains, it just takes 10 times longer to get there now.

I am now getting this error now...
CGI Timeout The specified CGI application exceeded the allowed time for processing. The server has deleted the process.
After checking the number of rows in both prefix_posts tables, it doesn't seem to progress beyond around 200 of the 2500 posts, if I have the timeout at 300 seconds or 3000. Also during this time, the database filesize doesn't grow and php.exe is using 100% of the CPU.

It seems to be getting stuck in a loop until the timeout expires, has anyone any idea what might be causing this?

Thanks

User avatar
nickenyfiken
Registered User
Posts: 68
Joined: Sun Jan 30, 2005 9:00 pm
Location: Sweden

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by nickenyfiken »

simonfletcher2003 wrote:I increased the timeout value to 3000 seconds by editing the CGITimeout value in the IIS metabase. However the problem remains, it just takes 10 times longer to get there now.
I also tried using a metabase editor to increase the cgi timeout value, didnt work for me either.

Regards
NN

edorf
Registered User
Posts: 10
Joined: Fri May 25, 2007 9:38 am

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by edorf »

I've got the same problem, more or less...
http://www.phpbb.com/community/viewtopi ... 8&t=548603

Any ideas ?

simonfletcher2003
Registered User
Posts: 7
Joined: Sun Aug 06, 2006 5:57 pm

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by simonfletcher2003 »

I have realised that it keeps getting to the same post each time that it appears to get stuck. So I started trying to convert from a test copy of the phpBB2 forum (so as not to affect the live forum). I looked at the last post to be upgraded successfully in the phpBB3 DB, then looked in the copied phpBB2 DB and found the post with the next post ID and deleted it from the copied phpBB2 DB. I then restarted the conversion and it continued past this post until it got stuck at other post. I had to repeat this about 10 times but it finally converted.

I'm not sure exactly what has caused it yet, but its something common between these posts. I'm going to have a look through them to see if I can figure out what it is.

User avatar
nickenyfiken
Registered User
Posts: 68
Joined: Sun Jan 30, 2005 9:00 pm
Location: Sweden

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by nickenyfiken »

Hi,
how wonderful that you have found the cause.
It would really be nice to know exactly what in those posts it is that makes it go over and over again.

Could you post some of the faulty posts here?

Is there any way to se in realtime what operation mysql is doing?

I think that it fails in the conversion of the Topics.

Regards
NN

edorf
Registered User
Posts: 10
Joined: Fri May 25, 2007 9:38 am

1 Solution to: CGI error when converting 2.0.22 to phpBB3 RC

Post by edorf »

Ok, I think I might have an answer here..

It seams that the converter stalls when the post_text in the post_text table in 2.x exceeds size of 4096.

I ran the sql command "select datalength(post_text) from phpbb_posts_text order by 1 desc", I don't remember the exact sql right now, since I'm not on my computer, but I'll edit this post later. You get the point.

Anyway, when I removed the rows exceeding length of 4096 in both post and posts_text table the converte ran just fine.

Hope someone else can tll me why the converter does not handle posts larger than 4096.

Have a great weekend !

simonfletcher2003
Registered User
Posts: 7
Joined: Sun Aug 06, 2006 5:57 pm

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by simonfletcher2003 »

I agree, all the posts that stall my conversion are over 4096 characters too.

edorf
Registered User
Posts: 10
Joined: Fri May 25, 2007 9:38 am

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by edorf »

I might have the solution here...

The php.ini file in my c:\windows dir keeps all the settings for php.
Since I run my phpBB in IIS and MSSql over odbc I discovered that the setting
odbc.defaultlrl = 4096
Change this to:
odbc.defaultlrl = 16M

If you're still running MSSql, but not over odbc, locate there settings in the php.ini file:
mssql.textlimit = 4096
mssql.textsize = 4096

And change them to:
mssql.textlimit = 64M
mssql.textsize = 64M


Ok,.. I think that's it...

User avatar
nickenyfiken
Registered User
Posts: 68
Joined: Sun Jan 30, 2005 9:00 pm
Location: Sweden

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by nickenyfiken »

Im running mysql, and there is no settings like the ones for mssql i the php.ini file.
Anyone else but me that is running mysql and getting this error?

Regards
[NN]

simonfletcher2003
Registered User
Posts: 7
Joined: Sun Aug 06, 2006 5:57 pm

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by simonfletcher2003 »

I tried changing the odbc setting to 100000, this worked for me, thanks Edorf.

Nickenyfiken, I'm afraid i'm using MSSQL too, I have no idea what may need to be changed for this to work for MySQL.

User avatar
nickenyfiken
Registered User
Posts: 68
Joined: Sun Jan 30, 2005 9:00 pm
Location: Sweden

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by nickenyfiken »

Thanks to edorf i came to think that maybe it was something with my php version, and it was. I upgraded from version 4.4.1 to 5.2.3 and then the conversion completed on the first try.

Thanks alot for all the help guys, and especially you edorf.

Regards
The happy camper
[NN]

User avatar
TraXy
Registered User
Posts: 46
Joined: Sat Feb 12, 2005 11:46 pm
Location: Nottingham
Contact:

Re: CGI error when converting 2.0.22 to phpBB3 RC1

Post by TraXy »

All very well if you're running it on your own server. If you're running it off a web hosting company where you can't edit or even access php.ini... then what do you do?

Tried deleting all the posts over 4096 in length but it still just shows a blank screen when it's trying to convert. Never had this problem when trying to convert the same forum to the B5 release. Didn't have a problem at all then.
Last edited by TraXy on Mon Jun 18, 2007 1:36 pm, edited 2 times in total.

User avatar
TraXy
Registered User
Posts: 46
Joined: Sat Feb 12, 2005 11:46 pm
Location: Nottingham
Contact:

Re: 1 Solution to: CGI error when converting 2.0.22 to phpBB3 RC

Post by TraXy »

edorf wrote:I ran the sql command "select datalength(post_text) from phpbb_posts_text order by 1 desc", I don't remember the exact sql right now, since I'm not on my computer, but I'll edit this post later. You get the point.
select * from phpbb_posts_text where length(post_text) > 4096;

Locked

Return to “[3.0.x] Support Forum”