Welcome to Geeklog, Anonymous Tuesday, June 18 2024 @ 02:17 am EDT

Geeklog Forums

Journal Problem in error.log


Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
Dirk, et al.

Using the journal plugin (updated from CVS) and i'm getting this error in my error.log

Text Formatted Code

Sun Nov  9 18:34:04 2003 - 1054: Unknown column 'date' in 'where clause'. SQL in question: SELECT je_id,je_summary,je_text,UNIX_TIMESTAMP(je_date) as day,'journal' as type,jrn_name,jt_name,jrn_uid,je_hits FROM gl_journal_entry,gl_journal_type,gl_journal WHERE ((jrn_id = je_jrn_id) AND (jt_id = jrn_jt_id) AND (je_public = 1) AND (jrn_public = 1)) AND ((jrn_name like '%%') OR (je_text like '%%') OR (je_summary like '%%')) AND (UNIX_TIMESTAMP(date) BETWEEN '1068364800' AND '1068368400') ORDER BY day DESC

 

Any suggestions?
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

All times are EDT. The time is now 02:17 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content