Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
pdoobepd
Worker
Worker


Joined: May 07, 2005
Posts: 129

PostPosted: Wed Jun 28, 2006 9:42 pm Reply with quote

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

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Thu Jun 29, 2006 4:39 am Reply with quote

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.

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
Guardian2003
Site Admin


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

PostPosted: Thu Jun 29, 2006 5:08 am Reply with quote

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.
 
View user's profile Send private message Send e-mail
kguske
PostPosted: Thu Jun 29, 2006 6:22 am Reply with quote

Good point. I thought the groups stuff was built into the main RN installation routine.
 
pdoobepd
PostPosted: Thu Jun 29, 2006 8:20 am Reply with quote

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
 
Guardian2003
PostPosted: Thu Jun 29, 2006 8:32 am Reply with quote

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
 
pdoobepd
PostPosted: Thu Jun 29, 2006 8:36 am Reply with quote

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 worship speedtype
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

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 ©