[SMF Converter] XMB - 1.9.8

[SleePy]

Are you using the convert.php in Updated Converters List & Support Topics

[PatrickPriest]

i am using whatever file is downloaded when at this page:
http://www.simplemachines.org/download/?converters

[SleePy]

Try the one that is attached in that topic. I don't know, but it may be possible that the convert.php in that download might have broken code which is not preventing the error from occurring.

[PatrickPriest]

should it take forever for the 1st step to go?  i am using the updated convert.php  i clicked on "Continue" and it's just been "Loading" for about 5 minutes now.

[SleePy]

It should be continuing with a timeout page.

Do you have phpMyAdmin to see what queries it is running? It just might be it is able to bypass the apache timeout and is trying to do it all in one shot.

[PatrickPriest]

I have phpMyAdmin... but not quite sure how to get into all that.

[SleePy]

There is a process list link on the front page usually. This will show what processes are running in mysql (if any).

[PatrickPriest]

found it.  what am i looking for after clicking on it?

[SleePy]

What queries are running?

I just wanted to see if maybe the converter is handling a large query at the moment.
It could be possible it is getting caught in a loop somewhere :| Though I hope not.

[PatrickPriest]

nothing i think

[SleePy]

Yea, there was nothing running.

Is it the tab that says it can't load page?
Does anything appear to be converted?

[PatrickPriest]

Yes it is that tab.  However, I also clicked that link several times before taking the screen cap... and it always gave the same response.

I did do a convert JUST the members... and it seems it converted all the members.

The forums I am converting are HUGE:
7633 topics / 498311 posts / 12579 members

[SleePy]

Hmm,

Yea thats almost a large forum (only a few posts off 500k).
You might have to do this via command line or by section.

Apache is like a middle man, You have to talk to it, and it talks to php (who is also talking to mysql), and then it has to respond to Apache to respond to you.
By doing command line you remove the middle man and without that middle man the timeout is less of an issue.

command line can be used by using ssh to the server and just doing
"php -f /path/to/convert.php"

It will tell you about missing parameters. Those will need to be specified for the conversion.

[PatrickPriest]

i know nothing about SSH

[PatrickPriest]

i tried connecting using SSH... but for some reason it's not connecting. i will try it again tomorrow at work.  i know i've used it a few times there with the forums.  but only for backing up and restoring a database... anything else SSH related i know nothing about.

[SleePy]

Not to be mean, but if you got a large site as yours is and will continue to be, you should get to know a little about such stuff. A GUI isn't always the best way to administer things when you got resources you need to dedicate towards other things such as apache, mysql, or php.

Good luck trying though, its a little hard to get used to a first, but once you play with it enough it will get easy. I personally use it all the time between my macs to do even the simplist things such as making a directory/folder on it to as complicated as running software updates (I am a bit lazy, so walking down stairs to perform updates takes more energy than it would to easily do it via remote desktop or ssh).

[PatrickPriest]

yeah i know.  i have a guy that works on the staff that is pretty good with php and stuff.  he is teaching me some things.  but between his schedule and mine... its hard to have "classes".  but i am slowly learning.

i will try it and let you know what happens.

[PatrickPriest]

I am at work now with a lot faster speed internet.  I do the convert... and I get the:
Converting members... Incomplete.

Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

The "Continue (0)" button stays at (0)... do I have to keep hitting "Continue" all the time to make it continue the convert?

[SleePy]

Do you have javascript enabled?
If javascript is enabled it should do a count down from 3 and then auto click continue.

[PatrickPriest]

Yes... Java is enabled.  However, it did look like it was still refreshing... just the countdown wasn't moving.

But... there is another issue now... hahaha

In the convert file... I choose ONLY the "Boards" to be converted.  However... when I clicked continue... it said "Converting members... Incomplete."

I didn't ask for it to convert the members.  But... I let it do it's thing for about an hour... and nothing changed.  It was still doing that about an hour later.