From: Bryan Alsdorf
Date: July 31 2009 4:26pm
Subject: Re: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2
List-Archive: http://lists.mysql.com/eventum-users/5644
Message-Id: <4A731B22.7000109@askmonty.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Srivathsan, M IN BLR SISL wrote:
> 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?

Yes, for some reason they aren't being loaded / activated properly. It has been a long 
time since I installed PHP on windows so I am not really able to help you with this, sorry.

/bryan

> 
> 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
> 


-- 
Bryan Alsdorf, Lead Web Developer
Monty Program, AB. http://askmonty.org