Upgrading modified phpnuke 7.6 (patched) to revennuke 7.6

Regular Joined: Feb 25, 2006 Posts: 60 Location: England

Evening all.

Well, I've done some searching, but i think i'd prefer to start a dedicated thead for this one Smile

Fallen out with current web host for www.morphies.net so moving to a new host.

Decided to go with raven nuke for the new installation.

My plan was to do a afresh install of raven nuke, then bring my table data across, I;m only actually bothered about user, forums, downloads, weblinks and news - the usual really.

problem is the tables dont match up, i've altered the nuke_users table in ravennuke to match the colums of my 7.5 installation, and then imported the data. It comes accross ok - Your sql quirey has beene executed successfully. But the users are not actually in the table.

Any clues?

P.S new installation is @ filesharinginfo.com

P.P.S What kind of cost would I be looking at for one of you professionals to move it over for me? Very Happy

Sells PC To Pay For Divorce Joined: Posts: 5661

my 7.5 installation ?
and the topic says 7.6 patched....so what version do you mean ?

Posted: Thu Feb 01, 2007 2:49 pm

sorry, my phpnuke 7.6 with the chatserv patch.

heh multitasking Wink

Posted: Thu Feb 01, 2007 3:00 pm

There's a "for hire" forum to discuss issues related to that and see if someone will help.

A couple things on your post: If you are doing a Ravennuke installation then you need to make the tables match that. Altering the RN tables to match your 7.6 tables won't work.

You don't say what type of query you executed to import your data. I'm not sure that you couldn't just alter your existing table, with the data in it, to match the structure of RN. Then you wouldn't have to import anything. The same goes for your other tables.

Posted: Thu Feb 01, 2007 3:10 pm

So basically the best way to go is to backup my existing database, move the data into a second database and then alter that to match the Rn structure. That way i dont screw up my original site.

Then I can just pull the tables into the RN database.

Sound about right?

Posted: Thu Feb 01, 2007 3:30 pm

Yeah, that sounds like a plan to me. You don't need to hire anyone Smile

You won't really be "pulling the tables" ... you will just be altering them, with existing data, to match the RN structure. That way the RN programs will work with them.

Just thinking as I write; there are certain tables in the RN distribution, such as Groups, that may not be in your old distribution. So for any missing tables you'll need to load them separately.

Posted: Thu Feb 01, 2007 3:38 pm

well my plan was to alter the tables i actually want to keep.

ie the users table, forums, downloads links etc and replacing the tables that RN installs with my existing tables. - after altering my existing tables to match RN's

Posted: Thu Feb 01, 2007 5:08 pm

I think we are on the same page. But I hate to leave things to chance. So to be sure: what you are saying is that you will alter the tables that have data in them that you want to retain. The other tables you will just use straight from Ravennuke as they are loaded during the install process. I am just saying that because you do need ALL the tables that come with the distribution or else something will go wrong at some point.

Posted: Fri Feb 02, 2007 9:59 am

Thats the plan.

Run the RN installation in a fresh database (db1).

Copy my existing phpnuke database(db2) to a third database (umm db3 Smile

).

Alter the tables in db3 that i want to keep to match the tables in db1.

replace the tables in db1 with the tables from db3

Easy Smile

Edit: Question. Hmm not sure how to put this one, my sql knowledge is limited. Does the field layout have to be the same?

Example, lets say I have a field user_name in _users table in the RN db that has auto numbers and such, but in my existing phpnuke table the filed sint there, so to add it i'd be doing this:

Alter table `_users` ADD `user_name` TEXT NOT NULL;

would that still work, even though i have not toldit about the auto numbers and waht ever other settings it might have used?