• 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.