Posted on: 12/20/03 01:22am
By: bedathur
A sample sql error looks like this:
Fri 19 Dec 2003 05:14:49 PM CST - 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 '1070949600' AND '1070953200') ORDER BY day DESC