IPB to smf1.1rc2 convertion problem

[Sirjump]

I tried to install smf1.1rc2 instead of 1.0.7 since I got error in conversion. I tried with 1.1rc2 and I got a different error message. Does someone know what the problem is this time?

It's getting a bit urgent since the web hotel I host my IPB forum on upgraded and I cant get that forum to work after their upgrade either. *sigh*

Converting permissions... Unsuccessful!
This query:
SELECT
g_id AS ID_GROUP, g_title AS groupName, g_max_messages AS maxMessages,
g_view_board AS view_stats, g_mem_info AS view_mlist,
g_view_board AS who_view, g_use_search AS search_posts, g_email_friend AS send_topic,
g_edit_profile AS profile_identity_own, g_post_new_topics AS post_new,
g_reply_own_topics AS post_reply_own, g_reply_other_topics AS post_reply_any,
g_edit_posts AS modify_own, g_delete_own_posts AS delete_own,
g_post_polls AS poll_post, g_post_polls AS poll_add_own, g_vote_polls AS poll_vote,
g_use_pm AS pm_read, g_use_pm AS pm_send, g_is_supmod AS moderate_forum,
g_is_supmod AS manage_membergroups, g_is_supmod AS manage_bans,
g_access_cp AS manage_smileys, g_access_cp AS manage_attachments,
g_can_remove AS delete_any, g_calendar_post AS calendar_post,
g_calendar_post AS calendar_edit_any, g_post_closed AS lock_own,
g_edit_topic AS modify_any, g_open_close_posts AS lock_any
FROM `sirjump_ivbd1`.ibf_groups
WHERE g_id NOT IN (1, 4, 5)
LIMIT 0, 100;
Caused the error:

Unknown column 'g_edit_topic' in 'field list'

Thanks in advance,
Sirjump

[J. Williams]

Please make sure you are using the new convert.php for 1.1 rc 2 and latest converter for 1.0

[H]

Also check you are using the right converter for your version of IPB (converters are available for 1.3, 2.0.x and 2.1.x)

[Sirjump]

Thanks for replies. I am using the correct converter and sql file. The forum actually converts somehow, all posts and categories are present, but no users... and no way for me to log in as admin either. Anyone that can help me get the converter to work so it does the users as well ?

[Sirjump]

Ok I managed to make it work by just removing this line:

g_edit_topic AS modify_any, g_open_close_posts AS lock_any

The same situation happened again later in the conversion, so I removed the line with the problem once more and it worked. I got some small bugs when I started the forum but the forum itself were able to correct the errors and sort the tables.

I am now an official SMF user 

Sirjump

[JayBachatero]

Did you try the convertor and .sql file frm this topic not the other one?
http://www.simplemachines.org/community/index.php?topic=65677.0

[Sirjump]

Yes I used that one, and just erased 2 lines from it. Everything works fine now, though as I wrote before, the tables had to be fixed by the forum afterwards. I am not sure, but I think the problem was that some usernames were in the database file but didnt have any values...

SJ

[JayBachatero]

Yes I used that one, and just erased 2 lines from it. Everything works fine now, though as I wrote before, the tables had to be fixed by the forum afterwards. I am not sure, but I think the problem was that some usernames were in the database file but didnt have any values...

SJ

Um weird.  It might be cause of that but that line you posted I believe deals with the locking of posts.