hey, i wanna convert to SMF from myBB.... i used the convertor but after converting... it gives me this:
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Unsuccessful!
This query:
SELECT pid AS ID_MSG, filedata, downloads, filename, filesize
FROM `spicyjoe_test`.mybb_attachments
LIMIT 0, 500;
Caused the error:
Unknown column 'filedata' in 'field list'
i guess its the attachmech error that bugged everything up... after i converted... my user name case has been changed (spicyjoe > SpIcYjOe *coz i placed defferent case to check*).... but i ccan't login and my category and forum wasn't there..... i ask compuart to help but he never replied me... :( any help please? i really awnna convert...
Run this query in phpMyAdmin and post the results here:
SHOW CREATE TABLE mybb_attachments
This will show the table structure for that table, which will allow us to change the sql file as needed.
ok, but what i need to change?
I need you to post the results of that query here so I can figure out what needs to be changed.
ok, here are they:
CREATE TABLE `mybb_attachments` (
`aid` int(10) unsigned NOT NULL auto_increment,
`pid` int(10) NOT NULL default '0',
`posthash` varchar(50) NOT NULL default '',
`uid` int(10) unsigned NOT NULL default '0',
`filename` varchar(120) NOT NULL default '',
`filetype` varchar(120) NOT NULL default '',
`filesize` int(10) NOT NULL default '0',
`attachname` varchar(120) NOT NULL default '',
`downloads` int(10) unsigned NOT NULL default '0',
`visible` int(1) NOT NULL default '0',
`thumbnail` varchar(120) NOT NULL default '',
PRIMARY KEY (`aid`)
) TYPE=MyISAM
Ok. Give me a few minutes to look at this. SMF is trying to get the attachment file data from the database, but it doesn't appear that MyBB stores this information in the database, so we'll have to copy the file over from your MyBB attachments directory.
Try this one...
it said converting complete... view your new forum here... but the forum is still the same... the title is still My Community... i cannot log into my account and the forum and category didn't got transfered...
EDIT: maybe i did something wrong... here is the whole process:
1. i installed smf (www.realchatters.be/forumss) and myBB (www.realchatters.be/Upload) and simply make a forum and thread thats defferent from each board and on a test database
2. i uplaoded convert.php and smf_to_mybb.sql into smf directory and ran convert.php
3. i entered /home/spicyjoe/public_html/forumss for smf path and /home/spicyjoe/public_html/Upload for mybb path and my MySQL pass (shhhh, cannot tell my pass ;))
4. it said converting complete but nothing was transfed but only my user name case ( i registered spicyjoe in smf and SpIcYjoe at mybb) and now my smf has SpIcYjoe but i cannnot login....
Try emptying out all the SMF tables first and then running the converter again. The converter is supposed to empty out all the tables before it copies data, but apparently it didn't for some reason.
ok, i cleared the tables and when i go to my smf forum.... it still says My Community (which is not my title is mybb), my forum doesn't have a theme (i mean like just a piece of white paper) and i get this when i login:
QuoteAn Error Has Occurred!
Sorry, you are out of login chances. Please come back and try again later.
...
anyone can help me? plaese i really need help... i can;t stand myBB another day...
Try re-uploading all your SMF files.
I'm not sure why the converter isn't working for you... It should work fine now that I've fixed that one error...
yeah, i tried that also... didn't work... hey, if you are not busy... can you help me to do it? i can give you my pass and user to my cPanel...
I can't access cPanel right now (I'm at school), but if you can give me FTP info I can try to help that way.
oh sure... check your pm.... :D
I need your FTP server as well...
ok, sorry... :D
I tried it once with that empty MyBB install in the Uploads folder and it worked fine. When I registered an account at the SMF board that the MyBB was converted to, I couldn't login at first, but deleting my cookies fixed that. I then went and registered on the MyBB board and made a post with a poll and an attachment, but now your site won't load so I can't test the converter again. Not sure what's going on...
ok, i think i am darn confused... maybe you can take me step by step.... ok, i install 2 forum, then upload convert.php and mybb_to_smf.sql into smf directory and then run convert.php. after i have converted, i need to clear my realchatters.be cookies and it will work?
ok, i tried like what u said... it still didn't work.... and i'll send you my pass and user again.... its working fine for me....
hey, anyone can help me? Oldiesmann tried to help me very much but he can't access my ftp... thanks Oldiesmann... anymore people can help? i am sick and tired of myBB
Just a quick note for clarification:
The problems I'm experiencing are server-related. Everytime I try to run the converter, the server seems to freeze after the first step - it never gets past the first step, and then I keep getting "The operation timed out when attempting to connect" everytime I try to refresh the page or start over again. I've asked him to talk to his host about this, but if anyone else has any insight as to what might be happening, I'd appreciate any help you might be able to provide.
I'm gettting errors too, does this work with MyBB 1.00 Preview Release 2 >>> SMF 1.0.5?
I'm using the same methode posted here, with convertor.php
Oh yeah, I get this error: Unknown column 'buddy_list' in 'field list'
John