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?

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

Any hacks you installed lately?

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 ;-)

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

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

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.

aaah ok thanks doing that give you the error codes

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

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

This is the new file!



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

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

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?