Oracle Sledgehammer

Craig Sprout
Joined: 22 Oct 2007

Oracle Sledgehammer

Posted:26 Oct 2007 (18:28 UTC)
This is just an FYI for anyone who might run into the same problems that I had while getting Bitweaver (R2C3) working with Oracle. We are using 10g, but this should work for 8i and 9i as well.

The liberty tables that hold the content are set as "L" in the AdoDB template in /liberty/admin/schema_inc.php. This had the result of giving articles a limit of 4000 characters, which didn't leave a lot room for content.

I edited the schema_inc.php file and replaced all "data L" lines with "data XL," so that the datatype would be CLOB and not VARCHAR(4000).

I haven't tested this extensively, so it could very well break 40 other things, but it did fix my issue for now.
spiderr
Profile Picture
Joined: 08 Feb 2004

Re: Oracle Sledgehammer

Posted:31 Oct 2007 (20:31 UTC)
Great news, Craig!

We have actually updated to "XL" in the schema to get around some mysql issues. Let us know if that works as well.

Are there any other Oracle issues you have run into yet?
Craig Sprout
Joined: 22 Oct 2007

Re: Oracle Sledgehammer

Posted:02 Nov 2007 (13:41 UTC)
The biggest one I have found (other than the L->XL issue) is that I can't even get 1.3.1 to install. It goes fine until the cleanup page, then I get the following errors:
[Fri Nov 02 07:56:51 2007] [error] [client xx.xx.xx.xx.] PHP Notice:  Trying to get property of non-object in /var/www/html/bw/install/install_cleanup.php on line 18, referer: http://hostname/bw/install/install.php
[Fri Nov 02 07:56:51 2007] [error] [client xx.xx.xx.xx.] PHP Notice:  Trying to get property of non-object in /var/www/html/bw/install/install_cleanup.php on line 19, referer: http://hostname/bw/install/install.php
[Fri Nov 02 07:56:51 2007] [error] [client xx.xx.xx.xx.] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/bw/install/install_cleanup.php on line 19, referer: http://hostname/bw/install/install.php
[Fri Nov 02 07:56:51 2007] [error] [client xx.xx.xx.xx.] PHP Notice:  Trying to get property of non-object in /var/www/html/bw/install/install_cleanup.php on line 22, referer: http://hostname/bw/install/install.php
[Fri Nov 02 07:56:51 2007] [error] [client xx.xx.xx.xx.] PHP Notice:  Trying to get property of non-object in /var/www/html/bw/install/install_cleanup.php on line 22, referer: http://hostname/bw/install/install.php
[Fri Nov 02 07:56:51 2007] [error] [client xx.xx.xx.xx.] PHP Fatal error:  Call to a member function MoveNext() on a non-object in /var/www/html/bw/install/install_cleanup.php on line 23, referer: http://hostname/bw/install/install.php

I haven't been able to determine whether or not this is related to Oracle or not.

Also, when I install RC3, I get database errors on creating indexes on liberty_meta_data, liberty_content_hits and themes_layouts. When I enter the statements manually in SQL*Plus, I get an error that the indexes already exist.

I get errors on setting defaults on a couple of the "INSERT INTO `quicktags`" statements: pearwiki and tikiwiki. I have a screenshot, if you need it.

Right now, I am fighting a little bit with spurious crashes in IE 6 and Firefox. I've only had Firefox crash once (2.0.0.8 under FC7), but IE crashes fairly often, especially on pages with textareas. There is also the issue of the textareas extending outside of the div in IE, which I've seen in other apps, but haven't been quite able to track down here.
Craig Sprout
Joined: 22 Oct 2007

Re: Oracle Sledgehammer

Posted:02 Nov 2007 (16:36 UTC)
Here are the failed SQL statements:

Failed to create index content_content_hits_idx on liberty_content_hits:
    CREATE INDEX content_content_hits_idx ON liberty_content_hits (content_id)  Failed to create index liberty_meta_data_key_idx on liberty_meta_data:
    CREATE INDEX liberty_meta_data_key_idx ON liberty_meta_data (meta_key)  Failed to create index liberty_meta_data_guid_idx on liberty_meta_data:
    CREATE INDEX liberty_meta_data_guid_idx ON liberty_meta_data (meta_key)  Failed to create index liberty_meta_data_title_idx on liberty_meta_data:
    CREATE INDEX liberty_meta_data_title_idx ON liberty_meta_data (meta_key)  Failed to create index liberty_meta_data_values_idx on liberty_meta_data:
    CREATE INDEX liberty_meta_data_values_idx ON liberty_meta_data (meta_key)  Failed to create index themes_layouts_module_idx on themes_layouts:
    CREATE INDEX themes_layouts_module_idx ON themes_layouts (module_id)  Failed to create index blog_posts_post_id_idx on blog_posts:
    CREATE INDEX blog_posts_post_id_idx ON blog_posts (post_id)  Failed to create index boards_id_idx on boards:
    CREATE INDEX boards_id_idx ON boards (board_id)  Failed to create index fisheye_gallery_id_idx on fisheye_gallery:
    CREATE INDEX fisheye_gallery_id_idx ON fisheye_gallery (gallery_id)  Failed to create index fisheye_image_id_idx on fisheye_image:
    CREATE INDEX fisheye_image_id_idx ON fisheye_image (image_id)  Error setting defaults:
    INSERT 
INTO `quicktags` 
(`format_guid`,`tagpos`,`taglabel`,`tagicon`,`taginsert`) VALUES 
('pearwiki_tiki','10','italic','italic','\'\'text\'\'')  Error setting defaults:
    INSERT 
INTO `quicktags` 
(`format_guid`,`tagpos`,`taglabel`,`tagicon`,`taginsert`) VALUES 
('tikiwiki','10','italic','italic','\'\'text\'\'')

spiderr
Profile Picture
Joined: 08 Feb 2004

Re: Oracle Sledgehammer

Posted:03 Nov 2007 (20:44 UTC)
Hi Craig,

ReleaseOne definitely has issues on Oracle that were never resolved. I personally got ReleaseTwo with bitweaverCore and ArticlesPackage up and running very reliabily with thousands of users.

Give the new ReleaseTwo a shot - download link on the Home Page.