I've adapted PHPBT to work with Interbase/Firebird.
Some modifications are necessary.
I Hope those adaptations could be release in this project (perhaps in a better way, mines are not necessary in the main way.
Somebody can answer me on this ?
I haven't test it yet.
Main adaptations :
A) In SQL :
1) "password" and "active" are reserved words.
password becomes password_
active becomes active_
2) Use GENERATOR to do automatic incremented fields.
3) Use SMALLINT, INTEGER and BIGINT
4) replace "using(field)" by an "on X.field=Y.field"
5) becareful of the TEME defined in configuration table : I've found : " DEFAULT" with a space...
B) PHP
1) remove / in ":/" for database host definition
2) change in phpbt/inc/pear/DB/ibase.php on the connect method, don't add more parameters than user,password and host.
3) create ibase.in (not very hard)
Those are the main traps.
I hope this will help.
Jean-Marc
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Any chance that you can help with integrating these changes into phpBT? None of the current developers use interbase/firebird.
Can you please upload your ibase.in and ibase.php files to the patches section or mail them to the phpbt-dev mailing list? Maybe you can make a patch of the other changes as well, if you had to patch more php files?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I've adapted PHPBT to work with Interbase/Firebird.
Some modifications are necessary.
I Hope those adaptations could be release in this project (perhaps in a better way, mines are not necessary in the main way.
Somebody can answer me on this ?
I haven't test it yet.
Main adaptations :
A) In SQL :
1) "password" and "active" are reserved words.
password becomes password_
active becomes active_
2) Use GENERATOR to do automatic incremented fields.
3) Use SMALLINT, INTEGER and BIGINT
4) replace "using(field)" by an "on X.field=Y.field"
5) becareful of the TEME defined in configuration table : I've found : " DEFAULT" with a space...
B) PHP
1) remove / in ":/" for database host definition
2) change in phpbt/inc/pear/DB/ibase.php on the connect method, don't add more parameters than user,password and host.
3) create ibase.in (not very hard)
Those are the main traps.
I hope this will help.
Jean-Marc
Thanks,
Any chance that you can help with integrating these changes into phpBT? None of the current developers use interbase/firebird.
Can you please upload your ibase.in and ibase.php files to the patches section or mail them to the phpbt-dev mailing list? Maybe you can make a patch of the other changes as well, if you had to patch more php files?