wp_capabilities error in server
-
Hi! My hosting company has called me because we are using all the server capacity. I dont understand the error and why it could be produced:
Sometimes there are these consultations:13921 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 1017 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13922 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 1013 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13924 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 1003 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13925 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 965 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13927 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 938 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13930 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 921 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13931 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 902 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13932 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 894 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13934 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 872 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13936 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 846 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13937 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 846 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13939 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 816 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =
13942 wp-c7063c13ead72 localhost wp_c7063c13ead72e2b Query 803 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_use
rs.ID =and this is the petition:
SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id
INNER JOIN wp_usermeta AS mt1 ON (wp_users.ID = mt1.user_id)
INNER JOIN wp_usermeta AS mt2 ON (wp_users.ID = mt2.user_id)
INNER JOIN wp_usermeta AS mt3 ON (wp_users.ID = mt3.user_id)
INNER JOIN wp_usermeta AS mt4 ON (wp_users.ID = mt4.user_id) WHERE 1=1 AND (wp_usermeta.meta_key = ‘wp_capabilities’
OR (mt1.meta_key = ‘wp_capabilities’ AND CAST(mt1.meta_value AS CHAR) LIKE ‘%administrator%’)
OR (mt2.meta_key = ‘wp_capabilities’ AND CAST(mt2.meta_value AS CHAR) LIKE ‘%editor%’)
OR (mt3.meta_key = ‘wp_capabilities’ AND CAST(mt3.meta_value AS CHAR) LIKE ‘%author%’)
OR (mt4.meta_key = ‘wp_capabilities’ AND CAST(mt4.meta_value AS CHAR) LIKE ‘%contributor%’) ) ORDER BY user_login ASC;
- The topic ‘wp_capabilities error in server’ is closed to new replies.