Version 5

DatabaseTestsAndFixes-Firebird

How to make it working with Firebird DB

Created by: luciash d' being, Last modification: 02 Jun 2006 (23:55 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. However
bitweaver 1.3.0 can run with Firebird database but at least the following tweaks and fixes are needed:

  1. 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
  2. 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
    
    <?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' => ),
    #       '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' => ),
            
    'tiki_articles_article_id_seq' => array( 'start' => ),
    );
    $gBitInstaller->registerSchemaSequencesARTICLES_PKG_NAME$sequences );
    ?>
  3. Edit file articles/BitArticle.php
  4. Edit file articles/BitArticleTopic.php
  5. Edit file articles/BitArticleType.php
  6. ...


this page is under composition... (also feel free to rename it when the wiki page name doesn't fit)

Page History
Date/CommentUserIPVersion
13 Aug 2008 (17:44 UTC)
laetzer85.178.37.1919
Current • Source
paul greavy90.17.58.1537
View • Compare • Difference • Source
luciash d' being213.19.127.986
View • Compare • Difference • Source
luciash d' being213.19.127.985
View • Compare • Difference • Source
luciash d' being213.19.127.984
View • Compare • Difference • Source
luciash d' being213.19.127.982
View • Compare • Difference • Source
luciash d' being213.19.127.981
View • Compare • Difference • Source