PhpNuke Data Base to RavenNuke76 v2.02.02 Database

Worker Joined: May 07, 2005 Posts: 129

I am having problems importing the information from my old database for PHPNuke 7.6 with 3.1 patch to the new one for RavenNuke76 v2.02.02

I am trying to import the nuke_users but keep getting an error and my the database will not let me import the data.

Help???????????

p.s. here is the exact error message I keep getting

Quote:

MySQL said:

Column count doesn't match value count at row 1

Site Admin Joined: Jun 04, 2004 Posts: 6432

RavenNuke has NSN groups integrated, which adds an extra column to the users table. You can either remove that field temporarily and put it back after importing, modify the SQL to specify the field names on the insert statements (this is the way it should be done) or add the extra field to the insert statements with a default value.

Posted: Thu Jun 29, 2006 5:08 am

An alternative might be to run the installer but NOT the 'groups' bit, you should then be able to import your data and once everything is good, run the groups.sql in the installation folder directly in phpmyadmin to add those extra fields to save you hacking stuff about.
It's exactly the same result as kguske has talked about but I think it might be slightly easier for you if you are not too comfortable with altering stuff too much.

Posted: Thu Jun 29, 2006 6:22 am

Good point. I thought the groups stuff was built into the main RN installation routine.

Posted: Thu Jun 29, 2006 8:20 am

Had a problem running the installer, had to do things the hard way. Found the issue with importing the information to new Raven Nuke database, Old db had the extra table at the end "Karma" and I needed to remove it. Everything went ok after that.

I would have replied sooner but I was up until 3am exporting/importing data LOL

Thanks Guys!!!

RavensScripts

Posted: Thu Jun 29, 2006 8:32 am

Thats great news - not staying up till 3am but that you completed it on your own.
Oustanding job - I bet you have a big grin on your face this morning Smile

Posted: Thu Jun 29, 2006 8:36 am

Well not quite so big...not enough energy left for that LOL
Lots more work to do...Does anyone have an extra set of hands, monitor and keyboard hehehe.

Thanks Guardian Embarassed