postnuke to RavenNuke76 v2.x Distro

Regular Joined: Sep 11, 2004 Posts: 84

Is it possible to move my postnuke members db over to this RavenNuke76 v2.x Distro version?

The reason I ask is because I have over 12,000 members.
I hope there is a solution, cause I cant stand pn!!

Posted: Sat Mar 04, 2006 5:21 pm

I am not aware of any already written conversion programs, but you could dump the database schemas (structures) and compare them to see what would need to be done to load them in.

Sells PC To Pay For Divorce Joined: Posts: 5661

lol i was just looking at them...
as far as i see they are to different...
but im sure someone can write a convert script for you

New Member Joined: Feb 20, 2006 Posts: 6

i had a postnuke installation and dumped it because the documentation was so poor. the way the themes work in postnuke is much different from phpnuke, which caused all sorts of confusion (for me, anyway).

Posted: Sun Mar 05, 2006 2:38 pm

kortoom, I dont think your alone here.
It looks like it would cause all sorts of confusion (for me, Too!!).

The ideas above all sound good, but gotta admit, its over my head.

Where would be a good place to HIRE someone to do this?
And what kinda fee would be acceptable for a job like this?

Posted: Sun Mar 05, 2006 4:05 pm

Let me help you out here, gbhughs: i know from tough experience that you should NOT hire anyone until you can explain to that person EXACTLY what they are to do. And you can't do that until you understand the system yourself. My recommendation is that you spend your time breaking and fixing your site and hiring someone only after you have a thurough understanding of how your site works. you and i have it easy, thanks to these opensource folks, because we have an entire documented system right out of the gate. Figuring out Raven is a zillion times easier than trying to learn *nix/php/mysql from the ground up, and once you get it, you can hire someone with confidence.

Posted: Sun Mar 05, 2006 8:55 pm

Good Advice kortoom.

I only want to move my users db and not the whole site.

Posted: Sun Mar 05, 2006 9:00 pm

Should be relatively easy. Compare the users table structure between those two and manipulate until they match. I doubt that PostNuke has changed it too much from phpNuke

Posted: Sun Mar 05, 2006 9:15 pm

Thanks evaders99......

I will try that and see how it goes.......

Posted: Sat Mar 11, 2006 2:14 pm

Ok for those of you who may have been following this, or have a pnNuke site and what to switch over to ravens package.
I found a way to get your users transferred over to this database.

Make a backup of PostNuke's _users table with phpMyAdmin, make sure you select "complete inserts", the backup will
have the table's structure and insert lines for all users, these will look something like:

Quote:

INSERT INTO `_users` VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', '1055706103', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, '12.0');

Here is where I kinda had a brain fart and so may you. pnNuke refers to users table as ` _users`
phpNuke refers to this table as `nuke_users`. So all you need to do here is put nuke in front of _users.

Copy those insert lines into a separate file and insert between `nuke_users` and VALUES the following:

Quote:

(user_id, name, username, user_email, femail, user_website, user_avatar, user_regdate, user_icq, user_occ, user_from, user_interests, user_sig, user_viewemail, user_theme, user_aim, user_yim, user_msnm, user_password, storynum, umode, uorder, thold, noscore, bio, ublockon, ublock, theme, commentmax, counter, user_timezone)

Your finished code should look something like this now:

Quote:

INSERT INTO `nuke_users` (user_id, name, username, user_email, femail, user_website, user_avatar, user_regdate, user_icq, user_occ, user_from, user_interests, user_sig, user_viewemail, user_theme, user_aim, user_yim, user_msnm, user_password, storynum, umode, uorder, thold, noscore, bio, ublockon, ublock, theme, commentmax, counter, user_timezone) VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', '1055706103', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, '12.0');

I uploaded over 18,000 members to my new Raven's RavenNuke76 v2.x Distro site, and so far it has worked like a charm.........

Good Luck