Welcome to Geeklog, Anonymous Saturday, April 20 2024 @ 04:31 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
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
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
4
2
Quote
All times are EDT. The time is now 04:31 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