Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
afc
Worker
Worker



Joined: Aug 16, 2003
Posts: 107
Location: USA

PostPosted: Mon Nov 03, 2008 2:57 pm Reply with quote

One of my sites was still at RavenNuke(tm) v2.10.01 and upgrading it to RavenNuke(tm) v2.20.01 and checked it with compare_tables.php and got a ton of errors. I took over the site a few years ago and not sure what changes were made.

How do you fix these so i can finish upgrading to latest version.

The database you are using for comparison is: **************
You are comparing this data base against the structure of the database represented in fieldlist220.txt
field keys do not match nuke_bbsessions session_id : Base MUL Your table
field keys do not match nuke_bbsessions session_ip : Base MUL Your table
field keys do not match nuke_config sitename : Base PRI Your table
default values do not match nuke_config minpass : Base 8 Your table 5
field types do not match nuke_downloads_categories title : Base varchar(50) Your table varchar(100)
default values do not match nuke_downloads_categories title : Base No Default Your table default
field types do not match nuke_downloads_downloads title : Base varchar(100) Your table varchar(255)
null status not match nuke_downloads_downloads title : Base NO Your table YES
field types do not match nuke_downloads_downloads url : Base varchar(100) Your table varchar(255)
null status not match nuke_downloads_downloads url : Base NO Your table YES
field types do not match nuke_downloads_modrequest title : Base varchar(100) Your table varchar(255)
null status not match nuke_downloads_modrequest title : Base NO Your table YES
field types do not match nuke_downloads_modrequest url : Base varchar(100) Your table varchar(255)
null status not match nuke_downloads_modrequest url : Base NO Your table YES
field types do not match nuke_downloads_newdownload title : Base varchar(100) Your table varchar(255)
null status not match nuke_downloads_newdownload title : Base NO Your table YES
field types do not match nuke_downloads_newdownload url : Base varchar(100) Your table varchar(255)
null status not match nuke_downloads_newdownload url : Base NO Your table YES
field types do not match nuke_pages text : Base text Your table longtext
field keys do not match nuke_subscriptions id : Base PRI Your table
field keys do not match nuke_subscriptions userid : Base PRI Your table
null status not match nuke_users bio : Base YES Your table NO
null status not match nuke_users ublock : Base YES Your table NO
column not found in your table: nuke_users last_ip
column not found in your table: nuke_users user_login_tries
column not found in your table: nuke_users user_last_login_try
field types do not match nuke_wiw_m : Base Your table varchar(20)
null status not match nuke_wiw_m : Base Your table YES
field keys do not match nuke_wiw_m : Base Your table
default values do not match nuke_wiw_m : Base Your table No Default
extra options do not match nuke_wiw_m : Base Your table No Extra
field types do not match nuke_wiw_m : Base Your table varchar(20)
null status not match nuke_wiw_m : Base Your table YES
field keys do not match nuke_wiw_m : Base Your table
default values do not match nuke_wiw_m : Base Your table No Default
extra options do not match nuke_wiw_m : Base Your table No Extra



--------------------------------------------------------------------------------
tables processed: 111
fields processed: 876
fields not found on your system 3
tables not found in your system: 0


when you are finished with using these files please remove them from your server
leaving them there could give a nefarious person access to your passwords
 
View user's profile Send private message
fkelly
Former Moderator in Good Standing



Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Mon Nov 03, 2008 4:18 pm Reply with quote

Unfortunately there is no one shot solution to this problem. You can skip the wiw table at the end and just leave it; that gets generated dynamically I believe.

For the rest you more or less have to go through your tables and make them correspond to the official definition in RN 2.30. You can find that in the rn_core.sql file that's in the SQL directory under the INSTALLATION directory of your distribution. Then use PHPmyadmin to add fields or adjust the keys using the printout you provided as a guide. I'd go through it with a marker crossing them off as I adjusted them. Where you need to add a column ... like nuke_users_ip I would copy the attributes of the column from the rn_core.sql file. I'd be careful about certain situations where your table has longer varchar fields than are in the distribution. If you change the length and you have data that extends out to the longer length you will probably have it truncated.

Which is all the more reason to have a solid backup of your tables before you start.

Mysqldiff is a program that is much more sophisticated than the one-of compare tables routine I wrote. It will actually generate the SQL you need to modify your tables but you need to have two databases already installed (the 2.10 one and the 2.3 one) and you still need to be careful. You can search for discussion threads about that here.

Finally, just looking again over your listing. If you have installed some of the "enhanced" modules that might be available from other sites, they can modify your table structures. I'm thinking you might have NSN downloads. In that case you will have to decide ahead whether you are going to stick with the "enhanced" module or go with the one that comes in RN.
 
View user's profile Send private message Visit poster's website
evaders99
Former Moderator in Good Standing



Joined: Apr 30, 2004
Posts: 3221

PostPosted: Mon Nov 03, 2008 5:44 pm Reply with quote

We didn't create our own upgrade script for that version?

_________________
- Star Wars Rebellion Network -

Need help? Nuke Patched Core, Coding Services, Webmaster Services 
View user's profile Send private message Visit poster's website
fkelly







PostPosted: Mon Nov 03, 2008 6:03 pm Reply with quote

Good question. Yes we did. rndb_upgrade.php in the INSTALLATION folder. It should have taken care of those issues reported but in the back of my mind I'm thinking that if you had installed custom modules it might not have handled them. Don't have time to look at it off the top. The scripts were based on say 2.10 to 2.20 and so on but they don't have the "intelligence" to deal with intermediate changes. The compare tables programs do identify such changes but don't fix them.
 
afc







PostPosted: Mon Nov 03, 2008 8:20 pm Reply with quote

I did run rndb_upgrade.php. i know i can fix the download and nuke_wiw_m errors

If someone could do a script for just these i could fix the rest

field keys do not match nuke_config sitename : Base PRI Your table
default values do not match nuke_config minpass : Base 8 Your table 5

null status not match nuke_users bio : Base YES Your table NO
null status not match nuke_users ublock : Base YES Your table NO
column not found in your table: nuke_users last_ip
column not found in your table: nuke_users user_login_tries
column not found in your table: nuke_users user_last_login_try
 
Guardian2003
Site Admin



Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam

PostPosted: Tue Nov 04, 2008 12:36 am Reply with quote

The last three (column not found) should have been fixed in the RN 2.20.0 to 2.20.01 upgrade and if I remember correctly, the RN 2.3 upgrade script also checked for those and added them if they were not present so I don't know why they are not there.

Using phpMyAdmin or whatever database management tool your host provides, export the data (structure ONLY) for your nuke_config and nuke_users table and post it here so I can take a look.
 
View user's profile Send private message Send e-mail
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

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 ©