#51

Re: Profil Modul spielt verrückt

13.12.2008 12:39 http://www.ff-stgeorgen.at/modules/profile/userinfo.php?uid=103

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

#52

Re: Profil Modul spielt verrückt

13.12.2008 10:23 Dankesehr - Problem jedoch leider weiterhin bestehend...

Userprofile lassen sich nicht aufrufen mit dem erweiterten Profil.

#53

Re: Profil Modul spielt verrückt

12.12.2008 16:24 Nö hab ich nicht. Reicht es wenn ich dies aktiviere?

LG

#54

Re: Profil Modul spielt verrückt

12.12.2008 08:20 Mit dem aktivierten Modul & als Gast bekomme ich die Meldung "Verzeihung, Sie haben nicht das Recht etc..." ohne Debug obwohl aktiviert.

Mit dem aktivierten Modul & Admin lassen sich einige User nicht aufrufen. Fehler:


Verzeihung, Sie haben nicht die Erlaubnis, diesen Bereich zu betreten. Gegebenenfalls setzen Sie sich mit dem Webmaster in Verbindung.

Wenn die Seite nicht automatisch neu lädt, klicken Sie bitte HIER
All errors (0) queries (12) 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 = '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.024 seconds to load.
Module init took 0.012 seconds to load.

#55

Re: Profil Modul spielt verrückt

11.12.2008 23:53 Nach Update etc. immer noch keine Besserung bei den Pages... Leider sind nur Standartpages möglich. Alles andre ist Fehlerhaft.
Lg

#56

Re: Private Nachrichten - Umleitung

11.12.2008 21:03 Ich habe das ganze Packet 2.3.2b raufgeladen und aktualisiert.
Nichts.
Lg

#57

Re: Private Nachrichten - Umleitung

10.12.2008 22:01 define( 'XOOPS_DB_CHARSET', 'utf8' );

#58

Re: Private Nachrichten - Umleitung

10.12.2008 21:38 Habe die von eurer Seite verwendet und dann die Standartmäßigen vom 2.3.2b.

Eigentlich stimmen sie nur bei "Aktionen" nicht wie z.b. "Beitrag geändert" oder "Wenn die Seite nicht automatisch neu lädt, klicken Sie bitte HIER"

Lg

#59

Re: Private Nachrichten - Umleitung

10.12.2008 16:52 Ja

#60

LogCounterx - Daten auslesen

10.12.2008 12:35 Hallo

Ich würde gerne auf der Hauptseite in einem PHP-Script vom Modul LogCounterX eine Statistik einbauen.

Genauer gesagt eigentlich nur die Anzahl der Besucher von heute und gesammt auslesen.

Jedoch habe ich keinen Plan wie das funktioniert, da das Script für jeden Tag eine eigene Tabelle anlegt.

Sprich muss ich die Abfrage so gestalten, dass das Script das heutige Datum im Format z.b. "2008-12-10" abfragt und danach die "cnt" ausgibt.

Habe leider keine Ahnung wie ich da anfangen soll...

Lg