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

[tones_ie]

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

Yeps...looking in the databse....no table with that name...

if i run a search  as regular expression for poll_choices in the whole database i get the folling hits..

ibf_skin_templates_cache

Code Select Expand

SELECT *
FROM `database name`.`ibf_skin_templates_cache`
WHERE `template_id` REGEXP 'poll_choices'
OR `template_group_name` REGEXP 'poll_choices'
OR `template_group_content` REGEXP 'poll_choices'
OR `template_set_id` REGEXP 'poll_choices'
LIMIT 0 , 30

ibf_skin_templates

Code Select Expand

SELECT *
FROM `database name`.`ibf_skin_templates`
WHERE `suid` REGEXP 'poll_choices'
OR `set_id` REGEXP 'poll_choices'
OR `group_name` REGEXP 'poll_choices'
OR `section_content` REGEXP 'poll_choices'
OR `func_name` REGEXP 'poll_choices'
OR `func_data` REGEXP 'poll_choices'
OR `updated` REGEXP 'poll_choices'
OR `can_remove` REGEXP 'poll_choices'
LIMIT 0 , 30

ibf_conf_settings

Code Select Expand

SELECT *
FROM `database name`.`ibf_conf_settings`
WHERE `conf_id` REGEXP 'poll_choices'
OR `conf_title` REGEXP 'poll_choices'
OR `conf_description` REGEXP 'poll_choices'
OR `conf_group` REGEXP 'poll_choices'
OR `conf_type` REGEXP 'poll_choices'
OR `conf_key` REGEXP 'poll_choices'
OR `conf_value` REGEXP 'poll_choices'
OR `conf_default` REGEXP 'poll_choices'
OR `conf_extra` REGEXP 'poll_choices'
OR `conf_evalphp` REGEXP 'poll_choices'
OR `conf_protected` REGEXP 'poll_choices'
OR `conf_position` REGEXP 'poll_choices'
OR `conf_start_group` REGEXP 'poll_choices'
OR `conf_end_group` REGEXP 'poll_choices'
OR `conf_help_key` REGEXP 'poll_choices'
OR `conf_add_cache` REGEXP 'poll_choices'
LIMIT 0 , 30

ibf_cache_store

Code Select Expand

SELECT *
FROM `database bane`.`ibf_cache_store`
WHERE `cs_key` REGEXP 'poll_choices'
OR `cs_value` REGEXP 'poll_choices'
OR `cs_extra` REGEXP 'poll_choices'
OR `cs_array` REGEXP 'poll_choices'
LIMIT 0 , 30

Dunno if all that means anythinbg to you guys....

[青山 素子]

Sorry, I was confused. The table with the options is "prefix_polls". You will want to clear all data out of it if you don't want the polls moved over.

[tones_ie]

ok...i ran that truncate on the poll table... Then reinstalled a fresh board..and redid the convert....  stopped again on this 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

so tried deleting that part out of the sql query...

Code Select Expand

/******************************************************************************/
--- Converting poll logs...
/******************************************************************************/

---* {$to_prefix}log_polls
SELECT pl.pid AS ID_POLL, v.member_id AS ID_MEMBER
FROM {$from_prefix}voters AS v
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = v.tid);
---*

that gets me past that error and to this part

Converting...
Recalculating forum statistics... Incomplete.

where it just stays on that page and loops....  ??

is there any more converting to do after this point ?

[Oldiesmann]

You also need to clear out the voters table.

IPB makes things so complicated...

[青山 素子]

They do it on purpose.

[tones_ie]

Thanks guys...ill give it a go ltr today when i get a chance and report back.....    as for em making things complictaed...im sure it will only get "worse"...they just released  V 2.2 Release Candidate 1.....

[cabbar]

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 hxxp:www.animeneko.net/~motokochan/smf/invision2.1.3_to_smf.zip [nonactive] 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.

Actually I wrote something in a different topic but it is related with this fixed script; hence, you might be interested in the message.

[ictus]

HELP


trying to convert from IPB2.1.7 to smf 1.1.1 got the poll problem, so truncated the ipb_poll table, and got this error:

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

    INSERT INTO `ridgway_ibrd1`.smf_log_polls

    (ID_POLL, ID_MEMBER)

    VALUES ('', '38'),

    ('', '37'),

    ('', '1'),

    ('', '42'),

    ('', '6'), etc etc

is there a fix? am I doing something wrong? and help would be nice as the convertion was going to be a Chritmas present to the members...

All I need is the members and the posts, not the polls or any other attachements etc, can I edit the converter files to bypas the bits that don't work (if so how, I'm not exactly hot at this, but I can follow instructios)

and

MERRY CHRISTMAS....

[青山 素子]

There is/was a typo on one of the conversion scripts. Try my updated copy at http://www.animeneko.net/~motokochan/smf/invision2.1.3_to_smf.zip

[ictus]

still no joy, maybe I have the wrong convertor.php, is there one for your .sql script?

[ictus]

OK, restored my original MySql, then converted, it works...thanks

but....


Some of my threads are missing, some old, some new, not sure why or how, there where no error messages...

[青山 素子]

Run a repair on SMF. (Under forum maintenance). It might fix some of the missing post issues.

If you still can't get things working, I'll investigate the issue further.

[ictus]

the maintinance gets the forums back, but not the posts.


Some are older posts, others very resent, so that isn't the issue, trying to prune down IPB to the bare minimum then I'll try again, I'll be glad when I'm shut of the thing, why do they make things so hard

[青山 素子]

Because they don't want you to leave. It is called vendor lock-in.

[ictus]

if the worst comes to the worst I'll be asking my members to move their games manually, as I've got fed up with patch after patch and little to no new material.

now I'm back to the first error, as my  MySql went wonky, but I'll fix it.

[dontbe]

OK.. i guess I'm at the right place... Motoko-chan I'm having the same problem as tones-ie, and I did the same thing before coming here.. I emptied the polls in the database.

I get a "Converting poll logs... Unsuccessful!" (see attached image)

I deleted the polls from the IBF database, but the smf knows they are supposed to still be there somehow.. how do I fix this? Can I use your new and ipmproved converter?? but Im converting from IPB 1.3.1...

thanks for any info..

regards, Ed

[ictus]

restore the database if you can, then delete any polls with more than one question.

if not, it's a problem

[dontbe]

I dont have the old database... I ws more than three days out, and my provider does not provide backups out 7 days anymore

[ictus]

here's how i did it, and it isn't pleasant.

Do the conversion as is, it will give an error. remove the converter files
Now goto your admin in SMF
Goto Forum Maintinance, then click 'Find and repair any errors.'
This will get your posts back, but they will all be in a salage board, so need moving, your members should be fine.
Then start reorganising the boardsby moving your forums to the right places, under Admin/Boards

That should work, it's not eligant and I'm sure there's an easier way, but it worked for me and my board is running fine now.

[dontbe]

Thanks ictus.. Ill try that . thanks for the help!