The secure CMS.

Welcome to Geeklog, Anonymous Thursday, April 18 2024 @ 01:56 pm EDT

Geeklog Forums

Calandar search and Mike's journal

 New Topic  Post Reply
 09/04/04 08:35pm (Read 2,331 times)  
Status: offline

scroff

Forum User
Regular Poster
Registered: 02/19/03
Posts: 111
Text Formatted Code
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 '1094616000' AND '1094619600') ORDER BY day DESC
 


I installed theMike's journal and it seems to be working well enough, but I went to do a search through the calander (mycal) and received that error. It looks like it's something pretty easy, but thats because I know about squat about mysql. Any takers on how I can get this search going again, short of removing the journal? Can I just add the column date? If so... how?

Thanks!
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 01:56 pm.
  • 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