Geeklog Forums

Hey there...
not sure where to put this, will put it here and the forum..
I installed the latest mycal and latest geeklog...
all went well..I installed the journal and all went well, EXCEPT, in the my cal block, when I click on a day, any day of the month I get this error... An SQL error has occured. Please see error.log for details.

The error log says the following...
Sat Nov 13 17:45:50 2004 - SELECT * FROM mnu_index WHERE ((perm_anon >= 3) OR (perm_members >= 2) OR ((group_id = 2) AND (perm_group >= 2)) OR ((group_id = 4) AND (perm_group >= 2)) OR ((group_id = 7) AND (perm_group >= 2)) OR ((group_id = 25) AND (perm_group >= 2)) OR ((group_id = 26) AND (perm_group >= 2)) OR ((group_id = 27) AND (perm_group >= 2)) OR ((group_id = 2 AND (perm_group >= 2)) OR ((group_id = 11) AND (perm_group >= 2)) OR ((group_id = 36) AND (perm_group >= 2)) OR ((group_id = 5) AND (perm_group >= 2)) OR ((group_id = 13) AND (perm_group >= 2)) OR ((group_id = 12) AND (perm_group >= 2)) OR ((group_id = 17) AND (perm_group >= 2)) OR ((group_id = 10) AND (perm_group >= 2)) OR ((group_id = AND (perm_group >= 2)) OR ((group_id = 1) AND (perm_group >= 2)) OR ((group_id = 14) AND (perm_group >= 2)) OR ((group_id = 3) AND (perm_group >= 2)) OR ((group_id = 6) AND (perm_group >= 2)) OR ((group_id = 9) AND (perm_group >= 2)) OR ((group_id = 34) AND (perm_group >= 2)) OR ((group_id = 22) AND (perm_group >= 2)) OR ((group_id = 19) AND (perm_group >= 2)) OR ((group_id = 24) AND (perm_group >= 2)) OR ((group_id = 15) AND (perm_group >= 2)) OR ((owner_id = 2) AND (perm_owner >= 2))) AND (lang = 'english') ORDER BY m_pos ASC
Sat Nov 13 17:45:50 2004 - nrows = 13 language = english
Sat Nov 13 17:45:50 2004 - 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 '1099461600' AND '1099465200') ORDER BY day DESC


THe journal plugin installed fine...but this is the only bug I have found..I uninstalled and clicked a day and no error, reinstalled journal and it errorred...
i left it installed for now, so you can see....
www.calvarychapelasheville.org and click a day in the mycal block and you will see..
Can you tell me how to fix this? thanks..t

See if this helps.

Also, the first couple of entries are from the Menu plugin, see here.

bye, Dirk

Hey Dirk..thanks so much...you are a lifesaver..I did not realize that the menu was erroring..thank you so much..t