MySQL Error?

Worker Joined: May 27, 2006 Posts: 157

Any ideas why this is displayed down the right hand side of my site? [ Only registered users can see links on this board! Get registered or login! ] if you want to see it.

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='yearly' AND recur_month= AND isactive=1 AND
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='monthly' AND isactive=1 AND isrecurring=1 A
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='weekly' AND isactive=1 AND isrecurring=1 AN
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='yearly' AND recur_month= AND isactive=1 AND
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='monthly' AND isactive=1 AND isrecurring=1 A
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='weekly' AND isactive=1 AND isrecurring=1 AN
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='yearly' AND recur_month= AND isactive=1 AND
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='monthly' AND isactive=1 AND isrecurring=1 A
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='weekly' AND isactive=1 AND isrecurring=1 AN
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='yearly' AND recur_month= AND isactive=1 AND
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='monthly' AND isactive=1 AND isrecurring=1 A
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND recur_schedule='weekly' AND isactive=1 AND isrecurring=1 AN

Posted: Wed Aug 30, 2006 12:04 pm

Looks like something from your calendar block. What calendar addon are you using?

Posted: Wed Aug 30, 2006 12:31 pm

im using NUCalendar, i found out it was the calendar and removed that particular block and used a diff one they supply! its working ok now! so note to anyone, dont use NUCalendars block-Month of Events use block-Month of events2 that comes in the same package!