Thanks for the details James. Comments below.
On 12/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
OK.
Happens on both WinXp and Win2K
Both are tomcat 5.5.15, Java 1.5.0_06-b05, DB is Oracle 10g
new install of roller 3.0 onto a clean install of DB tables, with 3 blogs each
with 3 entries
I login
select new entry on the blog i wanna create a new entry for
enter something in the title
enter something in the Summary
click post to weblog
the next page says
"Changes saved"
and 3 lines lower
Status Published (Last updated 01/12/06 11:08)
but on the right-hand side, where you have listed the pending entries, Recent
Drafts and Recent Entries, the new entry is not there, and going to
/blogs/bmcblog/entry/20061201 i get a Tomcat 404 error page.
same behaviour when creating a new entry with title, summary, content - NOT selecting a
Pub Time, and doing a save as draft is says "Changes saved" and
Status Draft (Last updated 01/12/06 11:26)
but, again, nothing on the right-hand side
Ah... Oracle!
Sack trace for the first instance:
WARN 2006-12-01 11:08:04,109 JDBCExceptionReporter:logExceptions - SQL Error:
1400, SQLState: 23000
ERROR 2006-12-01 11:08:04,109 JDBCExceptionReporter:logExceptions - ORA-01400: cannot insert NULL into
("BMC_BLOG"."WEBLOGENTRY"."TEXT")
WARN 2006-12-01 11:08:04,125 JDBCExceptionReporter:logExceptions - SQL Error:
1400, SQLState: 23000
ERROR 2006-12-01 11:08:04,125 JDBCExceptionReporter:logExceptions - ORA-01400: cannot insert NULL into
("BMC_BLOG"."WEBLOGENTRY"."TEXT")
ERROR 2006-12-01 11:08:04,140 AbstractFlushingEventListener:performExecutions -
Could not synchronize database state with session
I'm not an Oracle user, but I've heard that Oracle counts the empty
string as a NULL. Perhaps an Oracle user could step in now and explain
how they worked around the problem.
If I had to guess at a workaround, I'd suggest using ALTER TABLE
statement to make title, summary and text nullable.
- Dave
-----Original Message-----
From: Dave [mailto:[EMAIL PROTECTED]
Sent: 30 November 2006 17:12
To: [email protected]
Subject: Re: no error message
I haven't encountered that problem before and I can't reproduce it.
Please provide some details about your system. What O/S, Java version,
app server and database? What is the stack trace you see in the logs?
- Dave
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 29 November 2006 17:01
> To: [email protected]
> Subject: no error message
>
>
> Hi Guys,
>
> I am running roller 3.0 have discovered a small annoyance.
>
> If you try to create a new entry and not put anything in the "Content" field
box there is no error message telling you there was a problem...there is a nice stack trace
in the logs tho.
>
> if you then click "Post to Weblog" again then you get the following message
> "Unexpected Exception
> Roller has encountered and logged an unexpected exception."
>
> James
>
> James Nott
> Senior Developer, BioMed Central
> Email: [EMAIL PROTECTED]
> Direct Tel: 020 7631 9933
