History of DatabaseTestsAndFixes-Firebird

{maketoc}
!! Firebird and bitweaver on CVS HEAD
Usually works without problems, but HEAD may contain code that hasn't yet been tested with Firebird.

!! Firebird 2.0 and bitweaver 2.0
Just 'works'. Only known bug is updating stats throws a deadlock error. Firebird 2.1 should work equally well.

!! Firebird 1.5 and bitweaver 1.3.0
It was said that on development branch (CVS HEAD) of bitweaver Firebird database is much more stable, better supported, fixed and polished but the fixes were not backported to stable release yet. However bitweaver 1.3.0 can run with Firebird database too but at least the following tweaks and fixes are needed:

# Update ''utils/adodb/'' with the last version of ''ADOdb'' library, otherwise after changing default English to another language bitweaver will fail to work anymore completely
+
# It's needed to shorten the names of sequences for generators (Firebird allows max. 30 chars for their names). Edit file ''articles/admin/schema_inc.php'' as follows:
+__Replace this commented-out part of code__
+{CODE}/* commented these out because these sequences are automatically generated
$sequences = array (
'tiki_article_topics_topic_id_seq' => array( 'start' => 1 ),
'tiki_article_types_article_type_id_seq' => array( 'start' => 1 ),
'tiki_articles_article_id_seq' => array( 'start' => 1 ),
);
$gBitInstaller->registerSchemaSequences( ARTICLES_PKG_NAME, $sequences );
*/{/CODE}
+__with this code__
+{CODE}/* commented these out because these sequences are automatically generated */
$sequences = array (
# 'tiki_article_topics_article_type_id_seq' => array( 'start' => 1 ), FIX for Firebird on the next line:
'tiki_article_topics_a_t_id_seq' => array( 'start' => 1 ),
# 'tiki_article_types_article_type_id_seq' => array( 'start' => 1 ), FIX for Firebird on the next line:
'tiki_article_types_a_t_id_seq' => array( 'start' => 1 ),
'tiki_articles_article_id_seq' => array( 'start' => 1 ),
);
$gBitInstaller->registerSchemaSequences( ARTICLES_PKG_NAME, $sequences );{/CODE}
+
# Edit file ''articles/BitArticle.php'':
+ Because ''TYPE'' is Firebird's reserved word (this has been fixed in CVS HEAD branch) it needs to change all occurences of -+type.+- to -+types.+- in the file
+
# Edit file ''articles/BitArticleTopic.php'':
+ Yes, ''AT'' is reserved word too, so the same must be done with the three ocurrences of "at" in ''articles/BitArticleTopic.php''
+
# Edit file ''articles/BitArticleType.php''
+
# ...
+

!!Related links
* [http://sourceforge.net/tracker/index.php?func=detail&aid=1481091&group_id=141358&atid=749176 | Bug ~np~#~/np~ 1481091 - WSoD of Articles w/ Firebird DB] (WSoD stands for White Screen of Death (:wink:))

::''this page is under composition... (__feel free to rename it__ when the wiki page name doesn't fit)''::