PhpNuke 7.9 issues

Worker Joined: Dec 22, 2005 Posts: 158

Man, you don't need my help Smile

It sounds to me like you have it under control! I think it will be hard fought to make it perfect, and at the most some of your field data may be truncated. You sound like me, sometimes I drive myself to distraction trying to get it the way I want it, but I learn something new almost everytime i do it. lol

Regular Joined: Jan 20, 2006 Posts: 84

It's taken me 2 weeks to get where I'm at now Taz and I'm only starting to understand half of what I've done. I think when it comes to the production site migration I do this.

Temporarily shut the site down.
Download the current database
Load current database in virtual machine pn76 database
On my Virtual machine (/html = pn79) run the downgrade script)
since all the work I'm doing now will carry over I dump the data from the pn76 database and import it into the raven database (not structure, just the data)
Then over on production side create new table for raven
Dump data over to the new raven table
Load over the raven files and modules and everything else I've already done
Re-enable the site.
We'd now be up on Raven 76.

Did I miss anything?

Posted: Mon Feb 20, 2006 1:36 pm

I'm sorry tweaker, I'm getting mixed up with all the databases and the pn76 /html=79 stuff.

It sounds to me like you are doing more work than necessary, can anyone else agree or disagree ? ? ?

I would think you could do this :

1. Temp shut down site.
2. Download current database (this is the 7.9 database correct?)
3. Run downgrade database script on this data (to get the data to look like the raven 7.6 )
4. on production site, make sure all desired modules installed,
5. Import data from downgraded tables.

Posted: Mon Feb 20, 2006 1:41 pm

but there are discrepencies which I found (see earlier note) that they said would be easier if the database's structure 'did' match. That's what I'm going through now. I'm adding the final bit of RN data (the countries) to the database as we speak. Then I get to test it.

Posted: Mon Feb 20, 2006 1:49 pm

Yes, and I thought that is why Guardian said to run the downgrade script, (which you have done) to get them close, I don't think they are going to be perfect, but from what I am hearing, the differences may be small or insignificant. To me it sounded like you are trying to combine a base 7.6 php-nuke, a php-nuke 7.9 and a raven 7.6 together, when all you should have to do is downgrade your php-nuke 7.9 with the script, make sure any tables you have data for in your downgraded data, dont have data that would be duplicated in the raven distro, and import that data from the 7.9 downgraded database.

lol it's hard to help out over forums sometime, I hope your not getting too confused. Smile

I appologize if I am not helping much.

Posted: Mon Feb 20, 2006 2:01 pm

No, I did do the downgrade and tried to do the migration to the raven76 and it bombed badly. So that's where you stepped in and I said I would give it another day. That's what I've been doing all day so far.

Posted: Mon Feb 20, 2006 2:16 pm

I think your going to end up with a huge ball of wax when trying to compare Raven's distro, against a base php-nuke 7.6 database. I don't even think I would want to do, that. I would not make any changes to the data structure of the raven distro by comparing it to a base php-7.6 distro. I would attempt to export the downgraded database, table by table and re-import each separatley and check for erros.

When you say the 'migration' bommed, what exactly does that mean? Did one table have a huge amount of errors? I would attack the problem from that end instead of doing what your doing. I can REALLY understand why your frustrated now Smile

Do you have any hair left? Wink

Posted: Mon Feb 20, 2006 2:56 pm

Well I can't say ALL went bad.

It got all the way down to nuke_users and I got this error:

#1054 - Unknown column 'user_group_cp' in 'field list'

So I saw where it was in the phpnuke76 database but not in the ravennuke database.

This begs to ask this question.

When it comes to the 'order' of the tables, it matters, right?

Posted: Mon Feb 20, 2006 3:01 pm

So you probably could use that database, if you figured out what user_group_cp is, that's kinda what I meant by editing the sql script, although I guess I didn't explain myself very well. Run the import, review any errors, rollback the last uncomitted transactions, and edit the script to take out that line that enters that field. Re-run the import script. I have no idea what that field is for, but I think you were probably 80% there when you decided to give up on that database.

I'm not sure I know what you mean when you say order of the tables.

Posted: Mon Feb 20, 2006 3:17 pm

Well, I got it working, Raven data and all. I've got to wait till tonight to have a user test it whether he can log in.

If he can then I've got to figure out how to get this massive db over to the server (no shell access Sad

And those freaking countries, man do they take a while!

But I think I definantly got it and hopefully my Gallery2 issue will be fixed by then as well over on that server. Thanks for all of your help. I'm just surprised I actually got it all working!

Posted: Mon Feb 20, 2006 3:20 pm

Great job! Shoot I'm not suprised, you sound pretty knowledgeable!

Posted: Mon Feb 20, 2006 6:01 pm

I think I may have a problem and I need Raven to confirm this for me.

The table structures for phpnuke 7.6 and raven nuke 7.6 build 2, do they share the same columns or are there some in raven nuke that aren't in there because they are either obsolete or not necessary?

I thought about it at dinner time today because the issue would be if I'm saying in SQL that table A has fields 1, 2, 3, 4 and I'm writting 1, 2, 4 how will the system function? Is it going to fail cause that field isn't being used or isn't there?? Does this make any since to you guys?

Posted: Mon Feb 20, 2006 6:33 pm

In essence, yes it will fail if there is a mismatch with the number of fields in a specific table.
The only difference you should see between a virgin phpnuke 7.6 table schema and that of RN7.6 is the extra groups fields due to RN having NSN Groups installed.
You can update from virgin nuke 7.6 to RN7.6 by running the groups sql file which you can find in the installation folder.

Obviously I havent mentioned the tables for Sentinel as this would require a more detailed response and I think from what you have posted so far, you have got that covered.

Posted: Mon Feb 20, 2006 6:45 pm

well i never had sentinel on my 79 so i don't have to worry about that.

But I'm downgrading from 79 to 76 over to rn76. Any difference there?

Posted: Mon Feb 20, 2006 7:05 pm

Basically, what's the smartest thing for me to do in my situation, step wise? I got my beta site I can destroy and revert back to as many times as I need. I can add tables, remove.. you tell me what I need to do to make the data I have in nuke 7.6 work in RN76.

Posted: Mon Feb 20, 2006 7:15 pm

http://www.ravenphpscripts.com/postt8440.html

Posted: Mon Feb 20, 2006 7:47 pm

Taz,

Is it you or just me, this would have been sooo helpful like, 12 hours ago. Smile

You're a godsend Guardian2003!

Posted: Mon Feb 20, 2006 7:58 pm

But just think of everything you have learned in that time Wink

Posted: Mon Feb 20, 2006 9:22 pm

OK I found a module that tell me what my version number is. Currently it reads "7.6".

Is there a way to find out or make sure that everything on my side is setup for NukeRaven with the 7.6 2.0 patch this fix and working that?

Posted: Tue Feb 21, 2006 5:35 am

The link I posted above tells your everything you need to do.
If you have used any third party modules that have altered the core nuke database you will need to re-add those and re-insert the data for those.

If you have third party modules that use their own full tables you can just copy those across as the data would not be accessed until you reload the appropriate module files.

Posted: Tue Feb 21, 2006 7:14 am

I did follow those instructions (took an all of about 20 minutes total). So I'll get with it today to dbl check all my external modules and add ons before I move forward with the real move.

BTW: Right now I have everything posting under /html following the traditional structure. Is there any way I can move the final result to just the root / and redirect people who go to /html to end up at /? Does that make any since or should I just keep the /html and not worry about it?

Posted: Tue Feb 21, 2006 7:45 am

You can move the files wherever you want but bear in mind you will have to change the base url in nuke admin->preferences and forum admin->configuration

Posted: Tue Feb 21, 2006 7:52 am

Oh right I would have to do that part, you're right. But which is advisable? Keeping it an /html or /?

Posted: Tue Feb 21, 2006 8:50 pm

Hey sorry, I'm travelling, on site with a client doing an installation. I have not had a chance to read anything yet Smile

I told you these guys know their stuff! I think they were just letting us struggle so we could learn more! haha!

Anyway, I gotta catch up on my reading, and see if I can get any of my problems solved Smile