Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help
Author Message
tweaker
Regular
Regular


Joined: Jan 20, 2006
Posts: 84

PostPosted: Tue Feb 14, 2006 1:10 pm Reply with quote

So I made a virtual machine and loaded my whole website locally with multiple copies of my database (woohoo).

So I go to my site as admin and perform the downgrade78-76.php and I get the following error.



Operation Status!

--------------------------------------------------------------------------------
- ALTER TABLE nuke_modules failed

--------------------------------------------------------------------------------
Operation Complete!
You MUST upload the PHP-Nuke 7.6 files to your server for the downgrade to be complete.


Well, if the nuke_modules failed then it wasn't successful right?! I mean, I can't have a working 7.6 site without this.
 
View user's profile Send private message Visit poster's website Yahoo Messenger ICQ Number
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Tue Feb 14, 2006 1:41 pm Reply with quote

Well your site will still work, but you may have problems adding new modules. Please post the structure of your modules table

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
tweaker
PostPosted: Tue Feb 14, 2006 2:02 pm Reply with quote

Well what I really want to get to is NR76 and not PN76. That's the actual goal. I'll post my structure in next post.
 
sting
Involved
Involved


Joined: Sep 23, 2003
Posts: 456
Location: Somewhere out there...

PostPosted: Tue Feb 14, 2006 7:10 pm Reply with quote

Take a look at the SQL for the RN nuke_modules and compare it to the PN 76. Then alter accordingly.

-sting

_________________
You see - I told you I wasn't paranoid. They were really out to get me. 
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
tweaker
PostPosted: Wed Feb 15, 2006 6:58 am Reply with quote

Are the nuke_modules the only difference in that respect? All else is the same cause I'll do that! That wouldn't be no sweat. It was more of the posts and news we were afraid of losing. Sentinel was more of the bargain for us in this respect. So far it looked like it took our themes just fine.
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9453
Location: Arizona

PostPosted: Wed Feb 15, 2006 8:30 am Reply with quote

tweaker, for RN762.02 you will need to pay close attention to these tables: nuke_message, nuke_blocks, nuke_modules. Each of these tables were modified to implement NSN Groups. I am not aware of any other core nuke table changes.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
tweaker
PostPosted: Wed Feb 15, 2006 8:59 am Reply with quote

OK I'll be sure to look at all 3 of these in comparing. Do you guys have a good tool (besides phpMyAdmin) to do comparison database table reporting?
 
tweaker
PostPosted: Wed Feb 15, 2006 11:03 am Reply with quote

OK here's what I've discovered.

====
NR76 vs PN76

TABLE: nuke_message
DIFFERENCES:

NR76 has an extra field defined:

groups - text - latin1_swedish_ci - blank - No - blank - blank


TABLE: nuke_blocks
DIFFERENCES:

NR76 has an extra field defined:

groups - text - latin1_swedish_ci - blank - No - blank - blank


TABLE: nuke_modules
DIFFERENCES:

NR76 has an extra field defined:

groups - text - latin1_swedish_ci - blank - No - blank - blank

====

So I guess its left me asking what is with these groups and are these groups preventing me from merging my data into the NR76 tables?
 
montego
PostPosted: Wed Feb 15, 2006 8:52 pm Reply with quote

It means that you need to make your INSERT sql statements for your data match these table definitions. The other alternative is to remove these properties, load your data, and then add them back in exactly as they were before. You can also find the appropriate ALTER TABLE statements towards the bottom of the INSTALLATION/sql/rn76_nsngroups.sql to get these fields back into the RN76 tables (note the "R" before the "N" in my "RN76" Wink ).
 
tweaker
PostPosted: Sat Feb 18, 2006 10:52 pm Reply with quote

So I downgrade my version from 7.9 to 7.6, make the changes in the phpNuke 7.6 tables (alter them) to match that of the RN76 (got it right this time) and import the data. Then of course, pray all goes well?
 
montego
PostPosted: Sun Feb 19, 2006 7:24 am Reply with quote

tweaker, that sounds like an excellent plan. Probably a ton easier than trying to insert a column into your exported data. Might as well get the DB structures matching first.
 
tweaker
PostPosted: Sun Feb 19, 2006 7:40 am Reply with quote

wicked. Then I'm going to do that this morning. If I get any errors in the downgrade should that be expected cause I'm going from 7.9 to 7.6 and not 7.8. to 7.6?

Also another important question. When do overwrite my 7.9 files with 7.6 or should I just do the data merge and leave the 7.9 alone so I could restore. The raven database is a seperate db.
 
montego
PostPosted: Sun Feb 19, 2006 8:10 am Reply with quote

Quote:
If I get any errors in the downgrade should that be expected cause I'm going from 7.9 to 7.6 and not 7.8. to 7.6?


I have never had to downgrade, so cannot tell you for sure. But, others here have done this and gotten help, so search for your questions/ answers first and if you cannot find it, ask.

Quote:
Also another important question. When do overwrite my 7.9 files with 7.6 or should I just do the data merge and leave the 7.9 alone so I could restore. The raven database is a seperate db.


Always, always, always, always, ... take a complete back-up of your scripts files and database before doing something this significant. Even if I do minor changes, depending on the change, I may take a complete db backup or just backup a few tables and then I also back up my impacted script files. It is just good change management practice.

I will make the assumption that you will want to keep your current web structure and so you will need to overwrite your 7.9 files. I would recommend, since your 7.6 db is a new one, concentrate on getting that db loaded with the new data first.

If you have the luxury of using a subdomain, you could even install the RN76 files under the sub-domain and completely test your new site completely before finally overwriting your original 7.9 structure. If you do not have that luxury, that is where having good backups could become your saving grace...

Good luck!
 
tweaker
PostPosted: Sun Feb 19, 2006 9:41 am Reply with quote

Well what I was gonna do is this.

Make a backup of my live data and put it on my test server.

Then make a duplicate of it for the 7.6 build.

Make a new folder called /html76 and put the latest installation of /html76 in there and configure it to point to the duplicated database. Then run the downgrade78-76.php script before hitting that site for the first time. Once it's been downgraded add those few tables to it and then merge over a few tables at a time the downgraded 76 into the /raven database.

This way I still have my origional everything and if something gets totally messed up I've got a snapshot of my virtual machine that puts me back where I first started.
 
tweaker
PostPosted: Sun Feb 19, 2006 10:51 am Reply with quote

OK here's what I had to do.

I couldn't downgrade from my /html76 installation so I changed the config.php on my 7.9 to match the 76's database. Did the downgrade. Got that same error about nuke_modules not being transfered or something, I think that was covered in another thread.

But I switched my /html back to the regular database, it's running at 7.9.

/html76 is running on the nuke76 database.

Now I'm going to insert those 3 tables before I do my conversion over from nuke 76 to rn76.

All this right so far?
 
tweaker
PostPosted: Sun Feb 19, 2006 11:01 am Reply with quote

OK I may be working too fast for threads so it's a good time to take a break. Here's what I've done.

In my earlier post in this thread "Posted: Wed Feb 15, 2006 12:03 pm" I figured out what was different in the tables.

My phpnuke76 database now incorporates those new fields. So in "theory" I should be able to export the data without problems or issues.

Now, when exporting the data, I do NOT want to export any of the nsngr stuff do I. I just want the "data" itself from the tables from modules that I use to be put into it, don't I. This way I don't screw anything up with sentenial and we can move forward.
 
tweaker
PostPosted: Sun Feb 19, 2006 2:16 pm Reply with quote

OK I'm at a very cruicial point in this conversion and need to be very VERY clear on what I'm doing.

I found a program called WinMerge that allows me to see the differences between files. There are a number of differences between phpnuke76 structure and the raven76 structure. Am I to correct these before moving the data or is this something you leave alone?

Meaning, the RavenNuke is right, there will be differences we just want what's common. I don't know cause I'm looking at one here like nuke_headlines. The only difference is

Quote:

KEY hid (hid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


and this is on the phpnuke76 side and not the raven76 side.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©