Help with Database

New Member Joined: Jul 04, 2009 Posts: 14

Ok so this is a fresh install of Raven Nuke 2.30.02. I used to have phpnuke 8.0. Now my question is, how to use I use the nuke_users database from phpnuke 8.0 to work with this raven nuke. I have tried importing the nuke_users database but it seems there are errors and the database table that raven nuke uses is different. I am not good with this sort of stuff and barely learning how to do all this.

Posted: Tue Aug 25, 2009 5:48 am

You need to ensure your two database structures are the same. This is where a tool such as mySQLDiff comes in useful. Wink

Posted: Tue Aug 25, 2009 6:04 am

I have tried that but when in the source page when I click next after entering all the correct information I get this error.

Warning: trim() expects parameter 1 to be string, resource given in C:\xampp\htdocs\mysqldiff-1.5.0\library\database.lib.php on line 73

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\mysqldiff-1.5.0\library\database.lib.php:73) in C:\xampp\htdocs\mysqldiff-1.5.0\save.php on line 168

Posted: Tue Aug 25, 2009 9:43 am

you can also use a php-nuke downgrader , you need to downgrade from 8.0 to 7.6

Posted: Tue Aug 25, 2009 2:52 pm

Where can I find this down grader? I have searched and only found as high as 7.8

Posted: Tue Aug 25, 2009 3:05 pm

http://svn2.assembla.com/svn/evoturkish/upgrades/PHP-Nuke%20Standard%206.5%20-%208.0/Nuke%20DOWNgrade%20to%207.6/

Posted: Tue Aug 25, 2009 3:28 pm

Ok I did the downgrade but my Table structure for table `nuke_users` still doesn't work right. Nothing changed with the downgrade. Members still cant register, they get this error after activating "Something screwed up... don't you hate that?" Then there account disapears as if they never even registered.
Since I'm kinda new to this stuff, is there any way I can send my Table structure for table `nuke_users` that is from phpnuke 8.0 to RavenNuke 7.6 to somebody to make them compatible? This is all I need, I dont care about anything since I already lost but I want to keep my users acccounts.

Posted: Tue Aug 25, 2009 3:31 pm

did you checked the user preferences in: http://www.yourdomain.com/admin.php?op=yaAdmin

Posted: Tue Aug 25, 2009 3:34 pm

you can post your nuke_user table in here + the insert from the anomynous user

Posted: Tue Aug 25, 2009 3:35 pm

Yes I have, it works right with the Table structure for table `nuke_users` that ravennuke came with. But I want to keep the accounts from my phpnuke 8.0 so what I did was take the 'nuke_user' from phpnuke and dropped it into the ravennuke DB. It seemed to work fine at first, members logins works perfect and thought I was fine untill new members try to register.

Posted: Tue Aug 25, 2009 3:39 pm

So it work now or not?

Posted: Tue Aug 25, 2009 3:40 pm

No it doesn't work, new members cant register if I use the DB from phpnuke 8.0

Posted: Tue Aug 25, 2009 3:41 pm

can you please post the INSERT of the anomynous user you currently use , so from your phpnuke 8 to 7.6 converted database

Posted: Tue Aug 25, 2009 4:02 pm

Ok here they are
http://phatco.netne.net/phpnuke8.0.sql
http://phatco.netne.net/Raven7.6.sql

Posted: Tue Aug 25, 2009 4:15 pm

with your 7.6 database all seems fine atleast it is usable.

Posted: Tue Aug 25, 2009 4:17 pm

you might not got the whole downgrade idea...
you need to put the downgrade file into your working phpnuke 8 version and run it ( make a backup first)
then your database should already be excact the same as a ravennuke db , except the aditional tables you need to load , like the ones for sentinel,nukeseo etc etc... it is al described in the install documentation.

Posted: Tue Aug 25, 2009 4:18 pm

OK now how to I get my phpnuke user DB to work with ravennuke DB. Do you want the to see the phpnuke user DB with all the accounts loaded in it? All I want is the phpnuke DB loaded into the ravennuke DB.

Posted: Tue Aug 25, 2009 4:21 pm

then put the downgrade file into your running php-nuke 8 site and execute it.
make a BACKUP first of your database with ALL tables and its content.
The only thing you have to do after is add the EXTRA ravennuke tables as described in the installation instructions...
load the new converted 7.6 ravennuke database for your ravennuke site and that's it.

Posted: Tue Aug 25, 2009 4:21 pm

you can send me the file.. i send you a PM how to... but i need to get to sleep now.. tomorrow i must work.

PS: i hope it isnt in hebrew or other alien language lol

Posted: Tue Aug 25, 2009 4:23 pm

I forgot to give you the downgraded file
Here it is after the downgrade http://phatco.netne.net/phpnukeDowngrade.sql

Posted: Tue Aug 25, 2009 4:27 pm

ok i see your problem .. gotyo your downgraded database , the one where you executed the downgrade file for... yes?
Open the table nuke users ( assuming phpmyadmin) and delete all for:

Quote:

`user_items` text,
`user_effects` varchar(255) default NULL,
`user_privs` varchar(255) default NULL,
`user_custitle` text,
`user_specmsg` text,

Then all should work.

The problem is you use an edited nuke_users table , it uses stuff not default nuke 8

Posted: Tue Aug 25, 2009 4:34 pm

it would not hurt to TRY to run the downgrader AGAIN after you removed these table value's