geThiGh
"myXOOPs"-Fortgeschrittener
Gepostet am:13.12.2008 12:39
#11
Mit dem normalen Modul funktioniert es - mit dem erweiterten nicht... und als Gast funktioniert es auch nicht. Berechtigungen sind alle gesetzt.
Debug:
SET NAMES 'utf8'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM ffstg_session WHERE sess_id = blablabla
SELECT * FROM ffstg_users WHERE uid = '1'
SELECT * FROM ffstg_modules WHERE dirname = 'profile'
SELECT * FROM ffstg_config WHERE (conf_modid = '45') ORDER BY conf_order ASC
SELECT * FROM ffstg_users WHERE uid = '103'
SELECT groupid FROM ffstg_groups_users_link WHERE uid=103
SELECT * FROM ffstg_group_permission WHERE (gperm_name = 'profile_access' AND gperm_modid = '45' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '26' OR gperm_groupid = '27'))
SELECT COUNT(*) FROM ffstg_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '45' AND (gperm_groupid = '2' OR gperm_groupid = '27'))
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_redirect.html') ORDER BY tpl_refid
Total: 12 queries
Blocks
Total: 0 blocks
Extra
Timers
XOOPS took 0.035 seconds to load.
XOOPS Boot took 0.023 seconds to load.
Module init took 0.012 seconds to load.
Ps: Habe auch ein weiteres Problem mit den Nachrichten. Ich habe eine bekommen es zeigt auch an Posteingang (1) aber wenn ich es anklicke - Keine Nachricht.
Bei der Säuberung tritt ebenfalls ein Fehler auf "Fehler bei der Säuberung"
Debug Nachricht:
Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45
Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 642
Queries
SET NAMES 'utf8'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM ffstg_session WHERE sess_id = 'b4de3273f07d857a00534d4e62908982'
SELECT * FROM ffstg_users WHERE uid = '1'
SELECT * FROM ffstg_modules WHERE dirname = 'pm'
SELECT * FROM ffstg_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM ffstg_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2,26,27)
SELECT b.* FROM ffstg_newblocks b, ffstg_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,2) AND b.bid IN (35,11,12,10,9,8,7,6,5,34,4,3,2,1,25,24,23,36,22,32,31,30,92,91,89,87,86,90,88,113,114,115,112,56,29,64,117,116,28,26,27,21,20,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51) ORDER BY b.weight,b.bid
SELECT * FROM ffstg_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM ffstg_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '26' OR gperm_groupid = '27'))
SELECT * FROM ffstg_modules WHERE dirname = 'news'
SELECT * FROM ffstg_config WHERE (conf_modid = '5') ORDER BY conf_order ASC
SELECT * FROM ffstg_modules WHERE dirname = 'wflinks'
SELECT * FROM ffstg_modules WHERE dirname = 'info'
SELECT * FROM ffstg_config WHERE (conf_modid = '28') ORDER BY conf_order ASC
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT catid,title FROM ffstg_info_cat
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM `ffstg_priv_msgs` WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT storyid,homepage FROM ffstg_info WHERE address ='/modules/pm/viewpmsg.php'
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'info_nav_block.html') ORDER BY tpl_refid
SELECT storyid,homepage FROM ffstg_info WHERE address ='/modules/pm/viewpmsg.php'
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
DELETE FROM ffstg_online WHERE online_updated < 1229167744
SELECT COUNT(*) FROM ffstg_online WHERE online_uid=1
UPDATE ffstg_online SET online_updated=1229168044, online_module = 2 WHERE online_uid = 1
SELECT * FROM ffstg_online
SELECT COUNT(*) FROM ffstg_online WHERE online_module = '2'
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT * FROM ffstg_modules WHERE dirname = 'extcal'
SELECT * FROM ffstg_config WHERE (conf_modid = '29' AND conf_catid = '0') ORDER BY conf_order ASC
SELECT * FROM ffstg_group_permission WHERE (gperm_name = 'extcal_cat_view' AND gperm_modid = '29' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '26' OR gperm_groupid = '27'))
SELECT * FROM ffstg_extcal_event WHERE (((event_start <= '1230764399' AND event_end >= '1228086000' AND event_isrecur = '0') OR (event_recur_start <= '1230764399' AND event_recur_end >= '1228086000' AND event_isrecur = '1')) AND event_approved = '1' AND cat_id IN (4,3,2,1)) ORDER BY event_start ASC
SELECT * FROM ffstg_smiles
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'extcal_block_minical.html') ORDER BY tpl_refid
SELECT count(user_id) as number FROM ffstg_evennews_members WHERE confirmed='1'
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'evennews_block_subcr.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM `ffstg_priv_msgs` WHERE (to_delete = '0' AND to_userid = '1' AND to_save = '0')
Error number: 1054
Error message: Unknown column 'to_delete' in 'where clause'
SELECT * FROM `ffstg_priv_msgs` WHERE (to_delete = '0' AND to_userid = '1' AND to_save = '0') ORDER BY msg_time DESC LIMIT 0, 20
Error number: 1054
Error message: Unknown column 'to_delete' in 'where clause'
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'pm_viewpmsg.html') ORDER BY tpl_refid
Debug Fehler bei der Säuberung:
All errors (0) queries (17) blocks (0) extra (0) timers (3)
Errors
Queries
SET NAMES 'utf8'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM ffstg_session WHERE sess_id = 'b4de3273f07d857a00534d4e62908982'
SELECT * FROM ffstg_users WHERE uid = '1'
SELECT * FROM ffstg_modules WHERE dirname = 'pm'
SELECT * FROM ffstg_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT * FROM ffstg_modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
SELECT * FROM ffstg_modules WHERE dirname = 'news'
SELECT * FROM ffstg_config WHERE (conf_modid = '5') ORDER BY conf_order ASC
SELECT * FROM ffstg_modules WHERE dirname = 'wflinks'
SELECT * FROM ffstg_modules WHERE dirname = 'info'
SELECT * FROM ffstg_config WHERE (conf_modid = '28') ORDER BY conf_order ASC
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT catid,title FROM ffstg_info_cat
DELETE FROM ffstg_priv_msgs WHERE (msg_time > '1229168400' AND msg_time < '1229168400' AND read_msg = '1' AND (to_save = '0' AND from_save = '0'))
Error number: 1054
Error message: Unknown column 'to_save' in 'where clause'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_redirect.html') ORDER BY tpl_refid
Total: 17 queries
Lg
Re: Profil Modul spielt verrückt
13.12.2008 12:39 http://www.ff-stgeorgen.at/modules/profile/userinfo.php?uid=103Mit dem normalen Modul funktioniert es - mit dem erweiterten nicht... und als Gast funktioniert es auch nicht. Berechtigungen sind alle gesetzt.
Debug:
SET NAMES 'utf8'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM ffstg_session WHERE sess_id = blablabla
SELECT * FROM ffstg_users WHERE uid = '1'
SELECT * FROM ffstg_modules WHERE dirname = 'profile'
SELECT * FROM ffstg_config WHERE (conf_modid = '45') ORDER BY conf_order ASC
SELECT * FROM ffstg_users WHERE uid = '103'
SELECT groupid FROM ffstg_groups_users_link WHERE uid=103
SELECT * FROM ffstg_group_permission WHERE (gperm_name = 'profile_access' AND gperm_modid = '45' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '26' OR gperm_groupid = '27'))
SELECT COUNT(*) FROM ffstg_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '45' AND (gperm_groupid = '2' OR gperm_groupid = '27'))
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_redirect.html') ORDER BY tpl_refid
Total: 12 queries
Blocks
Total: 0 blocks
Extra
Timers
XOOPS took 0.035 seconds to load.
XOOPS Boot took 0.023 seconds to load.
Module init took 0.012 seconds to load.
Ps: Habe auch ein weiteres Problem mit den Nachrichten. Ich habe eine bekommen es zeigt auch an Posteingang (1) aber wenn ich es anklicke - Keine Nachricht.
Bei der Säuberung tritt ebenfalls ein Fehler auf "Fehler bei der Säuberung"
Debug Nachricht:
Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45
Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 642
Queries
SET NAMES 'utf8'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM ffstg_session WHERE sess_id = 'b4de3273f07d857a00534d4e62908982'
SELECT * FROM ffstg_users WHERE uid = '1'
SELECT * FROM ffstg_modules WHERE dirname = 'pm'
SELECT * FROM ffstg_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM ffstg_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2,26,27)
SELECT b.* FROM ffstg_newblocks b, ffstg_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,2) AND b.bid IN (35,11,12,10,9,8,7,6,5,34,4,3,2,1,25,24,23,36,22,32,31,30,92,91,89,87,86,90,88,113,114,115,112,56,29,64,117,116,28,26,27,21,20,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51) ORDER BY b.weight,b.bid
SELECT * FROM ffstg_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM ffstg_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '26' OR gperm_groupid = '27'))
SELECT * FROM ffstg_modules WHERE dirname = 'news'
SELECT * FROM ffstg_config WHERE (conf_modid = '5') ORDER BY conf_order ASC
SELECT * FROM ffstg_modules WHERE dirname = 'wflinks'
SELECT * FROM ffstg_modules WHERE dirname = 'info'
SELECT * FROM ffstg_config WHERE (conf_modid = '28') ORDER BY conf_order ASC
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT catid,title FROM ffstg_info_cat
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM `ffstg_priv_msgs` WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT storyid,homepage FROM ffstg_info WHERE address ='/modules/pm/viewpmsg.php'
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'info_nav_block.html') ORDER BY tpl_refid
SELECT storyid,homepage FROM ffstg_info WHERE address ='/modules/pm/viewpmsg.php'
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
DELETE FROM ffstg_online WHERE online_updated < 1229167744
SELECT COUNT(*) FROM ffstg_online WHERE online_uid=1
UPDATE ffstg_online SET online_updated=1229168044, online_module = 2 WHERE online_uid = 1
SELECT * FROM ffstg_online
SELECT COUNT(*) FROM ffstg_online WHERE online_module = '2'
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT * FROM ffstg_modules WHERE dirname = 'extcal'
SELECT * FROM ffstg_config WHERE (conf_modid = '29' AND conf_catid = '0') ORDER BY conf_order ASC
SELECT * FROM ffstg_group_permission WHERE (gperm_name = 'extcal_cat_view' AND gperm_modid = '29' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '26' OR gperm_groupid = '27'))
SELECT * FROM ffstg_extcal_event WHERE (((event_start <= '1230764399' AND event_end >= '1228086000' AND event_isrecur = '0') OR (event_recur_start <= '1230764399' AND event_recur_end >= '1228086000' AND event_isrecur = '1')) AND event_approved = '1' AND cat_id IN (4,3,2,1)) ORDER BY event_start ASC
SELECT * FROM ffstg_smiles
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'extcal_block_minical.html') ORDER BY tpl_refid
SELECT count(user_id) as number FROM ffstg_evennews_members WHERE confirmed='1'
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'evennews_block_subcr.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM `ffstg_priv_msgs` WHERE (to_delete = '0' AND to_userid = '1' AND to_save = '0')
Error number: 1054
Error message: Unknown column 'to_delete' in 'where clause'
SELECT * FROM `ffstg_priv_msgs` WHERE (to_delete = '0' AND to_userid = '1' AND to_save = '0') ORDER BY msg_time DESC LIMIT 0, 20
Error number: 1054
Error message: Unknown column 'to_delete' in 'where clause'
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'pm_viewpmsg.html') ORDER BY tpl_refid
Debug Fehler bei der Säuberung:
All errors (0) queries (17) blocks (0) extra (0) timers (3)
Errors
Queries
SET NAMES 'utf8'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM ffstg_session WHERE sess_id = 'b4de3273f07d857a00534d4e62908982'
SELECT * FROM ffstg_users WHERE uid = '1'
SELECT * FROM ffstg_modules WHERE dirname = 'pm'
SELECT * FROM ffstg_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT * FROM ffstg_modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
SELECT * FROM ffstg_modules WHERE dirname = 'news'
SELECT * FROM ffstg_config WHERE (conf_modid = '5') ORDER BY conf_order ASC
SELECT * FROM ffstg_modules WHERE dirname = 'wflinks'
SELECT * FROM ffstg_modules WHERE dirname = 'info'
SELECT * FROM ffstg_config WHERE (conf_modid = '28') ORDER BY conf_order ASC
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT catid,title FROM ffstg_info_cat
DELETE FROM ffstg_priv_msgs WHERE (msg_time > '1229168400' AND msg_time < '1229168400' AND read_msg = '1' AND (to_save = '0' AND from_save = '0'))
Error number: 1054
Error message: Unknown column 'to_save' in 'where clause'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_redirect.html') ORDER BY tpl_refid
Total: 17 queries
Lg