History of DatabaseTestsAndFixes-Firebird
Version 2
DatabaseTestsAndFixes-Firebird
How to make it working with Firebird DB
Created by: luciash d' being, Last modification: 02 Jun 2006 (23:33 UTC) by luciash d' being
Firebird and bitweaver 1.3.0
It was said that on development branch (CVS) of bitweaver Firebird database is much more stable, better supported, fixed and polished but the fixes were not backported to stable release yet. Howeverbitweaver 1.3.0 can run with Firebird database 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:
<?php
/* 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 );
*/
?>
with this code
<?php
/* 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 );
?>
this page is under composition...