Welcome to Geeklog, Anonymous Saturday, July 20 2024 @ 06:11 pm EDT

Geeklog Forums

Calandar search and Mike's journal


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

All times are EDT. The time is now 06:11 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