Okay, for DAYS I've been trying to figure this out, but no luck. Hoping someone is a MySQL pro and can offer some advice! The error messages even have my web host stumped.
I'm using XOOPS 2.2.3 and eXtCal 2.0.2. The MySQL version is 4.0.12-nt. When I run debug here's what it says:
Queries module
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '16' AND gperm_name = 'extcal_cat_view' AND gperm_groupid IN (1,2))
( 0.002398)
[color=FF0000]SELECT * FROM xoops_extcal_cat WHERE (cat_id IN (,6,4,8,5,3,2,1))
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 '6,4,8,5,3,2,1))' at line 1
( 0.00054)
SELECT * FROM xoops_extcal_event WHERE (event_start <= '1138769999' AND event_end >= '1136091600' AND event_approved = '1' AND cat_id IN (,6,4,8,5,3,2,1)) 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 '6,4,8,5,3,2,1)) ORDER BY event_start ASC' at line 1
( 0.000517)
SELECT * FROM xoops_extcal_cat WHERE (cat_id IN (,6,4,8,5,3,2,1))
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 '6,4,8,5,3,2,1))' at line 1
( 0.000526)[/color]
Total Number of Queries: 4 | Total SQL Generation Time: 0.003981
I only posted the red errors, all other queries report fine.
This also happens with piCal installed. These programs run fine on my local host, but when I install on the host server,
Any help is appreciated!
