-
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