roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "German Eichberger (JIRA)" <>
Subject [Roller-JIRA] Created: (ROL-1632) DB error when inserting an entry into the DB / creating an entry for a Blog
Date Fri, 14 Dec 2007 19:32:38 GMT
DB error when inserting an entry into the DB / creating an entry for a Blog

                 Key: ROL-1632
             Project: Roller
          Issue Type: Bug
          Components: Database Access & Data Model
    Affects Versions: 4.0
         Environment: Linux, Postgres, etc.
            Reporter: German Eichberger
            Assignee: Roller Unassigned
            Priority: Blocker

Creating an entry for a blog results in the following error:

ERROR: column t0.contenttype does not exist {prepstmnt 4714428 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)
7f694d21-bd78-4df1-a774-7cb252afe79f]} [code=0, state=42703]

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:


View raw message