News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Latest convert.php script? - out of date column names

Started by mattpr, June 04, 2013, 10:58:33 AM

Previous topic - Next topic

mattpr

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

mattpr

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.

Advertisement: