Work Requested - Upgrade from 7.3 to RN Latest

Hangin' Around Joined: Jan 11, 2004 Posts: 37

Hello,

I have been running phpnuke CMS for 5 years now. All is well and unfortunately, my dedicated server's hard disk crashed and I am pretty much lost after spending all day searching forums.

I was immediately attracted to RN, I went straight to that instead of restoring it back to original state. However, I have run into a problem such as, "#1136 - Column count doesn't match value count at row 1"...

What I really want is to import users tables and the forum posts. I can take care of the other modules, etc.

What I did was create a fresh install of RN 2.02 (if I recall correctly but was latest at time of postng)

Updated database using regular phpnuke upgrade files from 7.3 to 7.6...

Still no luck, emptied out my users table (on RN new install) and attempted to add users table from old backed up database. (I backed up mysql database the day it crashed, thank god!)

What I'm asking here, providing that I have little time to spare (I should be sleeping now for work tomorrow) is to have someone do the upgrade for me which I will pay (via Paypal?) for the labor of importing old data into new database of RN's.

Please contact me via email: fmounts (at) gmail.com to arrange this, however I should be careful who I am giving access to, I would love to see your credentials and expertise on phpnuke CMS before I grant access.

Thank you.

registered · Posted: Thu Feb 23, 2006 8:38 am

Sounds like you need to compare the tables, probably some new fields in the users table that you need to add. I don't think anything in the table structure was changed in the forums, except maybe one thing for BBToNuke 2.0.15

Posted: Thu Feb 23, 2006 8:42 pm

Evaders99, I have seen your name everywhere with your expertise. You are the kind of person I would grant access to my server and is trustworthy considering you have your reputation at stake in the Nuke community.

I have the Redhat enterprise 3 OS reloaded yesterday. Would you be willing to humbly accept this assignment of importing my users and posts into RN's database.

There might be a few other things I may get stuck with but you will be paid for your time.

Please e mail me if you are interested, sooner the better as it's been down for the 2nd day and I'm losing money by the hour.

Thank you.

Posted: Thu Feb 23, 2006 10:49 pm

To play second fiddle, if he doesn't get back with you, let me know. I am up for it.

-sting

Posted: Thu Feb 23, 2006 11:40 pm

I replied by email - I'll see what I can do

Posted: Fri Feb 24, 2006 3:40 am

Thanks, after a day of waiting (I know you guys are busy but I wasn't Smile

I decided to give this a try and I think I got it working... but I haven't put it to the test yet.

I noticed that everyone is now a site admin in the forums but I'll try searching the forums first.

I did this the painful way, export then import from a 30 megs database.

I will explain what I did to make this happen but first I need my sleep!

I think I'm going to like RN, was worth the pain and took advantage of the down time to do the upgrading.

Thanks everyone and Raven.

Posted: Fri Feb 24, 2006 2:14 pm

Export and import is good approach. For such big databases, I recommend using the Big Dump script.

Posted: Sat Feb 25, 2006 9:59 pm

For anyone curious how I did this upgrade from 7.3 to 7.6:

Since my hard disk failed, I went straight to RN installation, tested it and worked.

I edited the config.php to point to my old 7.3 database, uploaded 7.3 to 7.4, 7.4 to 7.5, 7.5 to 7.6 upgrade files from regular Phpnuke CMS (/upgrade directory)

ran the upgrade files, after I was done, I edited config.php again to point to RN's CMS.

Then I did the import/export of users and forum posts, it worked beautifully! Except for that part where everyone's the site admin in the forums. But that can be fixed easily, I just have to search the forums. Possibly use the group fix script.

I will report what I have accomplished here when I finish this.

Posted: Sun Feb 26, 2006 1:54 am

Sounds like their user_level was changed. Admins should have a user_level = 2

Posted: Sun Feb 26, 2006 4:54 am

Figured this out... for some reason the site admin rank was set to -1

So, anyone who made 0 posts are marked as site admin and because the number of posts for each members was not imported over to new database for some reason.

Please refer to http://www.ravenphpscripts.com/postp61444.html in regards to that.