phpnuke/MySQL help

[Paxthegreat]

right i've already read thru the manuals on the mysql site and the phpnuke site, and i've managed to transfer phpnuke to my server and un tar it, now as i was reading thru the install manual it said make a db called nuke etc anyway, done that, then it said edit config.php "add db username pass etc" and then goto /html/admin.php and ur away, ... well it didnt work that way, i've inputted some of the info in the config.php. but what do

$prefix = "nuke";
$user_prefix = "nuke";

mean? what do i put here, the manual just says

# $prefix: Your Database table's prefix
# $user_prefix: Your Users' Database table's prefix (To share it)

which as i have no idea what this means, explains nothin to me

can someone pls help

thx

[cpradio]

you will not need to edit either of those attributes to my knowledge.

Make sure you have the db_host set to localhost and make sure your db username, password, and database name are all correct (they are case sensative).

Oh yeah, and the original username/password is like:
admin/God

[Paxthegreat]

hmm, i've left it as is, and set the username and pass as its supposed to be, but now its doing this http://sd.pax3k.co.uk/html/admin.php

anyone?

[cpradio]

Make sure your html folder is chmoded to 755 and the admin folder is 755, then make the config.php file chmoded to 777

[Paxthegreat]

just CHModded everything as above and .... its still :

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sd/webroot/html/includes/sql_layer.php on line 286

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sd/webroot/html/includes/sql_layer.php on line 238

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sd/webroot/html/includes/sql_layer.php on line 286

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sd/webroot/html/includes/sql_layer.php on line 286

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sd/webroot/html/includes/sql_layer.php on line 238

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sd/webroot/html/includes/sql_layer.php on line 286

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sd/webroot/html/includes/sql_layer.php on line 286

etc etc

any more suggestions

[cpradio]

Can you post the code that starts from 233 to 243 and 281 to 291?

[Paxthegreat]

right as u said that, i was checking those lines to see if anything was up ... and couldn't find anything so i reinstalled the whole thing including mySQL, and ... and its kinda workin, but i have a whole new problem now, it aint lettin me create a super admin and aint lettin me view the majority of pages, i'm guessing its a permission problem, but everything looks ok, any ideas what the problem is now?
and if so, what the permissions or whatever should be set to

[cpradio]

Well to be honest I have been guessing at all of this. I have not used or installed phpNuke since Version 5.4 and I hear they are at 6.0 now.

I would say you probably have a chmoding problem. All directories should be 755 and the only file that should be chmoded is the config.php and it should be either 666 or 777 (take your pick)

-Matt