3
I am currently running the latest version of Excal v2.22 and XOOPS 2.4.2 on a server running php and MySQL 5. The problem I am currently having is when people try to submit events they just get a blank page. When I switch on debug, it does not really seem to show anything up on the debug option.
Also, when trying to display the latest events block, I get the following error message:
.000198 - SELECT * FROM extcal_event WHERE (((event_start <= '1270079999' AND event_end >= '1267401600' AND event_isrecur = '0') OR (event_recur_start <= '1270079999' AND event_recur_end >= '1267401600' AND event_isrecur = '1')) AND event_approved = '1' AND cat_id IN () AND cat_id IN (1,2,3,4,5,6,7,8,12,9,10,11)) ORDER BY event_start ASC
Error number: 1064
Error message: 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 cat_id IN (1,2,3,4,5,6,7,8,12,9,10,11)) ORDER BY event_start ASC' at line 1
Any ideas on how to fix this? Is this still supported or is there a preferred events module for xoops?
Dan
