roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anne Priya Alexander (JIRA)" <>
Subject [jira] Created: (ROL-1814) getting exception when adding a new entry to the weblog
Date Fri, 22 May 2009 09:56:45 GMT
getting exception when adding a new entry to the weblog

                 Key: ROL-1814
             Project: Roller
          Issue Type: Question
          Components: Database Access & Data Model
    Affects Versions: 4.0.1
         Environment: Windows XP
            Reporter: Anne Priya Alexander
            Assignee: Roller Unassigned

     i have installed roller as per the steps and was able to  create a new weblog but as
soon as i submit a new entry to the blog and click on "post to weblog"  i am getting the below
mentioned exception 

<0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException:
DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null {prepstmnt 20121261 SELECT, t0.content, t0.contenttype,,, t0.notify, t0.plugins, t0.posttime,
t0.referrer, t0.remotehost, t0.status, t0.url, t0.useragent,, t1.allowcomments, t1.anchor,, t2.description, t2.image,,, t3.description, t3.image,, t3.path,
t3.websiteid, t2.path,, t4.about, t4.isactive, t4.allowcomments, t4.blacklist,,
t5.description, t5.image,, t5.path, t5.websiteid,, t6.activationcode, t6.datecreated,
t6.emailaddress, t6.isenabled, t6.fullname, t6.locale, t6.passphrase, t6.screenname, t6.timeZone,
t6.username, t4.customstylesheet, t4.datecreated, t4.defaultallowcomments,, t7.description,
t7.image,, t7.path, t7.websiteid, t4.defaultcommentdays, t4.defaultpageid, t4.defaultplugins,
t4.description, t4.editorpage, t4.editortheme, t4.emailaddress, t4.emailcomments, t4.emailfromaddress,
t4.enablebloggerapi, t4.enablemultilang, t4.isenabled, t4.displaycnt, t4.handle, t4.icon,
t4.lastmodified, t4.locale, t4.commentmod,, t4.pagemodels, t4.showalllangs, t4.timeZone,
t4.weblogdayid, t1.commentdays, t1.content_src, t1.content_type,, t8.activationcode,
t8.datecreated, t8.emailaddress, t8.isenabled, t8.fullname, t8.locale, t8.passphrase, t8.screenname,
t8.timeZone, t8.username,, t1.locale, t1.pinnedtomain, t1.plugins, t1.pubtime, t1.righttoleft,
t1.status, t1.summary, t1.text, t1.title, t1.updatetime,, t9.about, t9.isactive, t9.allowcomments,
t9.blacklist, t9.bloggercatid, t9.userid, t9.customstylesheet, t9.datecreated, t9.defaultallowcomments,
t9.defaultcatid, t9.defaultcommentdays, t9.defaultpageid, t9.defaultplugins, t9.description,
t9.editorpage, t9.editortheme, t9.emailaddress, t9.emailcomments, t9.emailfromaddress, t9.enablebloggerapi,
t9.enablemultilang, t9.isenabled, t9.displaycnt, t9.handle, t9.icon, t9.lastmodified, t9.locale,
t9.commentmod,, t9.pagemodels, t9.showalllangs, t9.timeZone, t9.weblogdayid FROM roller_comment
t0 LEFT OUTER JOIN weblogentry t1 ON t0.entryid = LEFT OUTER JOIN weblogcategory t2
ON t1.categoryid = LEFT OUTER JOIN rolleruser t8 ON t1.userid = LEFT OUTER JOIN
website t9 ON t1.websiteid = LEFT OUTER JOIN weblogcategory t3 ON t2.parentid =
LEFT OUTER JOIN website t4 ON t2.websiteid = LEFT OUTER JOIN weblogcategory t5 ON t4.bloggercatid
= LEFT OUTER JOIN rolleruser t6 ON t4.userid = LEFT OUTER JOIN weblogcategory
t7 ON t4.defaultcatid = WHERE (t0.entryid = ?) ORDER BY t0.posttime ASC [params=(String)
c1da0b48-0902-4a3e-affa-893fc390196a]} [code=-1585, state=54048]SQLCA OUTPUT[Errp=SQLNO24B,
Errd=[-2145779603, 0, 0, 0, -1000, 0]]

Can anyone help me  resolve this issue . 

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message