User Migration Error
bgaray - July 9, 2009 - 04:07
| Project: | phpBB2Drupal |
| Version: | 6.x-2.0 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
* user warning: Duplicate entry '2' for key 1 query: INSERT INTO phpbb2drupal_temp_user (user_id, uid) VALUES (2 , 1) in /hsphere/local/home/ravenrid/waterfront.mentalrose.com/modules/phpbb2drupal/phpbb2drupal.module on line 318.
* user warning: Unknown column 'user_type' in 'where clause' query: SELECT user_id FROM phpbb_users WHERE ( user_id > 2 AND user_type <> 2) ORDER BY user_id in /hsphere/local/home/ravenrid/waterfront.mentalrose.com/modules/phpbb2drupal/phpbb2drupal.module on line 325.
* There were no users found: Aborting script
#1
I assume this was on a second run to migrate the data? That error message means that the phpbb admin has already been imported.
If so, you will either need to uninstall and reinstall the module, or clear the relevant tables.
What version of phpbb are you importing from?
(and it always helps to give as much information as possible - it is very hard to provide too much info.)
#2
I just ran into this issue trying to import from phpBB2. "user warning: Unknown column 'user_type' in 'where clause' query: SELECT user_id FROM phpbb_users WHERE ( user_id > 2 AND user_type <> 2) ORDER BY user_id in {path snipped}/phpbb2drupal.module on line 325."
Perhaps in phpBB2 there is no 'user_type' - instead there is 'user_level'?
#3
the 2.0 release is to migrate from phpbb 3.
If you want to migrate from phpbb2, you need to use the 1.x release series.
#4
Thanks, nbz. I figured that out when I read the docs more carefully...
#5