Phpnuke & Mysql Need Help Please

[phreaked]

ok im trying to use phpnuke but am running into major problems getting it to connect right to the database.
the database is loaded and has all of the tables it should.
Bellow is the error I get all over my page.
When I rem out the database config in config.php they errors go away. I copied my username/password for the database and the database name exactly as was listed on the MYSQL manager page. I even tried different variations with them. What ever I try the errors still show up. If anyone has run into this problem before please let me know. Here is the table in the config.php that I am having trouble with.

I am also unsure what to enter into the $prefix and $user_prefix fields.

$dbhost = "localhost";
$dbuname = "";
$dbpass = "";
$dbname = "";
$prefix = "";
$user_prefix = "";
$dbtype = "MySQL";


Here is the error that shows up all over my page:


Warning: Supplied argument is not a valid MySQL result resource in /home/techsho/public_html/html/includes/sql_layer.php on line 271

Warning: Supplied argument is not a valid MySQL result resource in /home/techsho/public_html/html/includes/sql_layer.php on line 271

Warning: Supplied argument is not a valid MySQL result resource in /home/techsho/public_html/html/includes/sql_layer.php on line 271



THANKS FOR THE HELP =]

[DCE]

Could you post the the code for *sql_layer.php*

[phreaked]

i decided to try and install phpwebsite and it works like a charm. not sure what went wrong on the install of phpnuke, never got it to work. thanks for the reply DCE =]

-pk

[auto]

You can using PostNuke.


Example my site.

[CutAndPaste]

The section of file I think you are having problems with is the config.php - I'm using PostNuke asnd the setup is very similar. Either you need to CHMOD this file to 666 so that the set install routine can add your proper details during installation or you need to manually edit this file to the correct values. Something like

$dbhost = "localhost";
$dbuname = "YourDBUserName";
$dbpass = "YouDBPassWord";
$dbname = "YourDBName";
$prefix = "";
$user_prefix = "";
$dbtype = "MySQL";

If you read the file config.php, all the variable have loads of comments. DON'T Post ANY of the above variables info on these or other pages else your site will taken over before you can say "what the...."

Check out the support pages for PHPNuke or PostNuke for more info.

Hope this Helps!

I've started with this stuff a bout 3 weeks ago and it's fairly easy to pick up! Check out http://www.26point2.co.uk - hosted on HOSTROCKET!

Simon

[Eye-On]

I'm having the same problems, CutandPaste's suggestion didn't help, it made it worse
I now have Parse error: parse error in /home/eye-on-/public_html/includes/sql_layer.php on line 277

Fatal error: Call to undefined function: sql_fetch_row() in /home/eye-on-/public_html/mainfile.php on line 81


Anyone out there willing to help out?

[phreaked]

ya i still never got it to work right..
phpwebsite works perfect for me and i love it..
give it a try Eye-On =]


-pk

[eporue]

I had similar errors with PHP Nuke, and the solution was very simple: make sure that you do not have empty spaces at the end of the config.php file. As silly as it sounds, make sure that at the end, after ?>, there are no spaces.

Good luck. By the way, mine goes extremely well. Look at it at http://deusto.com

[Eye-On]

I've done the above, but...
Warning: Supplied argument is not a valid MySQL result resource in /home/eye-on-/public_html/includes/sql_layer.php on line 283

I'd be very greatful if someone that has previously set up phpnuke on host rocket if someone could help out some more as I really need this up and running ASAP
icq: 58395222 pretty please with a cherry on top!!

[eporue]

Mmmm, very strange. Let me see, what I have in my PHP Nuke in HR is:

$dbhost = "localhost";
$dbuname = "Youraccount_YourDBUserName";
$dbpass = "YouDBPassWord";
$dbname = "Youraccount_YourDBName";
$prefix = "";
$user_prefix = "";
$dbtype = "MySQL";

And that is it.

I would recommend deleting all the files, reinstalling PHP Nuke from scartch. and trying that configuration. Also, remember to eliminate spaces at the end in any file that you modify. Ohh, and remember to update the permissions on as stated in the install file (this is probably not your problem).

I will try to contact you later (I have no access to ICQ now ....)

[eporue]

I just realiced that my config.php has:

$dbhost = "localhost";
$dbuname = "Youraccount_YourDBUserName";
$dbpass = "YouDBUserPassWord";
$dbname = "Youraccount_YourDBName";
$prefix = nuke;
$user_prefix = "";
$dbtype = "MySQL";


Please note that in dbpass you have to put the password of the user you are using.

And in prefix you have to say "nuke"

Good luck.

[Eye-On]

nuke = no quotation marks?

[eporue]

Yes, I have nuke with no quotation marks. I would recommend you to try it with or without the quotation marks.

Eduardo