UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Trouble upgrading to 6.2 from 6.1 on win2k

I tried running the altertable-6.1-6.2.php but it just keeps showing http://**testURL**/ubbthreads/altertable-6.1-6.2.php?step=step1 proceed to step 1.
When I click it it loads shortly and keeps showing "proceed to step 1".
I installed the 6.2 as a fresh install and it works.
The 6.1 on www.sat4all.com also runs on the same server without any problems.
The database I am trying to convert is about 140 megs of size.
Can someone tell me why altertable-6.1-6.2.php won't work or is it "support ticket time"?

Regards,

Ron

Do you have register_globals turned on or off? I think there may be a problem with the altertable when tregister_globals is off. If that's the case, try adding this line after the line that has main.inc.php in the altertable file:

$step = get_input("step","get");

If that fixes it, let me know so I can roll this into the normal release.

-------------------
Rick Baker
UBBThreads developer

Hi Rick,

register_globals = Off in PHP.ini so I added $step = get_input("step","get");
in line 23 so it looks like this now:

// Require the library
require ("main.inc.php");

$step = get_input("step","get");

ignore_user_abort(1);

if ($step) {
${$step()};
}

This fixes the/that problem, step 1 and 2 are working fine, BUT on step 3 I get a white page after a few seconds.
The URL is: http://***testurl****/ubbthreads/altertable-6.1-6.2.php?step=step3

It does not continiue any further.

Regards,

Ron

Update:

I have set the max execution time in php.ini to 999 to test it and now I get this error after a while:

Time-out van CGI
De opgegeven CGI-toepassing heeft de toegestane tijdsduur overschreden. De server heeft het proces verwijderd.

Which is Dutch for:

CGI timeout

The cgi-script has reached maximum execution time. the server has killed the process.

The 999 seconds have not been reached though.
Can you change the script so it will also handle larger databases on a win2k server (smaller steps) or is there something else I could do to fis this?

Thanks for your help,

Ron

As extra info:

The server load is extremely high during the time that step 3 is running so I guess it is actually altering the tables but can not finish before max. execution time.

Best Regards,

Ron.

How large an installation are we talking about here <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Rick can't add code to change the max execution time as that's controlled by the php.ini file. Perhaps we can try to write some guidelines but even then a quad-Xenon powered machine with oodles of RAM will tear through a giant database a great deal faster than a 450 PIII with little RAM running the same database <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

So - you may want to up the max execution time to 2000 or higher and see if that corrects the script timeout problems.

Regards,

Brett Harris
Infopop Corporation

I'm quit sure my 140 MB database (as mentioned above) was not running on altertable step 3 for longer that 16.5 minutes (999 seconds) so I guess this will not help much. (i'll try it anyway!)
What could help is rewriting the script so it will alter smaller portions and load the next step automaticly.
I don't know if this solves the problem but I am not an expert.
I have heard reports about a 400MB database that was able to convert on a linux based server so the problem is propably caused by something else.
That is why I get member area access and support from Infopop. Because that is where the experts are:-))

Regards,

Ron.

As you can see I managed to revive my original account:-)

I'm afraid I get the sime time-out when executing the script with php.ini max execution time set to 2000 seconds.

Regards,

Ron.

@Rick,

Did you have time yet to check out what could be the reason for my altertable problem (step 3)?
I have been trying the whole day yesterday but no luck.
I would really love to upgrade:-)

Regards,

Ron

Step 3 from me has occupied ~120 minutes and a database of 223 Mb.

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">
If that fixes it, let me know so I can roll this into the normal release.
</font><hr /></blockquote><font size="" face="">Thanks a lot...

Thank you, Igor - that's good to know!

Regards,

Brett Harris
Infopop Corporation

Well that is nice for you indeed and in fact it also partly worked for me.
It goes to step 2 and 3 but on step 3 it gets stuck!
All other scripts on this server (including the 6.1.1 version of ubbthreads) run just fine.
There is no point for me waiting for 2 hours because the scipt times out after a few minutes with the CGI timeout error.

Regards,

Ron.

I don't want to be pushy, but infopop told me last time I had a problem and posted this in the forums, I would be better off filing a support ticket, since those would be answered very quickly.

So I did in fact send in a support ticket and this say's:
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face=""> Someone will respond to your inquiry within three business
days.</font><hr /></blockquote><font size="" face="">I filed it the 2nd and now it's the 7th so I am starting to get al little impatient.
I don't mind waiting a little longer, but by now the the ticket has only been assigned. If someone would respond and tell me why it's takes a little longer to help or fix things it would be ok. But not like this.

There are many good free message boards around but I choose for Infopop’s UBBThreads because of the support.

Ron.

If anyone is in the UK and is having the same problem, I have access to a very fast server and have helped another out but converting his database for him, If you want to send me your DB on CD Ill return it upgraded for £2 or I could FTP it down and up at no cost.

Regards
Clint

That is nice of you but I think Infopop should fix the problem.
There is no reply's here and none to my support ticket wich was filed on the 2nd.:-(((
I will wait a few more days and after that no more Infopop for me.

Ron.

No official answer here, but I know that Rick has been really focussing all of his time and energy on tracking down and fixing the altertable bugs.

I know it's been his focus even before fixing other bugs.

Hopefully the result will be a smooth upgrade.

<img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

Sorry that you feel we have not replied in a timely manner - there are not always concrete answers to be had when it comes to running upgrades as there are simply so many variables to grapple with.

It's not that I don't feel infopop has not replied in a timely manner, but Infopop has not replied at all yet.
I can understand It might take longer then the promised 3 bussiness days, but it had been almost a week now without any answer.
Fact is, that my server has been set up in a standard way, windows 2000 server, IIS, PHP4.2 and MySQL 3.23.54 and it doesn't work.
I re-installed everything, tried another server with the same software but no go!
Since I pay for upgrades and support I feel I am entitled to be a bit worried to say the least.

Ron.

Rick has your ticket and I apologize for the delay - he is still investigating at this time. You are about as far up the technology pole as you can go <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Ron Can I suggest you try PHP 4.3 its seems a lot faster on my server !

Let me know how you get on..

Clint

Regards
Clint

That's a good one. I'll try that later today.

Rick has worked on the problem, but the new atltertable doesn't work for me eigther.
The script times out after some 6 or 7 minutes.

Ron.

I forgot to update this thread, sorry for that.

Rick has worked me thru the problem.
I seems the amount of PM's that needed processed during step 3 of the altertale was to large for my server to handle.
I deleted 17000 PM's and now it works.

Ron