Hi, I would really appriciate any help you can think of!
I have a YaBB 1.3.1 board that I want to become an SMF forum.
I installed a YaBBSE forum in a new directory, that is up and working.
I downloaded the converter yabb2yabbse_1-5 and ran that.
I gave the converted all of my information, it did a ton of stuff and converted several things, but I think it gets stuck somewhere on the messages. Here is the last thing it prints:
QuoteWe are now going to attempt to convert your message files. This may take a while.
Initializing member data for processing
Importing sticky topic data
Importing Categories
Inserting Categories
Inserting row 1 to 4
Data inserted successfully!
Importing Boards
Inserting Boards
Inserting row 1 to 9
Data inserted successfully!
Importing 'mark as read' data
Inserting 'mark as read' data
Inserting row 1 to 71
Data inserted successfully!
Importing Board Logs
Inserting Board Logs
Inserting row 1 to 500
Data inserted successfully!
Inserting row 501 to 825
Data inserted successfully!
Importing Topics
Then that is all it is done, there are no links or buttons on the converted page. So I go back to my main forum page and see it added the new catagories, and all of the original members, but there are no messages.
My original forum had about 7000 topics.
Any ideas what might be wrong?
Also once this does work and I have a fully functional YabbSE, I have the SMF upgrade I believe I need, do I install that inside of the same directory as the YaBBSE and "upgrade" that, or do I put all the new files inside of a new directory and it does like the Yabb converter, you tell it where the YabbSE stuff it?
The forum I am trying to convert to is here:
http://myphotos.aboutbeanies.com/chat/index.php
Any help would be great thank you!
-Marie
After adding some debug to the converter script I can tell it stops before it prints "test111"
echo 'test1';
if (!checkFile($_REQUEST['boardsdir'] . '/' . $boardname . '.txt'))
continue;
echo 'test11';
$boardFile = file($_REQUEST['boardsdir'] . '/' . $boardname . '.txt');
echo 'test111';
I don't know anything about php, is it possible to turn on more debug in a script?
UPDATE Well I tried running the script again after adding more debug and this time it didn't even get as far, only got to the " Initializing member data for processing" line this time. hmmmmm
-Marie
When you converted to yabbse did you go to version 1.5.X? If so were all the members and messages there?
Are you sure the converter had finnished running?
Welp nothing yet, it appears to have "finished" the browser stopped but that was it.
Im trying to convert this Yabb 1.3.1 (all the members are here)
This is just a copy of my active forum without any mods, just members, messages and boards from my active forum.
http://myphotos.aboutbeanies.com/chatold/YaBB.cgi
to this YabbSE 1.5.5
http://myphotos.aboutbeanies.com/chat/
...back to try something else!
thanx!
--Marie
If you arent already, try this converter http://www.yabbse.org/community/index.php?thread=27367
Yup that is the one I am using. Can be run from here:
http://myphotos.aboutbeanies.com/chat/yabb2yabbse.php
Install directory
/export/vhosts/myphotos.aboutbeanies.com/chatold
Current YabbSE dir
/export/vhosts/myphotos.aboutbeanies.com/chat
-Marie
Hi, if your forum is large, it can take a good 10-15 minutes or more for it to import all of the messages, I had 30,000 posts on my board, and I was worried that it had stopped, but I left it, and it did import. How long did you leave it?
hmm I left it like 10 minutes, just in case, but the browser stop within 30 seconds of starting.
I want SMF!!!!! ;)
-Marie
If you have a large board, it may be an idea to install a webserver on your local pc and download your board and do the conversion there.
Thats how I did my gold > se conversion all those years back.
Anyone know if there is a manual way to finish where the script left off? Load the database another way? Nothing seems to get it past that point, my old forum was about 7000 posts doesn't seem to to large.
I have direct access to the server, I just don't know enough about mysql and php yet.
hmmm....
anymore thoughts or ideas??? :(
-Marie
Do you know what the memory limits and timeout settings are in php.ini?
Have you tried repairing your YaBB database?
-[Unknown]
I downloaded and uploaded a 44mb yabbse on 40k dialup (although I don't recommend it as a past time :D)
What I did ..
in PHPMYADMIN I looked at the dB and noted the large tables, they were messages and topics.
I downloaded the big files first individually (gzip)
Then downloaded the rest as one unit. (gzip)
I found that if I uploaded (gzipped) SQL textfiles over 2.5 MB it would "time-out" so I broke the tables down into 2.5 mb chunks and uploaded them individually.
The only thing to remember is that if you break down "e.g _messages" into 4 chunks .. the 1st chunk will create a table so has to be done as an SQL command in the main DB
The subsequent "chunks" are only "insert" so do not create a table so must be done in the newly created table.
Don't know if this will help or not :-\
About GZIP .. if you're not sure how to do this I highly recommend the free software HERE (http://www.7-zip.org/) Just remember to zip files as gzip not 7-zip. I'm sure the guys here will know of better but it's been great to me.
I remember a small problem with converting yabb gold --> yabbse --> smf.
I'm not sure in which face of the process, but it's a problem with the sorting of the posts. After the upgrading all the posts are stored in database and displayed in SMF in exactly the other way sorting.
I remember it excists a script that solves the problem, but I can't find it any more.
Any help on that?
Quote from: krizz on August 31, 2004, 05:29:22 AM
I remember a small problem with converting yabb gold --> yabbse --> smf.
I'm not sure in which face of the process, but it's a problem with the sorting of the posts. After the upgrading all the posts are stored in database and displayed in SMF in exactly the other way sorting.
I remember it excists a script that solves the problem, but I can't find it any more.
Any help on that?
This only happens if you use an older converter. I have an updated converter on the forum at yabbse.org which is much preferred, and does not have such bugs in it.
-[Unknown]
You are correct! I tried it and it works fine!
thanks
Hello! :)
I try to convert my YaBB Gold 1.3.1 to YaBBSE, but I find out, that all [ quote author=XXXXX link=YYYY date=ZZZZ]... [ /quote] qoutes will convert to [ quote]... [ /quote] and DELETE all information about links to another postings, threads and boards! :(
Converter:
$messageinfo[8] = preg_replace('/\[ quote (.+?)]/i', '[ quote]', $messageinfo[8]);
Can you help me please!!!!!!
Thanx a lot in advance! :)
Its a but in RC1, it will be fixed in RC2.
Quote from: Ben_S on September 22, 2004, 08:15:20 AM
Its a but in RC1, it will be fixed in RC2.
Hello Ben,
what do you mean with RC2: Release Candidate of SMF or RC of Converter from YaBB Gold to SMF? I have troubles with qoutes in converter from Yabb Gold to SMF - all qoutes will be delete!!!
Hmm... at the least, the author should be kept.
-[Unknown]
$messageinfo[8] = preg_replace('/\[quote (.+?)]/i', '[quote][/quote]', $messageinfo[8]);
Will change:
[ quote author=hannover link=topic=11459.msg140391#msg140391 date=1095844672 ]
To:
[ quote ]
This is not that big a loss, and the actual quoted content should remain. However, the author could be kept, like so:
$messageinfo[8] = preg_replace('/\[quote (author=[^ ]+?)(.+?)]/i', '[quote $1]', $messageinfo[8]);
-[Unknown]
Quote from: Ben_S on September 22, 2004, 08:15:20 AM
Its a but in RC1, it will be fixed in RC2.
RC2 is available now, but I can't see some direct YaBB Gold to SMF converters or some changes in old converters from YaBB Gold :(.
The change has been made in the bbc parsing.
-[Unknown]
Quote from: [Unknown] on October 12, 2004, 07:10:01 PM
The change has been made in the bbc parsing.
-[Unknown]
I know, ehat do You mean, but it's not the bbc problem only! In exist converter you can parse in bbc the author, but you must remember all boards and topic ID's! In YaBB you have boardname and topicname (like timestamp). I look for converter, what convert all quotes correctly(!) - I mean with all links with NEW (YaBBSE/SMF-Format) links of old topics and boards!
The second thing is - I look for DIRECT converter (from YaBB Gold to SMF)! :)
It's possible to write direct converter (I can take some development costs ... if it's can accelerate the development process ;) )
I'm still working on it... it may take some time.
-[Unknown]
Quote from: [Unknown] on October 13, 2004, 05:02:49 PM
I'm still working on it... it may take some time.
-[Unknown]
Thanks a lot for your great work!!!! :))))
Dear [Unknown],
can I ask you about time for YaBB(Gold) -> SMF Converter? One or two week, couple of weeks or months?
May be I can pay money for this converter?! ;)
Thanks a lot! :)
Quote from: [Unknown] on October 13, 2004, 05:02:49 PM
I'm still working on it... it may take some time.
-[Unknown]
Well, if you have a decent size forum (how many boards do you have?) and wouldn't mind me testing the converter with it, sooner than otherwise ;).
What's holding me back from active work right now is basically that I need a forum to test it on that is large enough to let me test any possible problems (for example, timeouts) so they can be resolved. You can read more in this topic:
http://www.simplemachines.org/community/index.php?topic=18350.0
Even if you don't have that large a forum, no one's volunteering... so a "real" one is better than my testing one any day (since I just plain can't sit there and make even a thousand posts for testing...)
-[Unknown]
Dear [Unknown],
Quote from: [Unknown] on October 31, 2004, 01:15:08 AM
Well, if you have a decent size forum (how many boards do you have?) and wouldn't mind me testing the converter with it, sooner than otherwise ;).
I have 3 big forums with about 50 boards, 4.000 users, 2.500 topics and 100.000 postings in each forum.
Quote from: [Unknown] on October 31, 2004, 01:15:08 AMWhat's holding me back from active work right now is basically that I need a forum to test it on that is large enough to let me test any possible problems (for example, timeouts) so they can be resolved. You can read more in this topic:
http://www.simplemachines.org/community/index.php?topic=18350.0
Even if you don't have that large a forum, no one's volunteering... so a "real" one is better than my testing one any day (since I just plain can't sit there and make even a thousand posts for testing...)
I can copy all data from one big forum and make one board (or many boards) just for your tests. Of course I can give you access to this forum via FTP oder SSH2. I will contact you in ICQ :) See you ICQ-messages! :)))
CU! :)
I got your message, but I'm afraid that I'm not on ICQ much - very busy, and I only get more so when I go online.
Thanks very much for your willingness to help - and that sounds like a great test of the converter ;). I shouldn't need more than FTP, and if you'd like I can download the data and do it locally (so as not to distrupt your server.) I'd appreciate it if you could send me the FTP information by email, or whatever means you think best.
As for copying them together, it's your call. I think 100,000 posts should be enough, but more can't (or if it can, I will need to fix that) hurt.
Thanks again,
-[Unknown]
Any news on this, Hannover?
-[Unknown]
[Unknown], I have a 6000 member, 70,700 post yabb sp 1.3.1 board that I can get to you if you need test data. I can gzip and give you a download link. Let me know. It's one I'll be converting in the future after other projects are completed.
Dear Unknown, sorry for delay - a lot of work ;)
I install some mods for YaBBGold and my data format is a little bit different, than YaBB Gold - native data format. I insert some new fields in data files. I need some days to write converter from my data format in YaBB native fortam.
leah, do you have original YaBB data format? Mya be ist faster to use your data files?
I can use either - a gzip (provided I can download it FTP or HTTP steadily) would be fine and great.
-[Unknown]
I'll do that today and send you a pm with details. :)
Hi,
I'm also planning to make my YaBB 1.3.1 a SMF.
Do I need to make a backup before converting my Yabb 1.3.1 into a YaBBSE?
Or doesn't the converter touch the Yabb 1.3.1 data?
Thanx in advance for your replies :)
The convertor only reads your YaBB data, it won't touch it.
Thanks alot, will give it a try then this weekend :)
Quote from: Satrina on May 23, 2004, 07:47:19 PM
Welp nothing yet, it appears to have "finished" the browser stopped but that was it.
I have exactly the same prob...when it comes to "Importing Messages" it just stops (there are about 5.000 threads).
Though, I've installed Apache + MySQL on my computer & tried it offline - without any problems with converting etc. :)
But as I've got absolutely no idea how MySQL works - how can I get the offline version to the internet now?
When I enter my account with WS_FTP, there is no directory called "MySQL" I could upload the stuff to :(
you need to upload the database in MyPHP in Cpanel.
you cant FTP it
Ouch!
Thanx alot! Though, it's still a bit confusing to me, as it doesn't say anything about "uploading" in PHPMyAdmin.
Is this the right menu to upload the files?
-> Databases -> [Choose Database] -> SQL -> Enter Location of the textfile
Though, another problem...uploading is limited to 8MB...my largest file is 60MB :-\
Thats the option, you can split the sql file into smaller chunks, just make sure as you not split it half way through a statement or ask your host to import it for you.
D'oh! I've no idea how to do this, but I also don't want to send 90MB to my host with my slow internet connection, and then maybe it's not working & I have to send it again. My host anyway doesn't like me at the moment, as they say my current Yabb 1.3.1 would slow down the server & I'd have to switch to another forum-software :-\
Is there maybe another way to do the upgrade online - As said, everything is going fine until it displays "Importing Messages" after about two minutes (Step6). After that nothing happens - and I waited several hours...and I started from scratch at least five times now - but the problems reamins, every time I try.
When I enter YabbSE after the unfinished conversion, all the Categories and Members are converted, but no topic and messages are displayed. When I delete the categories in YabbSE, it says "Removing Topic...Removing Messages", so it must have converted some messages. Is it maybe possible to split this Step 6 in two "smaller" steps?
The YaBB converter is not very efficient. As I've said before, I'm working on an optimized version that will be able to handle larger forums. I am not done yet, however.
-[Unknown]
My Yabb has about 5000 Threads, 95000 Messages and 1325 Users.
As said, if I do it offline, converting is no problem. But online it doesn't complete converting.
Could the size be the problem anyway (so that it might work if I delete some thousand postings)?
The size causes it, your host has the server configured to time out after a while. You could try deleting posts, but you may have to delete most of them.
If you could upload the file, I'm sure your host would do it for you since it gets you away from YaBB.
I've been deleting posts for about 15 hours now...deleted about 170 users, 1700 threads and 20000 postings...and still it won't run through :P
So all they'd need to do would be putting the FRM + MYI + MYD files into the mysql directory?
On my local installation I used a different username + password for mysql´- would it work anyway?
You could use phpMyAdmin or a similar tool to copy over the converted database.
-[Unknown]
Wow, what a fast reply :)
The problem is, I'm not sure how to do this for files bigger than 8MB (which seems to be the maximum file size for uploading). I already tried your "restore_backup.php" script, but it also doesn't run through :(
Do you know of similar tools?
Please reply to the topic that contains restore_backup.php with those errors you got, and make sure you're using the most recent attached version I posted.
-[Unknown]
D'oh!!!
I'm afraid...looks like I didn't use the latest version...after about 20 hours nonstop in front of my pc screen I just got a bit dull I suppose :D
After my last posting I downloaded another script called "Bigdump" which worked perfectly. SMF is running now...so all the deleting etc. was useless, as I uploaded my (original) database including all 95000 messages.
Anyway thanks for your help!
Despite all the problems while getting the database running I think I've switched to the best forum software around :)