Textpattern CMS

#1 2010-07-13 13:37:49

nabrown78

Member

From: Northampton, MA, USA

Registered: 2006-10-04

Posts: 294

Website

MySQL error upon managing comments

I am getting the following error:

Warning: Unknown column 'title' in 'where clause' select visible, COUNT(*) AS c from txp_discuss where parentid = '630' OR title like '%630%' GROUP BY visible in /home/content/j/a/n/janinea/html/textpattern/lib/txplib_db.php  on line 82

when I click the link to “manage” comments on any article from the articles list. If I visit the comments tab on its own, everything seems to work okay. The comments in questions (here, #630) do exist.

#2 2010-07-13 14:10:43

jsoo

Plugin Author

From: NC, USA

Registered: 2004-11-15

Posts: 1,793

Website

Re: MySQL error upon managing comments

txp_discuss doesn’t have a title field (column). I’m not familiar with a “manage comments” link; are you using a plugin for this?

---

Code is topiary

#3 2010-07-13 14:45:12

nabrown78

Member

From: Northampton, MA, USA

Registered: 2006-10-04

Posts: 294

Website

Re: MySQL error upon managing comments

Hi Jsoo – Well, I wasn’t familiar with it either, but a client of mine was having this issue and emailed me. Turns out, if you click “show detail” at the bottom of the article list, a “comments” column appears, with a link to “manage” if there are comments. However, she is using 4.0.7, so perhaps if I upgrade her site to 4.2, this error will just go away…