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"?
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
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?
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.
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.
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:-))
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:-)
</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...
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.
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.
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.
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.
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.
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" />
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.