[SMF Converter] Yabb - 2.1

[Njones]

Ok,.. I'm completly clueless at this,.. no point pretending otherwise!
Trying to convert my YaBB2.1 forum at hxxp:www.fermoycleaning.com/forum [nonactive] to my new instalation of SMF at hxxp:www.fermoycleaning.com/smf [nonactive] and I get the following errors:

Warning: file(/home/fermoycl/public_html/forum/Paths.pl): failed to open stream: Permission denied in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 77

Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 80

Notice: Undefined index: boardsdir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92

Notice: Undefined index: datadir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92

Notice: Undefined index: memberdir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92

Notice: Undefined index: sourcedir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92

Notice: Undefined index: vardir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92

Notice: Undefined index: facesdir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92

Notice: Undefined index: uploaddir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92

Warning: file(/Settings.pl): failed to open stream: No such file or directory in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 99

Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 100
Converting membergroups...
Warning: file(/membergroups.txt): failed to open stream: No such file or directory in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 121

Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 122
Successful.
Converting members...
Fatal error: Call to undefined function: altertable() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 197

I haven't a clue what it all means!
How do I fix it?
I need a real "For dummies" guide on this one!!!

[JayBachatero]

Are you using the most recent convert.php?

[Njones]

think so,... tried 2 of em!!
Could you e-mail me the latest one pls?
[email protected]

[JayBachatero]

It's attached in the first post.  Also can you link me to the phpinfo.php file.
What is phpinfo.php?

[Njones]

Yep, used the one attached to the first post.
Here;s the link:

hxxp:www.fermoycleaning.com/phpinfo.php [nonactive]

Appreciate the help Jay!

[JayBachatero]

Ok phpinfo looks good.  Make sure that you overwrite the convert.php.  From the looks of it you have an old convert.php since it doesn't have the alterTable() function.

[madkeen]

I managed to get the conversion past the Memebers section that it was stopping on with errors. Now the problem is that it keeps stalling when converting the post about every 10000. I have to hit teh stop button on teh browser and then click on continue and it seems to be working again. Well, at least the count in the URL increases every 90 seconds or so. I am hoping it is doing its thing.

With 460000 posts though it will take days to do this and there will be another 1000 posts per day added to teh boards so the new one will be a few days out.

Is it possible to run teh script on the server in a shell rather than in teh browser?

Would be a lot quicker and less painful

I am desperate to convert my board but just not having much luck in doing it

[Njones]

Converting...

Warning: file(/home/fermoycl/public_html/forum/Paths.pl): failed to open stream: Permission denied in /home/fermoycl/public_html/yabb21_to_smf.php on line 77

Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/yabb21_to_smf.php on line 80

Notice: Undefined index: boardsdir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92

Notice: Undefined index: datadir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92

Notice: Undefined index: memberdir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92

Notice: Undefined index: sourcedir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92

Notice: Undefined index: vardir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92

Notice: Undefined index: facesdir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92

Notice: Undefined index: uploaddir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92

Warning: file(/Settings.pl): failed to open stream: No such file or directory in /home/fermoycl/public_html/yabb21_to_smf.php on line 99

Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/yabb21_to_smf.php on line 100
Converting membergroups...
Warning: file(/membergroups.txt): failed to open stream: No such file or directory in /home/fermoycl/public_html/yabb21_to_smf.php on line 121

Used the files on th e first post of this thread, and got this message:

Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/yabb21_to_smf.php on line 122
Successful.
Converting members...
Fatal error: Call to a member function on a non-object in /home/fermoycl/public_html/yabb21_to_smf.php on line 247

[madkeen]

I managed to get past a few errors by clicking the back button and then cicking on continue.

But it has stopped again and gives me the following error

Converting...
Converting topics (part 2)... Unsuccessful!
This query:

    ALTER TABLE `ausfish_forums`.smf_log_topics
    ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
    DROP COLUMN tempID;

Caused the error:

    Duplicate entry '20052-3438' for key 1



I have clicked on he Try Again button but just gives teh same error. I have also tried ccking on the back buton then the continue button but get the same error.

Can anyone help out how to get past this?

The URL is the same everytme it gets to this error - convert.php?step=1&substep=50800&cstep=8&start=0

[JayBachatero]

madkeen there is no way to run this via shell.  I was thinking of looking into adding support for it but I don't know much about CLI.  I'll see what I can come up with.

Njones seems like your host has open_basedir enabled.  I suggest that you convert your board locally.

[madkeen]

Thanks Jay

Very much appreciate your time and effort

[Njones]

Cheers Jay,
How do I convert it locally?
Sorry to be so clueless!!!

[Sir_Trout]

I assume that you would go to your web site and run the convert.php so,

http://www.yourwebsite.com/smf/convert.php

and follow the simple instructions.

If you have smf installed at that location.

-ST

[madkeen]

Yes, that is correct. You will also need to have the yabb21_to_smf.php file in that location.

[nysthul]

Hi.. I am trying to use your latest conversion scripts and get this error displayed.  Admittedly I haven't read through the whole thread on this yet.. but didn't find anything quickly using the search option on the board.

any ideas on what to do? Thanks!!

Code Select Expand


Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories...
Notice: Undefined index: Tests in /home/savageg/public_html/judb/forum/yabb21_to_smf.php on line 706
Unsuccessful!
This query:

    ALTER TABLE `savageg_smf1`.smf_moderators
    ADD PRIMARY KEY (ID_BOARD, ID_MEMBER);

Caused the error:

    Duplicate entry '5-886' for key 1

[nysthul]

Well I did some poking around and decided it was related to conversion of the moderator settings and so I removed all the mod assignments (some forums had more than one mod in the list that was comma seperated and I think that was killing it.) and now the script ran till it hit this error:

Code Select Expand


Converting topics (part 2)... Unsuccessful!
This query:

    ALTER TABLE `savageg_smf1`.smf_log_topics
    ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
    DROP COLUMN tempID;

Caused the error:

    Duplicate entry '327-1331' for key 1


Looks like there is something in there that is duplicated or that it doesn't like.. any ideas?  could it be moved topics? I don't know!

[nysthul]

Okay well with some painful poking around I determined that YaBB had created some duplicate .log .vars .rlog files for users in the Members directory with different case for the username in the files..

example
bob.vars
Bob.vars

These were for the same user, just had different time stamps.. this caused the database to be populated twice with thread / post links that caused the error I was getting.  I went in and deleted the older of the files for each of the 9 users that had this issue and the conversion completed.

Maybe there is a way in the script to detect this in the future and generate a meaningful error that the user is duplicated and to remove the files?

[JayBachatero]

Well it's hard to detect that really.  Cause what it does it uses all lowercase username on conversion.

[nysthul]

Well, could it detect which file is newer and ignore the duplicates?  im not an SQL guru and it took me quite a while to figure out which users were duplicated and fix the files.

Thanks!

[naitram]

i just ran the latest convertor today, and ran into a couple of problems

Converting...
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `smf`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:

Duplicate entry '164-479' for key 1




and the import polls piece acted strange,

before i "tweaked" the import script it had populated over 1.2 million rows into smf_log_polls

on line 1749   if ($_GET['substep'] < 0)  the substep was always 0 everytime the page refreshed

also imported attachments dont seem to display in the post, only give a download link. may not be a convertor issue

thanks for any help you can offer