By n00tz on

I'm having some issues converting my phpNuke site to Drupal. I've narrowed the amount of porting over to Drupal I want to keep to just two nuke portions. The Users and the Forums. But if need be, I can just convert the nukeBB to a PHPbb forum and link it in Drupal (but that is not the preferred route). I've got a machine at home that I'm doing most of my testing of Drupal on, and then working the same thing on the FQDN machine. Right now i've got my nuke_users database imported into the drupal database on my home machine. Here's what's happening when I try to import user database information from nuke->drupal:

mysql> INSERT INTO users (uid, name, pass, mail, signature, timezone, language, picture)
    -> SELECT user_id, name, user_password, user_email, user_sig, user_timezone, user_lang, user_avatar
    -> FROM nuke_users; 
ERROR 1062: Duplicate entry '' for key 2

This is my highest priority issue drawing the line between converting to Drupal and sticking it out with PHPnuke.

My second priority is to bring in allllll the forum activity to Drupal's forums, or just find a way to put all my forum stuff into PHPbb and load it as some kind of module in Drupal. So I guess I'm asking what my options are to bring my old forum content to my new CMS.

I'm absoluetly loving drupal so far. Making: http://www.daltongamers.net/ turn into my drupal sandbox: http://www.daltongamers.net/drupal/ so far is just being a hassle. I am confident it will be worth it in the end. Any help would be greatly appreciated.. Thanks!

Comments

nevets’s picture

nevets commented

For users the two key fields that need to be unique are uid and name. From the ordering of the keys I am guessing the key 2 is referering to the key on name. It suggests that name in PHPnuke is non-unique.

lingoprogrammer’s picture

lingoprogrammer commented

Here is a script that might be worth a look at. It has worked for many people.

http://www.quillem.com/nuke2drupal

n00tz’s picture

n00tz commented

thanks for the suggestion.

lingoprogrammer’s picture

lingoprogrammer commented

Cool! Your the first person I helped here... I'm in the midst of migrating myself. Good luck!

Zhen-Xjell’s picture

Zhen-Xjell commented

PHPNuke by default has auto_increment set on its key for uid/user_id.

"describe" or "explain" your table and check your keys.

Since you are rolling over unique IDs from nuke_users into users, you may want to drop "auto_increment" on users if it exists. There should be no duplication.

Microsoft MVP Windows-Security
http://castlecops.com

jasmine’s picture

jasmine commented

PHPnuke does accept non unique usernames, for example if I make a registration with my name as username (jasmine) email (myemail@someplace.com) and try to do it a second time with same username (jasmine) but with a different email address this will make two users accounts.
Upon converting to Drupal, with any script you can use, the two accounts with same username will cause an error in the database since this is not possible with Drupal.
Wath I have done: with phpmysql (or any mysql editor) take a look at double username (you can do that by ordering them by username), rename the repeated ones to something you like best (in my case I renamed them as jasmine1, jasmine2, etc.) and after run the script.

One other suggestion, I have run phpbb2drupal (Written by Feodor modified for drupal 4.5.2 and phpbb 2.0.11-2.0.13 by Alexander Mikhailian) and made little convertion to it directly into my database but bewhare: before any modification make a backup of your database and then try.

I've had to modify things inside the scripts since I was udating from a osc2nuke (phpnuke 6.9 based) CMS, wich uses tables named nuke_bb instead of phpbb_, but this was not the biggest shot (text editor -> search and replace).

I had to work on a database without having installed yet a drupal CMS on my domain, so the DB was not filled in after install, just the basic data, I had to use the script in small parts, and adapting it to what the db error came out.

I know this sounds difficoult (and ridicolous!), but my domain is out of my control at this moment (so could not install drupal), and I had to arrange to recover my users, their posts and comments (to the forums). In the next days I wil recover articles, news, links and (hopefully) the link to their pictures (in albums) ...

If succesful I'll give my indication (hopefully) ;)

Hope to be useful to you all (and thanks to the all the contributors of this great CMS!!!!!!!!!!)

Jasmine

Ygor’s picture

Ygor commented

I Wish good lucky for you guys, i stopped my conversion from phpnuke to Drupal - when it comes to convert from latin1_swedish_general_ci to UTF-8 !!!

--> I still have a lot of bugs on my stories - But all the things i tryed to convert it doesn´t work.

I still have errors on çãõáéíúý ...

jasmine’s picture

jasmine commented

Well, sorry for the delay, but I did it and I did even an upgrade to drupal 4.7 (was not released at the time of my older post) ...
If needed can help.
My site's are www.enfemme.it and www.ireos.org (You can visit them if you don't bother other sexuality or gender)
Good luck
Jasmine