Post type disappeared

21 views
Skip to first unread message

Alin Danila

unread,
Mar 14, 2013, 6:44:43 AM3/14/13
to magic-...@googlegroups.com
Wordpress 3.5.1
Magic Fields 2.1
Hosted on mediatemple.

After a database restore trough terminal one of the magic field custom post types disappeared from the magic fields list and the admin list as well.
I checked the database, the post type show up in wp_mf_posttypes.
Managed to make them show up again by creating a custom post type php file.
But the links to the post do not work not even when i hit "view this post" from the editor.

But now some of thise posts showed up with chracaters  like " ", ' .. etc. I'm assuming the whole issue is due to some character encoding 
i changed the database to utf8_general_ci but that did not fix it.

Used this clean up queries hoping it will fix it:
UPDATE wp_posts SET post_content = REPLACE(post_content, '“', '“');
UPDATE wp_posts SET post_content = REPLACE(post_content, '†', '”');
UPDATE wp_posts SET post_content = REPLACE(post_content, '’', '’');
UPDATE wp_posts SET post_content = REPLACE(post_content, '‘', '‘');
UPDATE wp_posts SET post_content = REPLACE(post_content, '—', '–');
UPDATE wp_posts SET post_content = REPLACE(post_content, '–', '—');
UPDATE wp_posts SET post_content = REPLACE(post_content, '•', '-');
UPDATE wp_posts SET post_content = REPLACE(post_content, '…', '…');

UPDATE wp_comments SET comment_content = REPLACE(comment_content, '“', '“');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '†', '”');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '’', '’');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '‘', '‘');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '—', '–');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '–', '—');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '•', '-');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '…', '…');
this did fix the characters inside the posts. but the links still do not work.

I don't know what else to do, i'm desperate here

David Valdez

unread,
Mar 15, 2013, 2:33:23 AM3/15/13
to magic-...@googlegroups.com

Try using the development version of mf from github,  there is a bug (actually fixed in the development version) when a post type is marked as private. 

I hope helps

David

--
 
---
You received this message because you are subscribed to the Google Groups "Magic Fields" group.
To unsubscribe from this group and stop receiving emails from it, send an email to magic-fields...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply all
Reply to author
Forward
0 new messages