[SOLVED] InvisionFree to PhpBB; support needed!

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
Bird-Kid
Registered User
Posts: 11
Joined: Tue Feb 05, 2008 10:02 pm

[SOLVED] InvisionFree to PhpBB; support needed!

Post by Bird-Kid » Tue Mar 11, 2008 3:02 pm

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:
(C) 2003 Obelix - Ni[o wrote: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? :cry:

many thanks in advance!
bird-kid

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

Locked

Return to “[2.0.x] Convertors”