List:Eventum General Discussion« Previous MessageNext Message »
From:M  IN BLR SISL Srivathsan Date:July 31 2009 8:54am
Subject:RE: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2
View as plain text  
Hi all,

A small correction.  "mysql" and "mysqli" were listed out in the command line output for
"php -m" but not mentioned anywhere in the "phpinfo();" output.  Is this is a clue?

Thanks and rgds,
Watson

-----Original Message-----
From: Srivathsan, M IN BLR SISL [mailto:M.Srivathsan@stripped]
Sent: Fri, 31-Jul-2009 13:41
To: Eventum
Subject: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2

Hi all,

This completely beats me!

A couple of days back, I installed Apache 2.2.11, MySQL 5.1.35 community edition and PHP
5.2.10 on a fresh WinXP SP2 machine.  Then I migrated my Eventum application from an
older machine (with 5.0.51 community edition, Apache 2.2.8 and PHP 5.2.6) to this new one
- I have already done quite a number of such successful migrations with the DB restored
properly and I had also changed the <Eventum2.2>/Config/Config.php accordingly.

But now, after the migration (DB + App) and the necessary changes in the Config.php, I am
getting a Database Error which reads something like "There seems to be a problem
connecting to the database server specified in your configuration file. Please contact
your local system administrator for further assistance".  The error message was more
informative when tried to run the setup (<Eventum2.2>/misc/setup.php) and it said
something like "The following problems were found: The MySQL extension needs to be
enabled in your PHP.INI file in order for Eventum to work properly. Please resolve the
issues described above. For file permission errors, please provide the appropriate
permissions to the user that the web server run as to write in the directories and files
specified above".

The above 2nd message is quite confounding as I could see in the phpinfo report that both
"mysql" and "mysqli" modules were loaded and also the "php_pdo_mysql".  The Error log
also says the same thing - the entry of which is given below:
[Fri Jul 31 07:29:08 2009] An error was found on line '70' of script 'E:\Watson's
Documents\My Website\HeaR-IT-ALPHA\include\class.db_api.php'.

The error message passed to us was:

'DB Error: extension not found'

A more detailed error message follows:

' [DB Error: extension not found] ** mysql(mysql)://root:PASSWORD@localhost/hear_it'

A backtrace is available:

E:\Watson's Documents\My Website\HeaR-IT-ALPHA\include\db_access.php:33
  DB_API->DB_API()
E:\Watson's Documents\My Website\HeaR-IT-ALPHA\init.php:173
  include_once((string )'E:\Watson's Documents\My
Website\HeaR-IT-ALPHA\include\db_access.php')
E:\Watson's Documents\My Website\HeaR-IT-ALPHA\index.php:31
  require_once((string )'E:\Watson's Documents\My Website\HeaR-IT-ALPHA\init.php')

Could anyone shed some light?  Is it something to do with MySQL 5.1 or with PHP 5.2.10
which is quite new?  Thanks in advance.

Thanks and rgds,
Watson
Thread
A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2M  IN BLR SISL Srivathsan31 Jul
  • RE: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2M  IN BLR SISL Srivathsan31 Jul
    • Re: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2Bryan Alsdorf31 Jul
RE: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2M  IN BLR SISL Srivathsan3 Aug