Introduction

Presented on this page are patches for getting phpBB to work with Oracle as described in the phpBB Oracle Howto.
Please post any queries or comments to the phpBB discussion group for Oracle, where I and others will try and assist.
Note that I do not support any of these patches by email.

For problems setting up Oracle OCI with PHP try our configuration checking script which will check the basic settings and environment for Unix based systems (tested on Solaris, Linux, Mac OS X).

Special note for version 2.0.15: If you are upgrading from an earlier version of phpBB to 2.0.15 you must run this SQL script on your database.
Special note for versions 2.0.14 and above: The developers of phpBB have chosen to remove db/oracle.php from the distribution (reason unknown at this time), so the patches now include the file as of 2.0.13 from our patch kit.

The patches

Change History

17-Sept-2005 17-Jul-2005 7-May-2005 17-Apr-2005 17-Mar-2005
9-Mar-2005 22-Dec-2004 26-Jul-2004 29-Oct-2003 1-Oct-2003 11-Sept-2003
10-Sept-2003
8-Sept-2003

Applying the patches using "patch"

To apply the chosen patch (for example to update a standard phpBB 2.0.6 distribution to include all the Oracle 8i patches):

tar zxvf phpBB-2.0.6.tar.gz
cd phpBB
patch --backup --verbose -p1 < ../vanilla-to-oracle8i.patch
You should expect to see similar output to the following from "patch". If you don't check that you are using GNU patch - other versions (such as the standard Solaris one) don't fully understand the unified diff format used to generate the patches.
Hmm...  Looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -ur vanilla/admin/index.php oracle8i/admin/index.php
|--- vanilla/admin/index.php    Wed Sep 10 18:15:47 2003
|+++ oracle8i/admin/index.php   Wed Sep 10 18:03:52 2003
--------------------------
Patching file admin/index.php using Plan A...
Hunk #1 succeeded at 287.
Hmm...  The next patch looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -ur vanilla/db/oracle.php oracle8i/db/oracle.php
|--- vanilla/db/oracle.php      Wed Sep 10 18:09:03 2003
|+++ oracle8i/db/oracle.php     Wed Sep 10 18:03:53 2003
--------------------------
Patching file db/oracle.php using Plan A...
Hunk #1 succeeded at 56.
Hunk #2 succeeded at 97.
Hunk #3 succeeded at 110.
Hunk #4 succeeded at 124.
Hunk #5 succeeded at 270.
Hunk #6 succeeded at 313.
Hunk #7 succeeded at 391.
Hunk #8 succeeded at 416.

...

--------------------------
|diff -ur vanilla/search.php oracle8i/search.php
|--- vanilla/search.php Wed Sep 10 18:12:59 2003
|+++ oracle8i/search.php        Wed Sep 10 18:04:03 2003
--------------------------
Patching file search.php using Plan A...
Hunk #1 succeeded at 711.
Hunk #2 succeeded at 721.
done

Credits

These patches combine the work done by Shurik, sufehmi, and amannering on the phpBB Discussion group