In order for me to get this working, I had to change the schema so that
all timestamps had a default value. In postgres, the syntax is:
...
MODIFIED_DATE timestamp default 'now',
...
mike
On Thu, Nov 09, 2000 at 11:06:33AM +0000, Andreas H�rtel wrote:
>
> Hallo Miko,
>
> I've had the same problem. I'm using ORACLE 8.1.6.
>
> When a new question will be created, the value of modified_date is null.
> Jyve deliver an exception... When a date set to question.modified_date
> with SQL directly, Jyve works correctly.
>
> Andreas
>
> Am 08.11.2000, 20:46:57, schrieb Mike Haberman <[EMAIL PROTECTED]> zum
> Thema Re: Error on front page:
>
>
> > what database are you using ?
>
>
> > mike
>
> > On Wed, Nov 08, 2000 at 06:53:54PM +0000, D.R. Holsbeck wrote:
> > > 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.
> > >
> > > --
> > > [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]
>
>
> --
> --------------------------------------------------------------
> 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]
