Yii 1.1: yiifirebird

Firebird Adapter for Yii 1.1.x

This is an updated version of the adapter originally posted by idlesign. It has been enhanced and tested with gii from yii 1.1.9.

PHP 5.3.10 is required. Previous versions of PDO_Firebird do not return the number of rows affected by a dml statement.

This version is marked 1.0RC3

Summary of new features and fixes


  • Forced all metadata objects to lowercase for compatibility with gii
  • Changed system table queries to use JOINS instead of WHERE conditions. This is partly a matter of style but WHERE joins are deprecated.
  • Support of composite primary keys
  • Fixed 'findColumns' of 'CFirebirdSchema' that always returns true, even if the table does not exist.
  • Added support for Alter column from NULL to NOT NULL and vice versa


  • Fixed applyLImit to correctly handle all variations of $limit and $offset
  • Fixed getLastInsertID for inserting records


  • Unpack the adapter to protected/extensions
  • In your protected/config/main.php, add the following:
  'components' => array(
    'db' => array(
      'connectionString' => 'firebird:dbname=localhost:C:\Path\To\Db\MyDB.GDB',
      'class' => 'ext.YiiFirebird.CFirebirdConnection',


Thanks to

@idlesign, @edgardmessias, @mr-rfh, @mlorentz75

Total 4 comments

#16277 report it
Bianchi at 2014/02/05 08:44am
Can't update or insert a record

I'm having the following error when inserting or updating a record

CDbCommand failed to prepare the SQL statement: SQLSTATE[HY000]: General error: -151 attempted update of read-only column

#15285 report it
Josh10 at 2013/10/23 12:45pm
i have problems

i need to help when try use this extension y have this message

PHP warning

include(C:\wamp\www\yii\framework/db/schema/firebird/CFirebirdPdoAdapter.php) [function.include]: failed to open stream: No such file or directory

#11722 report it
robregonm at 2013/01/29 01:34pm

Not sure if demo is useful, but if I decide to publish one, a notification will be published here.

#11535 report it
fad at 2013/01/18 05:27pm

demo be good :)

Leave a comment

Please to leave your comment.

Create extension