[davidslessmaccom]

Hi,

Looking at our error log, we get a recurrent error generated by bbpress which has led to 502 errors. We are using WordPress 3.9 and bbpress Version 2.5.4. would you please advise us on this:

Thank you. http://communication.org.au

The error log looks like this:
[Sun Jul 06 00:49:32 2014] [error] [client 124.191.29.124] LONG QUERY (1540 characters long generated in /nas/wp/www/cluster-1417/davidsless/wp-content/plugins/bbpress/includes/users/functions.php:1531):

SELECT 
COUNT(NULLIF(meta_value LIKE '%"administrator"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"editor"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"author"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"contributor"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"subscriber"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"bbp\\_keymaster"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"bbp\\_spectator"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"bbp\\_blocked"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"bbp\\_moderator"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"bbp\\_participant"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"shop\\_accountant"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"shop\\_worker"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"shop\\_vendor"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"customer"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"shop\\_manager"%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level1″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level2″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level3″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level4″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level5″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level6″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level7″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level8″%', false)), 
COUNT(NULLIF(meta_value LIKE '%"s2member\\_level9″%', false)), 
COUNT(*) 
FROM wp_usermeta 
WHERE meta_key = "wp_capabilities", referer:

Communication Research Institute

[Stephen Edgar]

This is just a warning notice, not so much a functional error, due to the amount of roles you have which is combined by WordPress, bbPress, Shop and S2 Member the query is over 1540 charatacters in length (1547 to be exact)

You should contact your webhost for the best advice guidance on what MySQL settings they have configured for your hosting setup, they may have an option to increase this number for you.

(Apologies, your topic was originally caught by Akismet as spam)