Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: mattpr on June 04, 2013, 10:58:33 AM

Title: Latest convert.php script? - out of date column names
Post by: mattpr on June 04, 2013, 10:58:33 AM
Posting here because this is an issue with the convert.php script itself.

Converting from IPB 2.0.3, but not relevant for this post (I think) since the issue is with the generic convert.php script.

This thread: http://www.simplemachines.org/community/index.php?topic=149092.0
Referred me to download the "latest" convert.php from
here: http://www.simplemachines.org/community/index.php?topic=140741.0

The latest update was Oct 2010 on that convert.php...so wondering if there is a newer one?  I don't see any convert.php sticky threads and the downloads section on the website is even more out of date!!!!!

The Problem

It appears that some of the SQL generated by the convert.php script (to insert the converted data into the SMF db) references wrong table column names.
Conversion stopped at the below error...so there may be more. 


INSERT INTO `somedb`.members
(ID_MEMBER, memberName, dateRegistered, ID_GROUP, posts, lastLogin, realName, YIM, instantMessages, passwd, passwordSalt, emailAddress, birthdate, websiteTitle, websiteUrl, signature, location, ICQ, MSN, AIM, hideEmail, pm_email_notify, avatar, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, memberIP2, is_activated)
VALUES (...)

Unknown column 'memberName' in 'field list'


This was reported in 2011 and got no replies.  That's a bit disconcerting and making me reconsider my choice of SMF (lot of friction to changing boards once you pick one).

http://www.simplemachines.org/community/index.php?topic=446678.msg3136619

Pressing thumbs that there is actually an updated convert.php script out there that someone forgot to sticky.

Thanks!

-Matt
Title: Re: Latest convert.php script? - out of date column names
Post by: mattpr on June 05, 2013, 06:05:51 AM
I should mention that I have also tried with the convert.php script from the simplemachines download page (off forum) as well and have the same problem.