phpnuke/MySQL help

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

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

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?

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

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

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

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

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