Oracle Problem Reports
Hello everyone.
I am trying to install a TikiWiki 1.9.3.2 version into an Oracle 9ir2 database.
I had followed the installation procedures and got some errors.
(I not using anymore the chandra's Oracle9iInstall instructions because those
aparently apply to an old version).
I just ignore the reported errors and follow to admin page.
So I got the following message. After that, I create the table manually and could get to the homepage.
As I procced with installation and test I will report other problems within this topic.
Context:
File /tiki19/tiki-index.php
Url /tiki19/tiki-index.php
Query:
select count(*) from "tiki_stats" where "object"=:0 and "type"=:1 and "day"=:2
Values:
0 HomePage
1 wiki
2 1149735600
Message:
Error Message ORA-00942: table or view does not exist
Just for reference, aparently there is a problem in the tiki-1.9-oci8.sql script, just in the end:
CREATE TABLE `tiki_stats` (
`object` varchar(255) default '' NOT NULL,
`type` varchar(20) default '' NOT NULL,
`day` number(14) default '0' NOT NULL,
`hits` number(14) default '0' NOT NULL,
PRIMARY KEY ("`object`","`type`","`day`")
) ;
I had run the following while connected in the SQLPlus manually:
CREATE TABLE "tiki_stats" (
"object" varchar(255) default '' NOT NULL,
"type" varchar(20) default '' NOT NULL,
"day" number(14) default '0' NOT NULL,
"hits" number(14) default '0' NOT NULL,
PRIMARY KEY ("object","type","day")
)