MonitorWare Knowledge Base

Hi,
Installed phplogcon and run the installation script. Tried to login and got the error:

Database error: Failed to changing database
mysql error: Unknown database 'phplogcon'
mysql error number: 1049
Date: 28.05.2006 @ 09:05
Script: /logd/index.php
Referer:

Well, this error is correct; there is no database 'phplogcon'. I checked the config.php and it says; define('_DBNAME', 'Syslog');

The install script worked because there is two more tables in the Syslog database. There is also valid data in them.

mysqld Ver 4.1.15 for pc-linux-gnu on i686
Apache/2.0.55
phplogcon-v1.2.3

Could you please help out?

cheers
Bjorn

Hello Bjorn,

Sounds strange. Unfortunately I could not reproduce this behaviour.

Could you please do a quick check?

Open the file
/db-drv/mysql.php

Search for the following line:

Code: Select all

mysql_select_db($_SESSION['database']) or db_die_with_error(_MSGChDB);


and replace it with

Code: Select all

mysql_select_db(_DBNAME) or db_die_with_error(_MSGChDB);


Please let me know if it helps?

Best Regards,
Michael

Hi Michael,
Thanks for answering.

Well, I didn't stop trying...

I changed the line:

$_SESSION['database'] = _DBNAME;
to:
$_SESSION['database'] = "Syslog";

and it worked. When I got your reply I changed it back to its original, but now the system works. Strange... Something must have hung after installation or so. I can't reproduce the error anymore!

Well even if its good that my system works, I'd rather help in finding out what the problem was. Especially if anyone else gets the same thing after installation...

Let me know if I can do anything!


Thanks again!
Bjorn

PS. This seems like a good piece of software!