Loading...
 
Skip to main content

Architecture / Installation


You are viewing a reply to Oracle Problem Reports

Re: Oracle Problem Reports

Another test case:

1.Create a forum (with any configuration)
2.Click the List Forum link
3.Click the Forum you just created.
4.Click the "New Topic" button
5.Add a title and a comment and click preview button
6.Click the post button

An Error message came up:
ORA-00923: FROM keyword not found where expected

File: /tiki19/tiki-view_forum_thread.php
URL: /tiki19/tiki-view_forum_thread.php?comments_parentId=2&topics_threshold=0&topics_offset=1&topics_sort_mode=commentDate_desc&topics_find=&forumId=1
The query:


select s."user", p."value" as 'realName', "timestamp", "tikihost" from "tiki_sessions" s left join "tiki_user_preferences" p on s."user":0 and s.user = p.user and p.prefName = 'realName' where s.user is not null;



I tried to run the select above into the sqlplus and get the same error.
I corrected the select for the below and it run ok into the sqlplus.
The select is within the ./lib/tikilib.php.
I corrected the select. The file is attached.
After that I rerun the test and another error came up. I will resolve this error in another post.


select
s."user",
p."value" as realName,
"timestamp",
"tikihost"
from
"tiki_sessions" s
left join "tiki_user_preferences" p
on s."user"''
and s."user" = p."user"
and p."prefName" = 'realName'
where s."user" is not null
/