|
fehlermeldung - banners - adminmenü
|
|
|
|
| cmsxoo | Re: fehlermeldung - banners - adminmenü |  Anfänger
Mitglied seit:08.07.2006 Beiträge:6 Aus:
Level: 1
 | | | hallo,
Zitat:adminmenü -> sysadmin -> system dort DebugModus -> db abfragen einschalten
danke :) - 10x übersehen, weil ganz am rand war (800x600)
also... :
Code:3: DELETE FROM exp_session WHERE time<1151793110 4: SELECT u.uid, u.uname, u.pass, s.hash FROM exp_session s INNER JOIN exp_users u ON u.uid=s.uid WHERE s.hash='46145a119889e9f2e694b40dc471feea' 5: UPDATE exp_session SET time=1152397110 WHERE uid=1 6: SELECT * FROM exp_users WHERE uid=1 7: SELECT * FROM exp_users_conf WHERE uid=1 8: SELECT country_language FROM exp_country_land where country_id=81 9: SELECT languages_id FROM exp_languages where directory='deutsch' 10: SELECT languages_id FROM exp_languages where directory='deutsch' 11: SELECT * FROM exp_modules WHERE dirname = 'news' 12: SELECT version FROM exp_modules WHERE mid='2' 13: SELECT configuration_key, configuration_value FROM exp_exv2_configuration WHERE configuration_key='news_update_ok' OR configuration_key='news_usersubmit' OR configuration_key='news_anonsubmit' 14: SELECT t1.topic_id, t2.topic_title FROM exp_topics_users_link t1 LEFT JOIN exp_topics t2 ON t2.topic_id=t1.topic_id WHERE t1.uid=1 ORDER BY uid ASC 15: SELECT g.* FROM exp_groups g LEFT JOIN exp_groups_users_link l ON l.groupid=g.groupid WHERE l.uid=1 16: SELECT COUNT(*) FROM exp_groups_modules_link WHERE type='R' AND mid=2 AND (groupid=1 OR groupid=2) 17: SELECT configuration_group_id FROM exp_exv2_configuration_group WHERE configuration_group_pid>0 AND configuration_mid=2 ORDER BY sort_order ASC 18: SELECT configuration_key, configuration_value FROM exp_exv2_configuration WHERE configuration_group_id=11 OR configuration_group_id=12
19: SELECT b.* FROM exp_newblocks b LEFT JOIN exp_groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=1 OR l.groupid=2) AND b.isactive=1 AND side=0 AND b.visible=1 AND (b.show_mid=2 OR b.show_mid=0) AND (3 & b.page_style) ORDER BY b.weight, b.bid 20: SELECT COUNT(*) FROM exp_private_msgs WHERE to_userid = 1 21: SELECT COUNT(*) FROM exp_private_msgs WHERE to_userid = 1 AND read_msg=0 22: SELECT COUNT(*) FROM exp_private_msgs_config WHERE msg_uid = 1 23: SELECT COUNT(*) FROM exp_groups_modules_link WHERE type='A' AND (groupid=1 OR groupid=2)
24: SELECT rank_id, rank_title FROM exp_ranks WHERE rank_special = 1 25: SELECT COUNT(*) FROM exp_users WHERE (level >0 and user_status =0 and rank!='9') or (user_status >1 and rank!='9') or level =0 26: SELECT dirname FROM exp_modules WHERE isactive=1 AND haswaiting=1 27: SELECT version FROM exp_modules WHERE mid='2' 28: SELECT configuration_key, configuration_value FROM exp_exv2_configuration WHERE configuration_key='news_update_ok' OR configuration_key='news_usersubmit' OR configuration_key='news_anonsubmit' 29: SELECT t1.topic_id, t2.topic_title FROM exp_topics_users_link t1 LEFT JOIN exp_topics t2 ON t2.topic_id=t1.topic_id WHERE t1.uid=1 ORDER BY uid ASC 30: SELECT COUNT(*) FROM exp_stories WHERE published=0 31: SELECT M.mid, M.name, M.dirname FROM exp_modules M, exp_groups_modules_link L WHERE M.hasmain=1 AND M.isactive=1 AND M.weight>0 AND M.mid = L.mid AND L.groupid IN(1,2) GROUP BY M.dirname ORDER BY M.weight ASC 32: SELECT version FROM exp_modules WHERE mid='2' 33: SELECT configuration_key, configuration_value FROM exp_exv2_configuration WHERE configuration_key='news_update_ok' OR configuration_key='news_usersubmit' OR configuration_key='news_anonsubmit' 34: SELECT t1.topic_id, t2.topic_title FROM exp_topics_users_link t1 LEFT JOIN exp_topics t2 ON t2.topic_id=t1.topic_id WHERE t1.uid=1 ORDER BY uid ASC 35: SELECT version FROM exp_modules WHERE mid='3'
36: SELECT u.uid, u.uname, u.email, u.user_viewemail, g.name AS groupname FROM exp_groups_users_link l LEFT JOIN exp_users u ON l.uid=u.uid LEFT JOIN exp_groups g ON l.groupid=g.groupid WHERE g.type='Admin' ORDER BY l.groupid 37: SELECT COUNT(*) FROM exp_lastseen WHERE uid=1 AND online=1
38: SELECT b.* FROM exp_newblocks b LEFT JOIN exp_groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=1 OR l.groupid=2) AND b.isactive=1 AND (side=3 OR side=4 OR side=5) AND b.visible=1 AND (b.show_mid=2 OR b.show_mid=0) AND (3 & b.page_style) ORDER BY b.weight, b.bid 39: SELECT storyid, title, published, counter FROM exp_stories WHERE published<1152397110 AND published>0 ORDER BY published DESC LIMIT 0,5
40: SELECT storyid, title, published, counter FROM exp_stories WHERE published<1152397110 AND published>0 ORDER BY counter DESC LIMIT 0,5
41: SELECT options FROM exp_newblocks WHERE mid = 14
42: DELETE FROM exp_lastseen WHERE (uid=0 AND time<1152396810) OR (time<1152397110) 43: UPDATE exp_lastseen SET online=0 WHERE time<1152396810 44: SELECT COUNT(*) FROM exp_lastseen WHERE uid=1
45: INSERT INTO exp_lastseen SET uid=1, username='admin', time='1152397110', ip='85.246.151.107', online=1 46: SELECT * FROM exp_stories WHERE published > 0 AND published <= 1152397110 AND ihome=0 ORDER BY published DESC LIMIT 0,5 47: SELECT * FROM exp_topics WHERE topic_id=1 48: SELECT COUNT(*) FROM exp_stories WHERE published > 0 AND published <= 1152397110 AND ihome=0 49: SELECT uname FROM exp_users WHERE uid = 1 50: SELECT code, smile_url, emotion FROM exp_smiles 51: SELECT COUNT(*) FROM exp_groups_modules_link WHERE type='A' AND (groupid=1 OR groupid=2) 52: SELECT COUNT(*) FROM exp_groups_modules_link WHERE type='A' AND (groupid=1 OR groupid=2) 53: SELECT COUNT(*) FROM exp_comments WHERE item_id=1 54: SELECT COUNT(*) FROM exp_groups_modules_link WHERE type='A' AND mid=2 AND (groupid=1 OR groupid=2)
55: SELECT b.* FROM exp_newblocks b LEFT JOIN exp_groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=1 OR l.groupid=2) AND b.isactive=1 AND (side=7 OR side=8 OR side=9) AND b.visible=1 AND (b.show_mid=2 OR b.show_mid=0) AND (3 & b.page_style) ORDER BY b.weight, b.bid
56: SELECT b.* FROM exp_newblocks b LEFT JOIN exp_groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=1 OR l.groupid=2) AND b.isactive=1 AND side=1 AND b.visible=1 AND (b.show_mid=2 OR b.show_mid=0) AND (3 & b.page_style) ORDER BY b.weight, b.bid hilft das weiter ?
viele grüße, cmsxoo
[ Geändert von cmsxoo an 09.07.2006 10:04 ] |
| | »09.07.2006 00:29 | Homepage |
|
| cmsxoo | Re: fehlermeldung - banners - adminmenü |  Anfänger
Mitglied seit:08.07.2006 Beiträge:6 Aus:
Level: 1
 | | | hi nobse,
danke für deine antwort.
Zitat:bitte mal die db abfragen im sysadmin einschalten.
ist damit "error_reporting einschalten ?" gemeint ? (aktiviert habe, aber keine andere meldungen bekomme) las schon ein paarmal etwas von wegen abfrage einschalten aber nicht, was genau damit gemeint war.
den fehler provozieren kann ich nicht, er ist einfach da, kurz nach der installation (schon 2,3x installiert), auf der hauptseite zu sehen.
Zitat:Fehlernummer: 8 [Notiz] Fehlermitteilung: Undefined offset: 1 in Datei: /home/ordner/include/functions.php in Zeile: 1116
zugehörige stelle ist die :
Zitat: function anzAlter($xdatum){ $check_jahr = substr($xdatum,6); $check_mon = substr($xdatum,3,2); $check_tag = substr($xdatum,0,2); $akt_mon = date("m"); $akt_tag = date("d"); $akt_jahr = date("Y"); if ( $akt_mon.$akt_tag < $check_mon.$check_tag ){ $alter = $akt_jahr - $check_jahr -1; }else{ $alter = $akt_jahr - $check_jahr; } return $alter; } function varAnzeige($anz, $stop=1){ foreach ( $anz as $k => $v ) { echo $k." = ".$v." "; } if ($stop == 1){ die(); } }
Zitat:Fehlernummer: 2 [Warnung] Fehlermitteilung: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in Datei: /home/ordner/class/database/mysql.php in Zeile: 155
zugehörige stelle ist die :
Zitat://------------------------------------------------------------------------------------------// function fetch_row($resource) { $result = mysql_fetch_row($resource); return $result; } //------------------------------------------------------------------------------------------//
Zitat:Fehlernummer: 2 [Warnung] Fehlermitteilung: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in Datei: /home/ordner/class/database/mysql.php in Zeile: 155
(die letzte meldung taucht 2x auf)
mod_rewrite und andere vorraussetzungen sind ok, extra nochmal nachgesehen.
mehr also im moment nicht sagen kann. kannst du noch einen genaueren hinweis zu den db-abfragen geben, wo was einstellen ? (habe phpmyadmin)
viele grüße, cmsxoo
ps: braucht man die tabelle banner_clients nicht (mehr) ?
[ Geändert von cmsxoo an 08.07.2006 20:20 ] |
| | »08.07.2006 20:17 | Homepage |
|
| Ähnliche Beiträge |  |
|
|
User onlineUser online: 5 Mitglieder befinden sich im Forum!
 | Insgesamt sind 5 Mitglieder online! [ Administrator ] [ Moderator ] 5 Anonyme User 0 Mitglieder | |
BerechtigungDu kannst nicht schreiben. Du kannst nicht ändern. Du kannst keine Umfragen erstellen. Du kannst keine Dateien anhängen.
| Du kannst nicht antworten. Du kannst nicht löschen. Du kannst nicht abstimmen.
|
|
|
|
|
|