Skip to main content
6 events
when toggle format what by license comment
May 21, 2014 at 20:02 comment added rmorse just to note you will need to watch your table names when running on multisite
Feb 13, 2014 at 5:49 comment added David Just to add a little more info to rinogo's comment, this is a little safer way to update the guid: UPDATE wp_posts SET guid = REPLACE (guid, 'post_type=<old post type name>', 'post_type=<new post type name>');
Mar 1, 2013 at 20:44 comment added rinogo When I did this, I updated the guid field as well. This might help make it unnecessary to regenerate permalinks as @AndyGiesler mentioned. Just include the following in your UPDATE statement: guid=REPLACE(guid, '<old post type name>', '<new post type name>')
Mar 11, 2011 at 20:06 comment added Andy Giesler Excellent answer, exactly what I needed. Here's a tip in case others hit the same problem as I did: After I ran the query and updated my code, things were basically working but when I tried going to the page for an individual content item I got a 404 error. I think some permalink cache needed to be reset; I went to Tools > Permalinks and clicked Save, then the detailed pages started working.
Sep 1, 2010 at 4:53 vote accept Derek Perkins
Aug 30, 2010 at 17:24 history answered John P Bloch CC BY-SA 2.5