login | register
Tue 07 of Oct, 2008 (14:57 UTC)

bitweaver - Web Application Framework and CMS

Web Application Framework and CMS

Refresh cacheHistoryPrint

DatabaseTestsAndFixes-Firebird

How to make it working with Firebird DB

Created by: luciash d' being, Last modification: Wed 13 of Aug, 2008 (17:44 UTC) by laetzer

Page Contents

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:

  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
    /* 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
    /* 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 );

  3. 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
  4. 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
  5. Edit file articles/BitArticleType.php
  6. ...


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

Comments

Reply to this comment

DON'T CHANGE ADODB !!!

by Lester Caine, Friday 13 of October, 2006 (20:11:02 UTC)
The Firebird version of ADOdb included in bitweaver has a number of fixes in the datadict in order to get the installer working at all. These are reflected into the driver.
Changing the ADOdb for a 'non-bitweaver' version will break things - such as those listed.

I skipped R1.3.1 as the next release will be based on the R2 code, which has dropped the major hassle of double quotes on all tables and field names. This is currently running on http://wiki.firebirdserver.org/ and any bugs found are being passed back to the CVS.

Related Items

Documentation » Tutorials

Tutorials to help you work out how something in bitweaver is done

Archived Picture Upload with Fisheye under Windows  •  Configuring multisites  •  Creating Screencasts  •  DatabaseTestsAndFixes-Firebird  •  GalaxiaTutorial  •  Groups and Permissions  •  Home Page Tutorial  •  Install pspell on Windows  •  IntegrationTutorial  •  JavaScript Module Tutorial  •  Migrating Users Between Bitweaver Sites  •  phpBB to Boards Upgrade  •  phpbbTutorial  •  Schema tutorial  •  SearchPackageDevNotes  •  Speed optimisation  •  Squirrel Mail Integration Tutorial  •  theme compliance with MSIE  •  ThemeTutorial  •  TopBarTutorial  •  TranslationTutorial  •  Tutorial_Custom_Module  •  Tutorial - Liberty Plugins  •  Tutorial - Liberty Plugins II  •  Tutorial - Native Theme  •  Tutorials  •  Use bitweaver to build a web site that is very nice  •  Wiki Plugin Tutorial  •  wiki syntax  •  Screencasts  •  InstallShots  •  Video: Installation of Bitweaver