Re: Re: Oracle Problem Reports
Follow the same test case below:
> 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
...
> After that I rerun the test and another error came up. I will resolve this error in another post.
The error that came up is:
ORA-01741: illegal zero-length identifier
The select:
select tc1."threadId", tc1."object", tc1."objectType", tc1."parentId", tc1."userName", tc1."commentDate", tc1."hits", tc1."type", tc1."points", tc1."votes", tc1."average", tc1."title", tc1."data", tc1."hash", tc1."user_ip", tc1."summary", tc1."smiley", tc1."message_id", tc1."in_reply_to", tc1."comment_rating" from "tiki_comments" as tc1 left outer join "tiki_comments" as tc2 on tc1."in_reply_to" = tc2."message_id" and tc1."parentId" = :0 and tc2."parentId" = :1 where tc1."objectType" = :2 and tc1."object"=:3 and tc1."parentId"=:4 and tc1."average">=:5 and (tc1."in_reply_to" = :6 or (tc2."in_reply_to" = "" or tc2."in_reply_to" is null or tc2.message_id is null or tc2.parentid = 0)) order by tc1."commentDate" desc,tc1."threadId"
The select can be found at the file ./lib/commentslib.php
After that another error came up. I am tired of correting and posting each one so i corrected this third error
too. 🙄
The corrected version of the file is attached.
Some of the corrections can be not portable because I do not check them into other databases. I will leave this to the development team 😁