SMF Support > MyBB

myBB to SMF help

(1/5) > >>

spicyjoe:
hey, i wanna convert to SMF from myBB.... i used the convertor but after converting... it gives me this:


--- Quote ---Converting 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'
--- End quote ---

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...

Oldiesmann:
Run this query in phpMyAdmin and post the results here:


--- Code: ---SHOW CREATE TABLE mybb_attachments
--- End code ---

This will show the table structure for that table, which will allow us to change the sql file as needed.

spicyjoe:
ok, but what i need to change?

Oldiesmann:
I need you to post the results of that query here so I can figure out what needs to be changed.

spicyjoe:
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

Navigation

[0] Message Index

[#] Next page