MySQL error "No Database Selected"

views:

560

answers:

MySQL error "No Database Selected"

Hello,

I am using LAMP on localhost. I can login which uses mysql db, get to the main page (data driven), but when i enter this particular page, its fine, but when i refresh the error is "No Database Selected" then one every page says so.

I restarted the Apache, MySQL server

Browsers FF,IE, Chrome all show the same errors, cleared cache too. At the same time other websites that use the same LAMP server works fine.

Now thats strange

All ideas are welcome.

Are the main pages using mysql_select_db("foo") and this particular one not?

Ólafur Waage 2009-05-13 10:56:34

linked to the connection string page

2009-05-13 10:57:16

what's linked to the connection string page?

altCognito 2009-05-13 10:58:03

sorry yes they all have and this particular too, assuming this particular didnt have,then the others should load properly

2009-05-13 10:58:10

You can see what files are included with get_included_files() http://is.php.net/manual/en/function.get-included-files.php

Ólafur Waage 2009-05-13 10:59:26

connection page contains$hostname_data = "";$database_data = "";$username_data = "";$password_data = "";$data = mysql_pconnect($hostname_data, $username_data, $password_data) or trigger_error(mysql_error(),E_USER_ERROR)

2009-05-13 11:19:08

I saw you have this: mysql_select_db($database_mblogging, $mblogging); Is $mblogging a resource and does $database_mblogging contain a table name?

Ólafur Waage 2009-05-13 11:41:29

that is a string from the connection string. just ignore that, i removed it for less confusion

2009-05-13 12:45:35

But does $mblogging have a resource behind it to select the database?

Ólafur Waage 2009-05-13 13:10:05

yes it does have

2009-05-14 09:20:25

When you are connecting with php, you are not selecting a database (or the select is failing). Is it perhaps using a variable which is not getting properly populated?

altCognito 2009-05-13 10:57:34

but how will that effect the other pages

2009-05-13 11:00:14

Somewhere in the code (PHP) the default database gets reset, probably on a shared database connection. I guess this is a bug in the product you use.

Daniel Schneller 2009-05-13 10:57:47

could you brief on that a little more

2009-05-13 11:00:35

Try going through the code where it connects with database and tries to pull the data. Most of the times there is a configuration file which defines the connection attributes like username, password, database server, port and database to be used also.

for example in phpMyAdmin keeps the information in libraries/Config.class.php file.

TheVillageIdiot 2009-05-13 11:08:30

<pre>mysql_select_db($database_mblogging, $mblogging);$query_Recordset1 = "SELECT * FROM table";$Recordset1 = mysql_query($query_Recordset1, $mblogging) or die(mysql_error());$row_Recordset1 = mysql_fetch_assoc($Recordset1);do {<span>Id:</span><span>echo $row_Recordset['id']</span>} while ($row_$Recordset = mysql_fetch_assoc($Recordset1)); </pre>Thats all...Once the error pops up, No other pages loads

2009-05-13 11:13:14

ansaurus

tags:

views:

answers:

MySQL error "No Database Selected"

related questions