Loading...
 
Skip to main content

Tiki does not install clean on Oracle

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Tiki does not install clean on Oracle
Version
1.9.x
Category
  • Error
Feature
Installer (profiles, upgrades and server-related issues)
Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)
Resolution status
Won't Fix
Lastmod by
Kissaki
Rating
(0)
Description

many object names too long for oracle which has max size of 30 for any object (column, table, sequence, etc.)

able to modify some items such as sequence and trigger that are internal to db and not in tiki code.

initial oracle-1.9-oci8.sql had many errors including the use of datatype integer and auto-increment which doe not exist in oracle. additional insert to blob column not formed to use oracle utl_raw.cast_to_raw. oracle quote in sql field insert should be two quotes ('') instead of backslash quote (\')

main tables still not available
tiki_content_templates_sections
tiki_forums
because outbound_mails_for_inbound_mails column
tiki_live_support_message_comments

is there a workaround that if I change the object name in the database to be <=30, that the code will not abort.

- Usage of "CLOB" in Oracle different from "Text" in MySQL, so usage of every table has to be checked.
(especially where LOB-Index is used as a reference (e.g. tiki_languages))

- Oracle can not use CLOBs for indices so search functionality has to be checked (fulltext index?)

Files
  1. tiki-oracle.zip
  2. Diff
Solution

Oracle support dropped.
Sorry.

Importance
3
Priority
15
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
447
Created
Thursday 22 December, 2005 16:48:38 UTC
by Unknown
LastModif
Saturday 06 July, 2024 10:21:44 UTC


Show PHP error messages