alkpone
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: tag pages slow after 3.1.1 upgradeHi 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
Forum: Fixing WordPress
In reply to: Attachment ‘link to page’ not linking to attachment pageHi, 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(