phpbb2 convert - users import

[lukasamd]

Hello,
I have a problem with Merge System. I'd like to convert my phpbb2 by przemo to mybb. I converted forum to phpbb2 but when I convert its to mybb i have problem with users:

Code:

Import phpBB 2 Users
There are 299 users left to import and 3 pages left at a rate of 100 per page.

Merging user #2 with user #1... done.
Merging user #2 with user #1... done.
Merging user #2 with user #1... done.
Adding user #3... MySQL error: 1364
Field 'passwordconvert' doesn't have a default value
Query: INSERT INTO mybb_users (usergroup, additionalgroups, displaygroup, import_usergroup, import_additionalgroups, import_displaygroup, import_uid, username, email, regdate, postnum, lastactive, lastvisit, website, avatar, avatardimensions, avatartype, lastpost, icq, aim, yahoo, msn, hideemail, invisible, allownotices, emailnotify, receivepms, pmpopup, pmnotify, showsigs, showavatars, timeformat, timezone, signature, style, regip, totalpms, unreadpms, salt, password, loginkey, remember, showquickreply, ppp, tpp, daysprune, birthday, timeonline, away, awaydate, returndate, referrer, reputation, dst, buddylist, ignorelist, pmfolders, notepad) VALUES ('2,2', '', '2,2', '23,', '', '3', '3', 'Lecter', '[email protected]', '1149097893', '206', '1188292777', '1188292777', '', '557058392467118801386b.jpg', 'x', 'remote', '1188156132', '', '', '', '', 'no', 'no', 'no', 'no', 'yes', 'yes', 'no', 'yes', 'yes', 'd M Y H:i', '1.00', '', '0', '', '36', '0', 'Ra9chTEj', '3e7edcfc45bb441e31e98a7c77f704f6', '5b1CbTFtlnWuj2SLT6mqxdgJpJsogcUfvJBFKqYw9UqO7GkvdE', 'yes', 'yes', '0', '0', '0', '', '0', 'no', '0', '0', '0', '0', 'no', '', '', '1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can', '')

And a picture:



Does anybobody know how can I repair this?

PS: Sorry for my English.

[Ryan Gordon]

What MySQL version are you running?

[lukasamd]

Original server of forum*: 5.0.32
Local server**: 5.0.20a

* - my OVH account with phpbb by Przemo forum
** - I do a convert on local apache serwer with php5 and this mysql.

[Freddie Mercury]

Import phpBB 3 Users

Code:

Adding user #2... MySQL error: 1364
Field 'notepad' doesn't have a default value
Query: INSERT INTO mybb_users (usergroup, additionalgroups, displaygroup, import_usergroup, import_additionalgroups, import_displaygroup, import_uid, username, email, regdate, postnum, lastactive, lastvisit, website, avatardimensions, avatar, lastpost, birthday, icq, aim, yahoo, msn, hideemail, invisible, allownotices, emailnotify, receivepms, pmpopup, pmnotify, timeformat, timezone, dst, style, regip, totalpms, unreadpms, salt, passwordconvert, passwordconverttype, loginkey, avatartype, remember, showsigs, showavatars, showquickreply, ppp, tpp, daysprune, buddylist, ignorelist, away, awaydate, returndate, referrer, reputation, timeonline, pmfolders, signature) VALUES ('2', '3', '2', '2', '4', '5', '2', 'Freddie Mercury', 'Freddie [email protected]', '1236218504', '24', '1237572601', '1237572601', 'http://Freddie Mercury.blogspot.com/', '145|244', '', '1237408942', '16-10-1982', '', '', 'Freddie [email protected]', 'Freddie [email protected]', 'yes', 'yes', 'no', 'no', 'yes', 'yes', 'yes', 'D M d, Y g:i a', '00', '0', '0', '', '0', '0', '02bdb618c9da274c', '$H$9.l.GFqKuO.r6LsMnE0EyNhKjO6jt51', 'phpbb3', 'oblQsYxPdCEmRs2VDQXLkUF4jg8hSzoZlyPvfyoiCBePWI46GW', 'remote', 'yes', 'yes', 'yes', 'yes', '0', '0', '0', '', '', 'no', '0', '0', '0', '0', '0', '1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can', '')

?????

Code:

Field 'notepad' doesn't have a default value

Migration PHPBB3 for Mybb 1.2.14 - MySQL: 5.0.51a