PHPUnit


Zend Studio php_pdo_mysql.dll error

I started using phpunit, which is built into Zend Studio 7.2. Everything works fine until it encountered a database query that used PDO. The test case will timeout and zend studio will give you the error “Test case was unexpectedly terminated”. It took a lot of digging to find the real error in the windows event viewer:

Faulting application name: php-cgi.exe, version: 5.2.10.10, time stamp: 0x4abb41d8
Faulting module name: php_pdo_mysql.dll, version: 5.2.10.10, time stamp: 0x4ab23077
Exception code: 0xc0000005
Fault offset: 0x00002580
Faulting process id: 0x458
Faulting application start time: 0x01cb16fb91818916
Faulting application path: C:\Program Files (x86)\Zend\Zend Studio – 7.1.0\plugins\org.zend.php.debug.debugger.win32.x86_5.3.7.v20091116\resources\php5\php-cgi.exe
Faulting module path: C:\Program Files (x86)\Zend\Zend Studio – 7.1.0\plugins\org.zend.php.debug.debugger.win32.x86_5.3.7.v20091116\resources\php5\ext\php_pdo_mysql.dll
Report Id: d31816ab-82ee-11df-99ae-00241dd93279

The solution? While I had Zend Server installed and using PHP 5.3, Zend Studio’s internal version was using PHP 5.2.xxx. I’m pretty certain Doctrine, which uses PDO, requires PHP 5.3. I changed Zend Studio to PHP 5.3 and it worked. In Zend Studio, go to Window->preferences->php->debug and ensure the “PHP executable” is set to PHP 5.3. FYI – My “server” on this screen is set to “Local Zend Server”. Hope this helps!


How to install PHPUnit on Windows 13

After about ten hours of fighting with PEAR and PHPUnit, I think I have it installed correctly as my test case was able to run. There are a couple “official” documentation sources on how to install PHPUnit, but they only bother to cover installing it on linux. Further, PHPUnit has evolved quite a bit over the past few years and its configuration seems to have changed. I wouldn’t even bother installing PEAR if you don’t want to because the PHPUnit version from PEAR is grossly outdated. As of now, the currently version of PHPUnit is 3.4.9. If you install pear and phpunit from the command line as I tried a couple times, the phpunit.bat file will not be updated as it should, so phpunit will not work. If you open phpunit.bat and see these lines “set PHPBIN=”@php_bin@”
%PHPBIN% “@bin_dir@\phpunit” %*”, then you know something didn’t work right.

  1. To install manually as I did, go to http://pear.phpunit.de/get/ to download the latest version of PHPUnit. Extract the files to a directory that is listed in the include_path of your php.ini configuration file. If you’d like to place it in a custom location, add that location to the include_path in your php.ini file.
  2. Find the phpunit.bat file that you extracted, open it with a text editor and change the @php_bin@ string in it with the path to php.exe. Get rid of this line “%PHPBIN% “@bin_dir@\phpunit” %*” as it won’t be needed. On the line below, add the following line to execute phpunit.php with php ‘php -d safe_mode=Off “C:\Program Files (x86)\Zend\Apache2\htdocs\library\pear\pear\phpunit.php” %*’. Remove the single quotes I added here and change the path to phpunit.php to the file’s location on your computer (the directory you extracted phpunit to).

In the end, your phpunit.bat file should look similar to this (with that paths to php.exe and phpunit.php changed to your file locations)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
@echo off
REM PHPUnit
REM
REM Copyright (c) 2002-2010, Sebastian Bergmann <sb@sebastian-bergmann.de>.
REM All rights reserved.
REM
REM Redistribution and use in source and binary forms, with or without
REM modification, are permitted provided that the following conditions
REM are met:
REM
REM   * Redistributions of source code must retain the above copyright
REM     notice, this list of conditions and the following disclaimer.
REM 
REM   * Redistributions in binary form must reproduce the above copyright
REM     notice, this list of conditions and the following disclaimer in
REM     the documentation and/or other materials provided with the
REM     distribution.
REM
REM   * Neither the name of Sebastian Bergmann nor the names of his
REM     contributors may be used to endorse or promote products derived
REM     from this software without specific prior written permission.
REM
REM THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
REM "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
REM LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
REM FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
REM COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
REM INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
REM BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
REM LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
REM CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRIC
REM LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
REM ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
REM POSSIBILITY OF SUCH DAMAGE.
REM
 
set PHPBIN="C:\Program Files (x86)\Zend\ZendServer\bin\php.exe"
php -d safe_mode=Off "C:\Program Files (x86)\Zend\Apache2\htdocs\library\pear\pear\phpunit.php" %*

To test your install, go to the command line on windows and type “phpunit” and hit enter. If you don’t see any errors, then it’s installed correctly.

Other Issues
Using Zend Server 5.0, Zend framework 1.10, and PHPUnit 3.4.9, I had to apply a couple patches or bug fixes to get things to work.

  1. I received the error “Fatal error: Cannot redeclare class PHPUnit_Framework_TestCase” . The Zend Studio template for a test case automatically includes
    1
    
    require_once 'PHPUnit\Framework\TestCase.php'; .

    Change this to

    1
    
    require_once 'PHPUnit\Framework.php';

    for each test case. The bug report for this issue is located at http://framework.zend.com/issues/browse/ZF-9380