Invision Power Board 2 (2.1.7) to SMF Converter problem...

[tones_ie]

Hi guys....   wanna try get a IPB converted over to smf.... have convinced the client.

But get an error on the conversion part...

Code Select Expand

The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

running IPB latest...2.1.7 and SMF RC3 latest.   Appreciate any tips...

[Pause]

You're using the wrong converter - you need this one: http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-rc3_invision2_converter.zip

[tones_ie]

Thank u....gotta get sumtin for this tunnel vision

although even using that converter i have a prob...any ideas?

Code Select Expand

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessfull


Caused the error:

    Got a packet bigger than 'max_allowed_packet'

thanks in advance...

[tones_ie]

anyone any ideas guys ?  appreciate it...

[Pause]

anyone any ideas guys ?  appreciate it...

The 'max_allowed_packet' in /etc/my.cnf needs to be bigger - if it is not your own server, then you need to contact your host.

[tones_ie]

Thank you....

i have access to that file...heres what it says...

Code Select Expand

[mysqld]
set-variable = max_connections=500
safe-show-database

what is the normal setting for this ...do u know ?

[H]

Thank you....

i have access to that file...heres what it says...

Code Select Expand

[mysqld]
set-variable = max_connections=500
safe-show-database

what is the normal setting for this ...do u know ?

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html << You may need to change the version of the manual.

The server's default max_allowed_packet value is 1MB. You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns). For example, to set the variable to 16MB, start the server like this:

[tones_ie]

Thanks guys...

Ok..after following the info to increase max packet size...it gets further along the converting process but stall with this new error...

Code Select Expand

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: 0 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined offset: 1 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 2 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 0 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined offset: 1 in smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 2 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 0 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined offset: 1 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 2 in /smf/convert.php(814) : eval()'d code on line 8
Unsuccessful!
This query:

    INSERT INTO `thehanga_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, , SUBSTRING('', 1, 255), ),
    (2, , SUBSTRING('', 1, 255), ),
    (4, , SUBSTRING('', 1, 255), );

Caused the error:

    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 ' SUBSTRING('', 1, 255), ),
    (2, , SUBSTRING('', 1, 255),


cheers guys....

[tones_ie]

ok...thinking i was being a cute *ucker...i went in and deleted the polls from the IPB database as there of no use anyway....  reinstalled smf..and tried to re convert...only to get this error now...

Code Select Expand

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Unsuccessful!
This query:

    INSERT INTO `thehanga_smf`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('', '2'),
    ('', '24'),
    ('', '3'),
    ('', '13'),
    ('', '21'),
    ('', '19'),
    ('', '1'),
    ('', '6'),
    ('', '27'),
    ('', '8'),
    ('', '10'),
    ('', '7'),
    ('', '26'),
    ('', '2'),
    ('', '1'),
    ('', '21'),
    ('', '24'),
    ('', '28'),
    ('', '2'),
    ('', '40'),
    ('', '8'),
    ('', '1'),
    ('', '19'),
    ('', '3'),
    ('', '24'),
    ('', '34'),
    ('', '9'),
    ('', '26'),
    ('', '10'),
    ('', '42');

Caused the error:

    Duplicate entry '0-2-0' for key 1

*sigh.... 

[Oldiesmann]

Thanks guys...

Ok..after following the info to increase max packet size...it gets further along the converting process but stall with this new error...

Code Select Expand

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: 0 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined offset: 1 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 2 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 0 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined offset: 1 in smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 2 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 0 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined offset: 1 in /smf/convert.php(814) : eval()'d code on line 8

Notice: Undefined index: 2 in /smf/convert.php(814) : eval()'d code on line 8
Unsuccessful!
This query:

    INSERT INTO `thehanga_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, , SUBSTRING('', 1, 255), ),
    (2, , SUBSTRING('', 1, 255), ),
    (4, , SUBSTRING('', 1, 255), );

Caused the error:

    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 ' SUBSTRING('', 1, 255), ),
    (2, , SUBSTRING('', 1, 255),


cheers guys....

How are polls stored in that version of IPB? It seems that they change it with every version.

[tones_ie]

How are polls stored in that version of IPB? It seems that they change it with every version.

Hi there...im not 100% as to what it is ure asking....i took a guess and made a screenshot of the poll table    Table: ibf_polls



sorry if this is not what u meant....

[Oldiesmann]

Hmmm... You don't even have any poll options to begin with. Do you have any polls on your board?

[tones_ie]

Nopes...no polls...as i mentioned above i thought that by deleting the polls out of the database ( only had 4...and were months old ) i could "skip" by the previous error.....

[青山 素子]

Deleting the polls but not the options selected for the polls will break things.

There is also some broken code for that area of the converter.

Try a slightly fixed script I corrected a bit ago. The only problem is it might not convert all the special post code (quotes, etc). If you notice some stuff that didn't get converted, I can probably add it.


Note to Jay: You might want to check out the regexs I changed to support IPB's new decision on how to handle some quote code + the poll option fix. I can probably diff it for you if needed.

[tones_ie]

Deleting the polls but not the options selected for the polls will break things.

Is there anyway i can "fix" the options selected that you mention...or delete em too....?

I notice that the download u attached...is name 2.1.3 to smf....im running 2.1.7 ?  is this ok to use?

thanks man...

[青山 素子]

You won't know without trying. I believe I updated it to work with 2.1.6 but left the filename alone.

Did you delete the polls through IPB, or the database? If IPB, it should have deleted the poll options and votes.

[tones_ie]

You won't know without trying. I believe I updated it to work with 2.1.6 but left the filename alone.

Hi, I tried with the modified file u uploaded....  fresh install of SMF RC3...after running the converter i get the same error....

Code Select Expand


Invision Power Board 2.1.3 to SMF Converter
Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Unsuccessful!
This query:

    INSERT INTO `thehanga_smf`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('', '2'),
    ('', '24'),
    ('', '3'),
    ('', '13'),
    ('', '21'),
    ('', '19'),
    ('', '1'),
    ('', '6'),
    ('', '27'),
    ('', '8'),
    ('', '10'),
    ('', '7'),
    ('', '26'),
    ('', '2'),
    ('', '1'),
    ('', '21'),
    ('', '24'),
    ('', '28'),
    ('', '2'),
    ('', '40'),
    ('', '8'),
    ('', '1'),
    ('', '19'),
    ('', '3'),
    ('', '24'),
    ('', '34'),
    ('', '9'),
    ('', '26'),
    ('', '10'),
    ('', '42');

Caused the error:

    Duplicate entry '0-2-0' for key 1

Did you delete the polls through IPB, or the database? If IPB, it should have deleted the poll options and votes.

I deleted the polls through myphpadmin....

thanks again...

[青山 素子]

Then you only removed half. Truncate the prefix_poll_choices table (prefix being whatever prefix IPB is using).

[tones_ie]

Thanks for the continued help....but im a lil lost. Dont understand what you mean by "Truncate the prefix_poll_choices table"

from what i can see...i dont have a table called poll_choices ?  As u can prolly guess..im rather a beginner regards databases

[青山 素子]

Hm. There should be since the script looks in there for the choices to convert. Are you checking in the IPB database?

Truncate is a fancy way of saying delete all data in the table. (It is also an SQL command: TRUNCATE table *tablename*)