I’m using the Firebird adapter for my first Yii problem and it seems to work ok.
However, I encounter a problem with decimal fields. They are readed from the database just fine. But when I update a record with a decimal the value is devided by 10000. So 5 becomes 0.0005 when posted to the database. When I edit the record again the value is devided by 10000 again which turns it into 0.
Any idea what I am doing wrong?
I changed the fields to FLOAT in the database and that seems to work.
I’ll take a look at it.
If you find any bug, please report it at the github repository: https://github.com/robregonm/YiiFirebird
Best regards.
Thanks for looking at it. If I find anything else I will post it on github.
This extension can be downloaded from the Extensions page.
Version 1.0RC released.
Feel free to download and report bugs.
Version 1.0RC2 released.
Lots of bug fixes and enhancements implemented.
Good news:This extension will be pushed to Yii core as soon as the final version 1.0 of the extension is released.
Hi robregonm
Version 1.0RC2 downloaded. Installed as in readme.
Getting error ‘could not find driver’
Have I missed something?
Thank you.
Hi Jay_69,
Are you using PHP 5.3.10+, and Yii 1.1.13?
There are some known issues mainly when PHP version is not 5.3.10 or above.
And, last Yii version fixes some bugs when loading 3rd party Db extensions (like Yii.Firebird)
Please, let me know, if you get some progress on this.
Regards.
Hi robregonm,
Sorry could not test on other versions.
Our project uses Firebird as local db and syncs with MySql site db, so we decided not to use direct connect to Firebird db from the site.
Set up http server and used cross domain requests instead.
But anyway I will keep your extension on a list.
Cheers
Release Candidate 4 is available to download.
This new version includes several bug fixes and enhancements.
Feel free to download and report issues.
And remember, as soon as this extension is stable, then a pull request will be done to Yii repo.
Just in case anybody else had the same problem…
The Yii Firebird adapter worked fine with Apache, but it just silently crashed under the FreeBSD+Nginx+PHP-FPM installation.
So if you’re on a FreeBSD system and using PDO_Firebird along with PHP-FPM, make sure you have the LINKTHR option enabled for your PHP5 (lang/php5):
LINKTHR=on: Link thread lib (for threaded extensions)
Hope it will help 
Hi robregonm,
Im’ trying to use firebird extension with gii, but there is a message when I click on “Crud Generator”
SOLVE: folder name in protected\extensions must be YiiFirebird
Hello
Great extension, thats exactly what I was looking for.
All is working fine, I can run queries, commands… but (always the but…)
When I try to make a model via gii it’s says: “Table does not exist.”
Any hint?
Regards,
I found something… I’m using Firebird 1.5 (for compatibility issues).
And the following query not runs on FB1.5
(SELECT 1 FROM RDB$TRIGGERS
WHERE RDB$SYSTEM_FLAG = 0
AND RDB$RELATION_NAME=upper(\'' . $table->name . '\')
AND RDB$TRIGGER_TYPE = 1
AND RDB$TRIGGER_INACTIVE = 0
AND (UPPER(REPLACE(RDB$TRIGGER_SOURCE,\' \',\'\')) LIKE \'%NEW.\'||TRIM(rel.rdb$field_name)||\'=GEN_ID%\'
OR UPPER(REPLACE(RDB$TRIGGER_SOURCE,\' \',\'\')) LIKE \'%NEW.\'||TRIM(rel.rdb$field_name)||\'=NEXTVALUEFOR%\'))
AS fautoinc
Just fixed to always pass
0 as fautoinc
, and will change manually on model when needed.
Now is all good.
Thx!
GGGreat extension! How can I change charset when connecting base?
answer myself …
‘connectionString’ => ‘firebird:dbname=localhost:D:\000\base\DBC_20131214.FDB;charset=utf8’,
Hello,
I need a little help about firebird generator name. How to get next ID from generator for specific table ?
For example: if my table is with name "my_table_name", what sholud be the generator name ?
MySQL and PostgreSQL adapters takes autoincrement value from sequence automaticaly, how to do that in firebird?
Thanks.