Current time: 04-19-2014, 07:01 AM Hello There, Guest! (LoginRegister)


 
Thread Rating:
  • 1 Votes - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
(phpBB2) Not all users converted
05-25-2008, 02:47 PM (This post was last modified: 05-25-2008 02:49 PM by Ziyphr.)
Post: #1
(phpBB2) Not all users converted
phpBB2 to MyBB again. This is my final thread about this but I wanted to keep the issues separate for clarity. Move this to general support if you feel it's more appropriate.

Of my 2000 users there were 20 that did not get converted. There was nothing special about these ones and but they were always not converted after multiple attempts. Their threads were there but the poster was listed as unregistered.

To fix this what I had to do was copy these users into a new table and run the conversion again, but with the same MyBB target database. Dependent tables had to be copied as well. With only 20 users in this phpBB2 table it converted these into my target database and fixed the problem. This shows there was nothing special about these people, they just weren't getting picked up for some reason.

The side effect of this was the threads and posts by these 20 users would still be show them as unregistered. To fix this I ran two update queries to reconnect the threads and posts to the newly added users. Anyone else experiencing unlinked users will find this useful.

Code:
UPDATE mybb_threads,mybb_users SET mybb_threads.uid = mybb_users.uid WHERE mybb_threads.uid=0 AND mybb_threads.username=mybb_users.username

UPDATE mybb_posts,mybb_users SET mybb_posts.uid = mybb_users.uid WHERE mybb_posts.uid=0 AND mybb_posts.username=mybb_users.username
Find all posts by this user
07-14-2008, 01:40 AM
Post: #2
RE: (phpBB2) Not all users converted
yup, i have the same problem, but i only have about 100 users, it only doesn't import the newest registered one, as far as i can tell anyway, and this is using the PHPBB3 merger
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