Please Help With Phpfanlist

[BobCat]

Using Phpfanlist, version 3.0. Followed instructions exactly as they wrote. This appears to be something incorrect.

 

I've tried to set up a fanlisting, and when I run the fanlisting script I get the error:

 

Could not select the database you specified.

 

I'm using localhost in the config.inc.php file. I even tried using johnny.heliohost.org, got the same error.

 

And the database is correct.

[Ice IT Support]

Could you post the part of config.inc.php you are using for your database, removing passwords, etc.?

[BobCat]

[bdistler]

from http://wiki.helionet...MySQL_Databases

 

enter your "USERNAME" and "PASSWORD" and "DATABASENAME"

 

<?php
print "try to open datatbase<br>\n";
mysql_connect("localhost", "USERNAME", "PASSWORD") or die(mysql_error());
mysql_select_db("DATABASENAME") or die(mysql_error());
print "got into dabase<br>\n";
print "the end<br>\n";
?>

 

works for me on server Stevie

[BobCat]

[Ice IT Support]

Here is the script I use to access my databases:

<?php
$dbcon = mysql_connect("localhost","username","password");
if (!$dbcon)
{
die("Error: " . mysql_error();
}

mysql_select_db("database_name", $dbcon);
?>

[BobCat]

OK, but first I have to reinstall the script, what is wrong with the config.inc.php file I had? It won't connect to the database despite everything set up correctly.

[bdistler]

this =======> db_host = 'johnny.heliohost.org'; <==

 

should be ==> db_host = 'localhost'; <==

 

as a start

[BobCat]

localhost still gives me the same problem.

 

What else is wrong?

[Ice IT Support]

Try typing the database name and password again. I have often found the error is a simple mis-spelling I overlooked.

[bdistler]

With the PHP script I posted above at 10 February 2012 - 06:10 PM

what error do you receive ?