Hallo,
sorry, the fragment of code refers to ORACLE users only. It is a trigger,
wrote in PL/SQL to fix the sequence problem.
The error below was a missing FROM clause in the SELECT statement.
See the Mail: Exception: Oracle error. This could meet the problem in
mysql also.
Andreas
> 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]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
