Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi All,

    I’ve got the same problem with my blog : 59000 Post and 73000 tags and the query running access both wp_taxonomy_relationship and wp_posts and they stand in “Send Data” state.

    Running the query manually do the same (hanging for a while).

    Here is the part of the query which is VERY slow on my box :

    SELECT SQL_CALC_FOUND_ROWS wp1_posts.* FROM wp1_posts WHERE 1=1 AND ( wp1_posts.ID IN (select object_id from wp1_term_relationships where term_taxonomy_id in (754,281) GROUP BY object_id HAVING COUNT(object_id) = 2 ));

    I have done the same (replace query.php by the old one and everything going back to normal).

    Thanks for the tips by the way, it saves my a lot of time for researching the root cause.

    Regards,

    Alban

    Hi, I don’t have access to WordPress SVN to create a patch for this bug neither a account to log on WordPress Trac. Anyway if someone want to create the bug in the Trac database, here is the patch for images :

    wp-admin/includes/upload.php : ligne 229

    $file = $file[‘file’];
    $filename = basename($file);

    > if ( !trim($post_title) )
    > $post_title = $filename;

    // Construct the attachment array
    $attachment = array(

Viewing 2 replies - 1 through 2 (of 2 total)