[SOLVED] InvisionFree to PhpBB; support needed!

[Bird-Kid]

hi all

well, first of all, i know there r converters, and yes, i did read most instructions etc. but somehow, it's not working

so far, i only got a database copy of our old invisionfree board:
file-size: ~30MB
content-demo:

Code: Select all

INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89155','*censored*','[Diet Dr Pepper]','0');
INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89299','fucking','Love-Making','1');
INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89320',':rolleyes:','8)','0');
INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89509','):|','{:|','0');
INSERT IGNORE INTO ibf_posts (append_edit, edit_time, pid, author_id, author_name, use_sig, ip_address, post_date, icon_id, post, queued, topic_id, forum_id, new_topic, edit_name, attach_hits, attach_type, attach_file) VALUES ('0','0','55925','1','ROOT','1','88.110.206.48','1155666462','0',' Welcome to the New Forum and squad  <!--emo&B)--><img src=\'http://209.85.48.10/html/emoticons/cool.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'cool.gif\' /><!--endemo-->  ','0','2','1','0','','','','');
INSERT IGNORE INTO ibf_posts (append_edit, edit_time, pid, author_id, author_name, use_sig, ip_address, post_date, icon_id, post, queued, topic_id, forum_id, new_topic, edit_name, attach_hits, attach_type, attach_file) VALUES ('0','0','88390','6','[ASS] VADER[FIN]','1','84.231.199.63','1155733221','0',' welcome <!--emo&:)--><img src=\'http://209.85.48.10/html/emoticons/smile.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'smile.gif\' /><!--endemo-->  <!--emo&B)--><img src=\'http://209.85.48.10/html/emoticons/cool.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'cool.gif\' /><!--endemo-->  <!--emo&:D--><img src=\'http://209.85.48.10/html/emoticons/biggrin.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'biggrin.gif\' /><!--endemo-->  ','0','2','1','0','','','','');
INSERT IGNORE INTO ibf_posts (append_edit, edit_time, pid, author_id, author_name, use_sig, ip_address, post_date, icon_id, post, queued, topic_id, forum_id, new_topic, edit_name, attach_hits, attach_type, attach_file) VALUES ('0','0','88491','3','[ASS] Jay','1','82.46.130.108','1155733417','0',' welcome and enjoy <!--emo&:P--><img src=\'http://209.85.48.10/html/emoticons/tongue.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'tongue.gif\' /><!--endemo-->   ','0','2','1','0','','','','');

as recommended, I used/tried to use IB2phpBB - Convert Ibf To Phpbb, but, being @ step #3:

3/ In PhpMyAdmin, import your Invision Board tables ; the one you have just saved.

i just can't import the sql file;
first of all, it's apparently too big (max. file-size to upload at once: 2,048 KiB); so i just tried to split it manually - upload only some lines at once; but, however, this didn't work neither (set: Character set of the file=utf8; tried several options); all i ever got was:

Error

SQL query:
ibf_badwords(
wid, TYPE , swop, m_exact
) VALUES (
'88558', 'PAM', 'person above me', '1'
);

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ibf_badwords (wid, type, swop, m_exact) VALUES ('88558','PAM','person above me',' at line 1

i also tried softwares such as mysqldumper, but that doesn't seem to work neither..
error given:

Code: Select all

Array
(
    [num_table_fields] => Array
        (
        )

    [max_zeit] => 22
    [startzeit] => 1205247042
    [xtime] => 1205247042
    [fileEOF] => 
    [actual_table] => ibf_badwords
    [offset] => 0
    [aufruf] => 1
    [table_ready] => 0
    [part] => 0
    [do_it] => 
    [errors] => 0
    [notices] => 0
    [anzahl_eintraege] => -1
    [anzahl_tabellen] => -1
    [filename] => 1204895924.sql
    [actual_fieldcount] => 0
    [eintraege_ready] => 0
    [anzahl_zeilen] => 70
    [summe_eintraege] => 0
    [erweiterte_inserts] => 0
    [flag] => -1
    [EOB] => 
    [dump_encoding] => utf8
    [kind] => 0
    [compressed] => 0
    [filehandle] => Resource id #13
)

Couldn't read rowcount for table ibf_badwords!
Restore:ibf_badwords

may someone pls help me to fix that?

many thanks in advance!
bird-kid

EDIT @ 03-15-2008
nvm ... fixed it..