I have two posts in my wp_posts table where post_type='attachment' The picture below shows the records related to those in wp_postmeta table

enter image description here

I need to change the IDs of those files. What I am doing is:

update wp_posts 
set ID = ID + 10000 
where ID in (3143,3144); 

update wp_postmeta set post_id = post_id + 10000,
                       meta_id = meta_id + 100000
where post_id in (3143,3144); 

When I do that, I am losing the images! I don't see it under "Media" section in wp-admin. In the webpage, they are not shown either. If I go: /wp-admin/upload.php?item=13143, it also does not come up. Only when I go to the link in the "guid" field of the related record at wp_posts, I see the image.

What am I missing? What am I doing wrong?

Any advice would be appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.