Current time: 07-23-2014, 03:41 AM Hello There, Guest! (LoginRegister)


 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
phpbb2 convert - users import
01-01-2008, 12:35 PM
Post: #1
phpbb2 convert - users import
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:

[Image: 3d3adea6dbf87853m.gif]

Does anybobody know how can I repair this?

PS: Sorry for my English.

My MyBB Addons - GitHub

Polish MyBB Support - MyBBoard.pl
Visit this user's website Find all posts by this user
01-01-2008, 04:43 PM
Post: #2
RE: phpbb2 convert - users import
What MySQL version are you running?
Visit this user's website Find all posts by this user
01-01-2008, 04:49 PM
Post: #3
RE: phpbb2 convert - users import
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.

My MyBB Addons - GitHub

Polish MyBB Support - MyBBoard.pl
Visit this user's website Find all posts by this user
03-24-2009, 12:58 AM (This post was last modified: 03-24-2009 04:03 PM by Freddie Mercury.)
Post: #4
RE: phpbb2 convert - users import
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

Huh
Visit this user's website Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication