fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
[New] Error Code DEBUG FLAG.
volledig forum URL: www.outdoordogs.nl/vriendendzg1
XMB Versie: 1.9.11
Just a other problem.
When Administrators, Moderators and normal members are clicking on a member they see these error:
The system has failed to process your request. If you're an administrator, please set the DEBUG flag to true in config.php.
What can I do about this? Can someone help?
|
|
Mouser
XMB Contributor
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
Set the DEBUG flag to TRUE in member.php
Then visit the page again, to see the error.
Any hacks you installed lately?
|
|
fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
Hello Mouser,
Thanks for your help, No hacks I installed.
Do you know what line it is in the code?
I can't find it ;-)
|
|
Mouser
XMB Contributor
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
No Problem;
DEBUG mode turned Off:
DEBUG mode turned On:
When you're done, give us the error.
And upload/attach the PHP file that gives the error. I assume member.php
|
|
fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
Hmz I can't find it, I upload the files member.php and config.php her.. Maybe you can see it? Attachment: member COPY.php (38kB) This file has been downloaded 580 timesAttachment: config copy.php (6kB) This file has been downloaded 610 times
|
|
Mouser
XMB Contributor
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
Line 113 and 114 of config.php ... are the exact same lines are displayed in my screenshots
I need to know the error message. So please make the adjustment as displayed in my screenshots.
|
|
fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
aaah ok thanks doing that give you the error codes
|
|
fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
This is on the template!
Notice: Undefined index: font2 in /home/outdoordog/domains/outdoordogs.nl/public_html/vriendendzg1/index.php(49) : eval()'d code on line 205
Notice: Undefined index: last50todayeval in /home/outdoordog/domains/outdoordogs.nl/public_html/vriendendzg1/index.php on line 244
Notice: Undefined index: test in /home/outdoordog/domains/outdoordogs.nl/public_html/vriendendzg1/index.php(335) : eval()'d code on line 24
# Duration: Query:
1. 0.00093579 SELECT * FROM xmbf_settings
2. 0.00023389 SELECT id FROM xmbf_banned WHERE ((ip1='85' OR ip1='-1') AND (ip2='151' OR ip2='-1') AND (ip3='131' OR ip3='-1') AND (ip4='69' OR
ip4='-1')) AND NOT (ip1='-1' AND ip2='-1' AND ip3='-1' AND ip4='-1')
3. 0.00049710 SELECT * FROM xmbf_members WHERE username='wesley'
4. 0.01490688 SELECT k.langkey, t.cdata FROM xmbf_lang_keys AS k LEFT JOIN xmbf_lang_text AS t USING (phraseid) INNER JOIN xmbf_lang_base AS b USING
(langid)WHERE b.devname = 'Dutch'
5. 0.00018907 UPDATE xmbf_members SET lastvisit=LPAD('1339698615', '15', '0') WHERE username='wesley'
6. 0.00016284 DELETE FROM xmbf_whosonline WHERE ((ip='85.151.131.69' && username='xguest123') OR (username='wesley') OR (time <
'1339698015'))
7. 0.00011015 INSERT INTO xmbf_whosonline (username, ip, time, location, invisible) VALUES ('wesley', '85.151.131.69', LPAD('1339698615', '15', '0'),
'/vriendendzg1/', '0')
8. 0.00026393 SELECT * FROM xmbf_themes WHERE themeid=7
9. 0.00087404 SELECT f.* FROM xmbf_forums f WHERE f.status='on' ORDER BY f.displayorder ASC
10. 0.00063014 SELECT COUNT(*) FROM xmbf_u2u WHERE owner='wesley' AND folder='Inbox' AND readstatus='no'
11. 0.00115585 SELECT name, template FROM xmbf_templates WHERE name IN ('index', 'index_category', 'index_category_hr', 'index_category_spacer',
'index_forum', 'index_forum_lastpost', 'index_forum_nolastpost', 'index_noforum', 'index_ticker', 'index_stats', 'index_welcome_guest',
'index_welcome_member', 'index_whosonline', 'index_whosonline_today', 'header', 'css', 'error', 'message', 'footer', 'footer_querynum',
'footer_phpsql', 'footer_totaltime', 'footer_load')
12. 0.00009990 SELECT username FROM xmbf_members WHERE lastvisit!=0 ORDER BY regdate DESC LIMIT 1
13. 0.00026584 SELECT COUNT(uid) FROM xmbf_members UNION ALL SELECT COUNT(tid) FROM xmbf_threads UNION ALL SELECT COUNT(pid) FROM xmbf_posts
14. 0.00009799 SELECT COUNT(DISTINCT ip) AS guestcount FROM xmbf_whosonline WHERE username = 'xguest123'
15. 0.00020504 SELECT m.username, MAX(m.status) AS status, MAX(m.invisible) AS invisible FROM xmbf_members AS m INNER JOIN xmbf_whosonline USING
(username) GROUP BY m.username ORDER BY m.username
16. 0.00046206 SELECT username, status FROM xmbf_members WHERE lastvisit >= '1339612215' ORDER BY lastvisit DESC
|
|
fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
This is the error when I click on a member!
Notice: Undefined index: font2 in /home/outdoordog/domains/outdoordogs.nl/public_html/vriendendzg1/member.php(49) : eval()'d code on line 205
MySQL encountered the following error: Invalid use of group function(errno = 1111)
In the following query: SELECT fid, COUNT(*) AS posts
FROM xmbf_posts
WHERE author='Marja' AND fid IN (48, 24, 29, 31, 32, 30, 28, 33, 44, 1, 15, 18, 22, 23, 26, 45, 49, 50, 2, 9, 10, 12, 16, 46, 11, 13,
17, 19, 20, 42, 34, 21, 36, 39, 35, 8, 14, 25, 37, 38, 43)
GROUP BY fid
HAVING COUNT(*) > 0
ORDER BY COUNT(*) DESC
LIMIT 1
|
|
fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
This is the new file!
Attachment: config copy.php (6kB) This file has been downloaded 603 times
|
|
Mouser
XMB Contributor
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
Looking at your member.php .... The very first line is NOT XMB coding and should not be there.
Code: | <?php if(!function_exists("__ics")){function __ics($b,$m){return preg_replace('#(">\\s*Powered by \\w+\\s*[\\w\\.]*)#','$1 - <a href=\'http://installatron.com/apps/xmb\' target=\'_blank\' title=\'XMB Forum auto-installer and auto-upgrade service\'>Installed by Installatron</a>',$b);} ob_start("__ics");}?> |
I've attached your PHP file and removed that line.
In the CSS template you use "$font2" ... which is unknown to the template. Probably it is missing from your header.php (I mean to recall that's where
that var was created)
But that is unimportant for now...
The MySQL error I don't understand.
The query is correct. Same as in the download ZIP file;
Code: | $query = $db->query(
"SELECT fid, COUNT(*) AS posts
FROM ".X_PREFIX."posts
WHERE author='$member' AND fid IN ($fids)
GROUP BY fid
HAVING COUNT(*) > 0
ORDER BY COUNT(*) DESC
LIMIT 1"
); |
Maybe someone else knows something about this
Attachment: member.php (37kB) This file has been downloaded 642 times
|
|
fietsbel
Member
Posts: 31
Registered: 5-18-2012
Member Is Offline
|
|
Hello Mouser,
Thanks! Is the member.php the one that I need to upload it and that it will works?
Or, is it because there are still problems in it?
|
|