That did solve the last post issue. I then snagged timeformat being too small followed by the value not being the correct type since SMF is using the format: %d, %Y, %I:%M:%S %p
Line 130 of users.php: need to change the pulled column from "total_time_loggedIn" to "total_time_logged_in"
The script definately dislikes lastpost: "1366 - Incorrect integer value: '' for column 'lastpost' at row 1". If I hit someone that is new and has not posted anything, the lastpost column is failing with the same error since $result is returning a blank value. In this case, its the very last member of the table (so very close).
I made sure the column had a default value and could be Null.
Ok, I'll get those this evening if I can. Working right now.
(2011-08-04, 08:33 PM)Dylan M. Wrote: [ -> ]Ok, I'll get those this evening if I can. Working right now.
Now that's no excuse
No problem.
I'm looking at the code and the test data uses a "2" for the timeformat column of users.php for the phpbb and smf convertors. How is timeformat defined with MyBB?
total_time_logged_in corrected in:
http://dev.mybb.com/issues/1685
lastpost:
http://dev.mybb.com/issues/1686
timeformat:
http://dev.mybb.com/issues/1687
This one I'm not doing right now since it is at this time impossible to know all the different ways SMF may be putting the time format into the db w/out testing each and everyone and making an array replacement. However you can change this line:
$insert_data['timeformat'] = $data['time_format'];
To this:
$insert_data['timeformat'] = 0;
Which will reset everyone to default time display and any who care to can change in their user prefs on the MyBB board.
Agreed on the time. I'm taking the route to force a time and date format on import.
After applying each change, users passed! I've attached the final working copy. I did hardcode defaults for timeformat, dateformat, and timezone.
Next snags:
forumperms.php - "1366 - Incorrect integer value: '' for column 'gid' at row 1"
posts.php - "Fatal error: Call to a member function simple_select() on a non-object in E:\www\mbb\merge\boards\smf2\posts.php on line 33"
privatemessages.php - "1054 - Unknown column 'import_pmid' in 'field list'"
I'm looking into each now.
Ugh, I can't get past the gid issue with forumperms. Gid keeps returning a null value and even setting the column as Null-able, the script still stalls out the gate.
I really should have taken the time to test the merge system with SMF 2.0 Gold when it came out, but since no one had complained I didn't. Now I guess its that time
I spent most of the night working on the bugs. Unfortunately, I find my knowledge of PHP to be much less than my knowledge of ASP.... I'll in the the corner, in a fetal position, crying, softly.
Some of these errors you're getting because of missing the incorrect versions of some files. Its the only way. Please download the svn copy and try with that.
In fact these all seem to relate to improper files being used. Like you're using some from 1.6.0 and some from later versions. I'm not sure how this could be, but if you could please try the latest svn I would appreciate it.
http://wiki.mybb.com/index.php/Developme...#SVN_Setup
I think I mixed buy grabbing the new files from the bug log.
So I grabbed the entire SVN and here's the report.
Usergroups - "1366 - Incorrect integer value: '' for column 'canpostthreads' at row 1" - I added one group. This one is messy now. SMF2 does not use the permission 'post_new', but instead uses a table called 'permission_profiles'.
So I deleted out the membergroup... now I only get a blank page.
Usergroups: I had to forcefeed a default value ala users. I've attached the usergroups.php file.
I then make it all the way to Forumperms: "1366 - Incorrect integer value: '' for column 'gid' at row 1" Gid isn't pulling and I cannot set a default.
Skipping permissions I advance to Posts:
"SQL Error:
1366 - Incorrect integer value: '' for column 'firstpost' at row 1
Query:
UPDATE mybb_threads SET firstpost='' WHERE import_firstpost = '226'"