XMB Forum Software

[New] Error Code DEBUG FLAG.

fietsbel - 6-11-2012 at 07:06 PM

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 - 6-11-2012 at 10:25 PM

Set the DEBUG flag to TRUE in member.php
Then visit the page again, to see the error.

Any hacks you installed lately?

fietsbel - 6-12-2012 at 01:03 PM

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 - 6-12-2012 at 04:05 PM

No Problem;

DEBUG mode turned Off:

DEBUG_Off.png - 12kB

DEBUG mode turned On:

DEBUG_On.png - 15kB

When you're done, give us the error.
And upload/attach the PHP file that gives the error. I assume member.php

fietsbel - 6-14-2012 at 12:51 PM

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 423 times

Attachment: config copy.php (6kB)
This file has been downloaded 456 times

Mouser - 6-14-2012 at 05:15 PM

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 - 6-14-2012 at 05:26 PM

aaah ok thanks doing that give you the error codes :)

fietsbel - 6-14-2012 at 06:31 PM

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='' && username='xguest123') OR (username='wesley') OR (time < '1339698015'))
7. 0.00011015 INSERT INTO xmbf_whosonline (username, ip, time, location, invisible) VALUES ('wesley', '', 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 - 6-14-2012 at 06:32 PM

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)

fietsbel - 6-14-2012 at 06:33 PM

This is the new file!

Attachment: config copy.php (6kB)
This file has been downloaded 450 times

Mouser - 6-14-2012 at 10:09 PM

Looking at your member.php .... The very first line is NOT XMB coding and should not be there.

<?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;
$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 485 times

fietsbel - 6-15-2012 at 02:48 PM

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?