5
Agenda-X 2.2 works, but I still get error messages, but the only problem about this calender is that I cannot post events in the calender or it won't let me.
error messages:
All errors (1) queries (48) blocks (13) extra (0) timers (6)
Errors
Notice: Only variable references should be returned by reference in file /modules/myiframe/class/myiframe.php line 99
Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = 'd2ci8dee0844kdpg4el7rqvof4'
SELECT * FROM xoops_users WHERE uid=1
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 1, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 2
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND b.bid IN (63,1,53,108,2,52,3,51,22,4,21,5,20,19,6,18,17,7,16,8,15,9,12,10,11,13,14,50,64,49,23,109,110) ORDER BY b.weight,b.bid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_multimenu01 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu01 WHERE hide = 1 ORDER BY weight ASC
SELECT * FROM xoops_smiles
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_01.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_menu.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_multimenu02 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu02 WHERE hide = 1 ORDER BY weight ASC
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_02.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_multimenu03 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu03 WHERE hide = 1 ORDER BY weight ASC
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_03.html') ORDER BY tpl_refid
SELECT * FROM xoops_myiframe WHERE frame_frameid=0
SELECT * FROM xoops_modules WHERE dirname = 'smartsection'
SELECT * FROM xoops_config WHERE (conf_modid = '10') ORDER BY conf_order ASC
SELECT * FROM xoops_smartsection_items WHERE ((status = '2') AND datesub <= '1159863174') ORDER BY datesub DESC LIMIT 0, 5
SELECT * FROM xoops_smartsection_categories
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '10')
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'smartsection_items_new.html') ORDER BY tpl_refid
SELECT * FROM xoops_smartsection_items WHERE ((status = '2') AND datesub <= '1159863174') ORDER BY datesub DESC LIMIT 0, 5
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'smartsection_items_recent.html') ORDER BY tpl_refid
SELECT * FROM xoops_smartsection_categories WHERE (parentid = '0') ORDER BY weight ASC
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'smartsection_items_menu.html') ORDER BY tpl_refid
SELECT * FROM xoops_modules WHERE dirname = 'wfdownloads'
SELECT * FROM xoops_config WHERE (conf_modid = '14') ORDER BY conf_order ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'WFDownCatPerm' AND gperm_modid = '14' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xoops_wfdownloads_downloads WHERE (offline = '0') ORDER BY published DESC LIMIT 0, 10
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'WFDownCatPerm' AND gperm_modid = '14' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xoops_wfdownloads_downloads WHERE (offline = '0') ORDER BY hits DESC LIMIT 0, 10
SELECT id, title, date FROM xoops_agendax_events WHERE approved=1 AND date=20061003
SELECT id, title, date FROM xoops_agendax_events WHERE approved=1 AND type = 'E' AND ( date>20061003 AND date <=20061202 )
SELECT id, title, date FROM xoops_agendax_events LEFT JOIN xoops_agendax_event_repeats ON id=event_id WHERE approved=1 AND type = 'R' AND (event_end=0 OR event_end is NULL OR event_end <=20061202)
SELECT title, description, contact, url, email, picture, cat, date, time, id, ext_for_id, priority, access, duration, cat_name, type FROM xoops_agendax_events LEFT JOIN xoops_agendax_cat ON cat = cat_id WHERE approved = 1 AND xoops_agendax_events.date >= 20061001 AND xoops_agendax_events.date <= 20061031 ORDER BY time, id
SELECT title, description, contact, url, email, picture, cat, date, time, id, ext_for_id, priority, access, duration, cat_name, type , event_rpt_type, event_end, frequency, event_repeaton_days FROM xoops_agendax_events, xoops_agendax_event_repeats LEFT JOIN xoops_agendax_cat ON cat = cat_id WHERE id = event_id AND approved = 1 ORDER BY time, id
Error number: 1054
Error message: Unknown column 'cat' in 'on clause'
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'minical_block.html') ORDER BY tpl_refid
SELECT id, title, date FROM xoops_agendax_events WHERE approved=1 AND type = 'E' AND ( date >= 20061003 AND date < 20061010 ) ORDER BY date ASC
SELECT id, title, date FROM xoops_agendax_events LEFT JOIN xoops_agendax_event_repeats ON id=event_id WHERE approved=1 AND type = 'R' AND (event_end=0 OR event_end is NULL OR event_end <=20061010)
SELECT id, title, date FROM xoops_agendax_events WHERE approved=1 AND type = 'E' AND ( date >= 20061003 AND date < 20061102 ) ORDER BY date ASC
SELECT id, title, date FROM xoops_agendax_events LEFT JOIN xoops_agendax_event_repeats ON id=event_id WHERE approved=1 AND type='R' AND (event_end=0 OR event_end is NULL OR event_end <=20061102)
Total: 48 queries
Blocks
Search: No Cache
multiMenu 01: No Cache
multiMenu 02: No Cache
multiMenu 03: No Cache
Show an iframe: No Cache
Recent items List: No Cache
Recent items (Detail): No Cache
Categories Menu block: No Cache
Recent WF-Downloads: No Cache
Top WF-Downloads: No Cache
Minical: No Cache
Upcoming Week events: No Cache
Upcoming 30 day events: No Cache
Total: 13 blocks
Extra
Timers
XOOPS took 0.560 seconds to load.
XOOPS Boot took 0.090 seconds to load.
Module init took 0.006 seconds to load.
XOOPS output init took 0.453 seconds to load.
Module display took 0.001 seconds to load.
Page rendering took 0.004 seconds to load.
this is just the first. got a few more to go
"Feed the children of the next generation cocaine, LSD, and XTC"