Ok I read the message. But Im a bit dense. Is there a patch there?
I can see the sql sequence from oracle. And then this bit of code
IF :NEW.visitorid IS NULL THEN
SELECT visitor_sequence.nextVal() INTO :NEW.visitorid FROM dual;
END IF;
END;
Where does this come from. Im guessing the jyve source. Or is this a patch
to add to the source. I couldnt find the "NEW.visitorid" instance in the
current source that I have.
Andreas H�rtel wrote:
> Hallo,
>
> > I believe I have most things running. But I get "Error" on the front
> > page. I can login, add a new account, browse the projects, and a few
> > other things. Ive tried looking for a typo or missing screen setting.
> > But no luck. Ive recompiled, restarted, used 2 diferent servers.
> > But still the same thing. I also get
>
> > Requested Screen not found:
> > Turbine looked in the following modules.packages path:
> > [org.apache.jyve, org.apache.jyve.layouts, org.apache.jyve.screens,
> > org.apache.jyve.actions, org.apache.turbine.modules]
>
> > But it dosent say what screen. I also get an sql error
>
> > SQL syntax near 'UNION SELECT question.question_id, 0 as count FROM
> > question WHERE NOT EXISTS ( ' at line 1
>
> > Any help or pointers would be greatly appreciated.
>
> see my message: Exception: ORACLE error
> There is a fix for the ORACLE syntax error in statement.
>
> For your first question I need help also.
>
> Andreas
--
[EMAIL PROTECTED]
Grabel's Law:
2 is not equal to 3 -- not even for large values of 2.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
