[ROL-1637] Can't add new entry to Blog

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Abandoned
• Affects Version/s: 4.0
• Component/s: Data Model & JPA Backend
• Environment: Tomcat winbdows, Postgres, etc.
• Browser Version: Firefox
• Database: Postgres (EnterpriseDB 8.1.3.12 on linux)
• JDK Version: 1.5
• Level of effort: not sure
• O/S Version: Windows XP
• Assignee: Roller Unassigned
• Reporter: German Eichberger
• Created: 17/Dec/07 23:54
• Updated: 01/Mar/14 12:04
• Resolved: 06/Jan/13 02:04

Description

When I try to create a new entry (URL http://playersblog-local.station.sony.com/roller-ui/authoring/entryAdd!save.rol) I am getting an error "Error saving new entry" –

In the log file I am seeing the following exceptions:

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: unterminated quoted string at or near "'\') GROUP
BY t0.name, t0.total ORDER BY t0.name ASC"

{prepstmnt 29686429 SELECT t0.name, SUM(t0.total) FROM roller_weblogentrytagagg t0 WHERE (t0.websiteid = ? AND t0.name LIKE ? ESCAPE '\') GROUP BY t0.name, t0.total ORDER BY t0.name ASC [params=(String) 49fe2f46-d4e8-4f88-b824-d2a365b9445d, (String) test%]}

[code=0, state=42601]

....

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: syntax error at or near "t0"

{prepstmnt 18493627 UPDATE roller_tasklock t0 SET timeacquired = CURRENT_TIMESTAMP, client = ?, lastrun = ?, timeleased = ? WHERE (t0.name = ? AND t0.timeacquired = ? AND ? < CURRENT_TIMESTAMP) [params=(String) defaultClientId, (Timestamp) 2007-12-17 15:50:00.0, (int) 30, (String) ScheduledEntriesTask, (Timestamp) 1969-12-31 16:00:00.0, (Timestamp) 1969-12-31 16:00:00.0]}

[code=0, state=42601]

...

WARN 2007-12-17 15:50:00,119 JPAThreadManagerImpl:registerLease - Error obtaining lease, assuming race condition.
<0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: ERROR: syntax error at or near "t0"

{prepstmnt 9144209 UPDATE roller_tasklock t0 SET timeacquired = CURRENT_TIMESTAMP, client = ?, lastrun = ?, timeleased = ? WHERE (t0.name = ? AND t0.timeacquired = ? AND ? < CURRENT_TIMESTAMP) [params=(String) defaultClientId, (Timestamp) 2007-12-17 15:50:00.0, (int) 30, (String) PingQueueTask, (Timestamp) 1969-12-31 16:00:00.0, (Timestamp) 1969-12-31 16:00:00.0]}

[code=0, state=42601]
FailedObject: org.apache.openjpa.jdbc.kernel.exps.ExpContext@1dfb8d0

....

WARN 2007-12-17 15:50:34,572 WebloggerRuntimeConfig:getProperty - Trouble accessing property: site.shortName
<0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: ERROR: current transaction is aborted, commands ignored until end of transaction block

{prepstmnt 24230640 SELECT t0.value FROM roller_properties t0 WHERE t0.name = ? [params=(String) site.shortName]}

[code=0, state=25P02]

....

NestedThrowables:
java.sql.SQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

....