2014-08-05, 12:59 PM
Hello and thanks for your time. I am triyng to complete the migration of my forum in PhpBB3 to MyBB with the Merge tool. MyBB and Merge with the last stable versions. I have no problems with the configuration of the database settings as you can see in the next print screen:
But call my attention that "database settings" is crossed with a line in all the modules.
When I run the users module, I have the following error:
If I am understanding well, the values in the database of PhpBB3 are not the same of the values of the MyBB database. I'm assuming that some values exceeds the ones on the MyBB database. Is that right?
I try with the solution proposed in this thread:
http://community.mybb.com/thread-73642-post-537026.html
Reversing the mods of PhpBB3 but the problem persist. Also try to change the values of MyBB database entries to varchar, but that gave me an error; is not allowed for this kind of variables.
I try with this other solution too:
http://community.mybb.com/thread-85766-p...#pid627753
But don't work either. I just have 30 users to move in the database. This is not a considerable amount of information for the server I guess.
It's maybe a problem with values on PhpBB3 database that exceeds the ones on the MyBB? Or some problem with special characters in the name of the users like "_" or the large of the nicknames?
Sorry for my bad english and thanks in advance for your help.
But call my attention that "database settings" is crossed with a line in all the modules.
When I run the users module, I have the following error:
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1265 - Data truncated for column 'usergroup' at row 1
Query:
INSERT INTO mybb_users (usergroup
,additionalgroups
,displaygroup
,import_usergroup
,import_additionalgroups
,import_displaygroup
,import_uid
,username
,password
,salt
,loginkey
,regdate
,lastactive
,lastvisit
,website
,showsigs
,signature
,showavatars
,timezone
,avatardimensions
,avatartype
,avatar
,lastpost
,icq
,aim
,yahoo
,msn
,hideemail
,allownotices
,regip
,lastip
,longregip
,longlastip
,language
,passwordconvert
,passwordconverttype
,postnum
,invisible
,birthday
,birthdayprivacy
,subscriptionmethod
,receivepms
,receivefrombuddy
,pmnotice
,pmnotify
,showquickreply
,ppp
,tpp
,daysprune
,timeformat
,dst
,buddylist
,ignorelist
,style
,away
,awaydate
,returndate
,referrer
,referrals
,reputation
,timeonline
,showcodebuttons
,totalpms
,unreadpms
,pmfolders
,notepad
,threadmode
,showredirect
,dateformat
,dstcorrection
,warningpoints
,moderateposts
,moderationtime
,suspendposting
,suspensiontime
,suspendsignature
,suspendsigtime
,coppauser
,classicpostbit
,loginattempts
,usernotes
) VALUES
If I am understanding well, the values in the database of PhpBB3 are not the same of the values of the MyBB database. I'm assuming that some values exceeds the ones on the MyBB database. Is that right?
I try with the solution proposed in this thread:
http://community.mybb.com/thread-73642-post-537026.html
Reversing the mods of PhpBB3 but the problem persist. Also try to change the values of MyBB database entries to varchar, but that gave me an error; is not allowed for this kind of variables.
I try with this other solution too:
http://community.mybb.com/thread-85766-p...#pid627753
But don't work either. I just have 30 users to move in the database. This is not a considerable amount of information for the server I guess.
It's maybe a problem with values on PhpBB3 database that exceeds the ones on the MyBB? Or some problem with special characters in the name of the users like "_" or the large of the nicknames?
Sorry for my bad english and thanks in advance for your help.