newsthrottle,
Sorry to hear about this, and we appreciate the feedback.
Can you tell us what version of Jetpack you have installed?
Would you mind sending us some samples from the WP Database so we can see examples of these “ghost” posts you are referring to?
Can you also explain the functions you ran or what you did to repair the DB?
Can you also tell us what domain you have this installed on, so we can check our data on the backend?
Feel free to send this to support@grab-media.com, and if so, please reference this support thread in the email.
Hi Guys,
Can you tell us what version of Jetpack you have installed? I removed jetpack all together, but I was using the latest version of Jetpack.
Would you mind sending us some samples from the WP Database so we can see examples of these “ghost” posts you are referring to? Will do, will recreate the posts and send you the info from DB shortly.
Can you also explain the functions you ran or what you did to repair the DB? First steps, I head into my DB for WP, I then select all tables and choose “check table”. Once it identifies issues, I then reselect all tables and choose “repair tables” It will then locate a bunch of mismatched table references and correct the issue ( your questions two above, I will supply shortly the messages from SQL). Last step I do the same but choose “optimize table” and this then fixes the “ghost” posts within POSTS in WP dashboard. But the images are loaded into my media area but with no image. I have to then simply delete these via WP media. I then head into “catalog” on GP and manually post. By using the names from the image title, I can identify what GP tried to post.
Can you also tell us what domain you have this installed on, so we can check our data on the backend? newsthrottle.net
Thank you guys for all the support
PS I also have a ticket open with you guys and checked with my hosting provider (asmallorange) and they said its on your end.
Sorry, another note. I noticed after disabling some autoposts I created with “keywords” and “any of these keywords” it stopped creating the “ghost” posts. I am going to reenable some right now and this should recreate the issue and will send you info from PHPadmin/SQL.
Hi guys, OK after enabling the keyword and any keyword searches, it duplicated the errors. See below from my PHP and screen shot from my WP Posts section.
FROM PHP:
"Check table":
n3bula_wpnt14.wp_tzqzrf_commentmeta
check
status
OK
n3bula_wpnt14.wp_tzqzrf_comments
check
status
OK
n3bula_wpnt14.wp_tzqzrf_links
check
status
OK
n3bula_wpnt14.wp_tzqzrf_options
check
warning
5 clients are using or haven't closed the table pr...
n3bula_wpnt14.wp_tzqzrf_options
check
status
OK
n3bula_wpnt14.wp_tzqzrf_postmeta
check
warning
4 clients are using or haven't closed the table pr...
n3bula_wpnt14.wp_tzqzrf_postmeta
check
error
Size of indexfile is: 1638400 Should be: 16...
n3bula_wpnt14.wp_tzqzrf_postmeta
check
error
Size of datafile is: 28389376 Should be: 2...
n3bula_wpnt14.wp_tzqzrf_postmeta
check
error
Corrupt
n3bula_wpnt14.wp_tzqzrf_posts
check
warning
4 clients are using or haven't closed the table pr...
n3bula_wpnt14.wp_tzqzrf_posts
check
error
Size of datafile is: 14618624 Should be: 1...
n3bula_wpnt14.wp_tzqzrf_posts
check
error
Corrupt
n3bula_wpnt14.wp_tzqzrf_terms
check
warning
2 clients are using or haven't closed the table pr...
n3bula_wpnt14.wp_tzqzrf_terms
check
error
Size of indexfile is: 1847296 Should be: 18...
n3bula_wpnt14.wp_tzqzrf_terms
check
error
Size of datafile is: 1335296 Should be: 13...
n3bula_wpnt14.wp_tzqzrf_terms
check
error
Corrupt
n3bula_wpnt14.wp_tzqzrf_term_relationships
check
warning
4 clients are using or haven't closed the table pr...
n3bula_wpnt14.wp_tzqzrf_term_relationships
check
error
Size of indexfile is: 3760128 Should be: 37...
n3bula_wpnt14.wp_tzqzrf_term_relationships
check
error
Size of datafile is: 2117346 Should be: 21...
n3bula_wpnt14.wp_tzqzrf_term_relationships
check
error
Corrupt
n3bula_wpnt14.wp_tzqzrf_term_taxonomy
check
warning
4 clients are using or haven't closed the table pr...
n3bula_wpnt14.wp_tzqzrf_term_taxonomy
check
error
Size of indexfile is: 1015808 Should be: 10...
n3bula_wpnt14.wp_tzqzrf_term_taxonomy
check
error
Size of datafile is: 1177972 Should be: 11...
n3bula_wpnt14.wp_tzqzrf_term_taxonomy
check
error
Corrupt
n3bula_wpnt14.wp_tzqzrf_usermeta
check
status
OK
n3bula_wpnt14.wp_tzqzrf_users
check
status
OK
Step 2 "Repair Table":
Table
Op
Msg_type
Msg_text
n3bula_wpnt14.wp_tzqzrf_commentmeta
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_comments
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_links
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_options
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_postmeta
repair
info
Found block that points outside data file at 28389...
n3bula_wpnt14.wp_tzqzrf_postmeta
repair
warning
Number of rows changed from 50593 to 50553
n3bula_wpnt14.wp_tzqzrf_postmeta
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_posts
repair
info
Found block that points outside data file at 14618...
n3bula_wpnt14.wp_tzqzrf_posts
repair
warning
Number of rows changed from 21663 to 21654
n3bula_wpnt14.wp_tzqzrf_posts
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_terms
repair
info
Found block that points outside data file at 13352...
n3bula_wpnt14.wp_tzqzrf_terms
repair
warning
Number of rows changed from 29269 to 29255
n3bula_wpnt14.wp_tzqzrf_terms
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_term_relationships
repair
warning
Number of rows changed from 100840 to 100826
n3bula_wpnt14.wp_tzqzrf_term_relationships
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_term_taxonomy
repair
warning
Number of rows changed from 29429 to 29424
n3bula_wpnt14.wp_tzqzrf_term_taxonomy
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_usermeta
repair
status
OK
n3bula_wpnt14.wp_tzqzrf_users
repair
status
OK
Screen shot from WP Posts section:
Screenshot media section in WP:
hope that helps
i tried to link my screenshots but didnt work for you to see
Ghost Post screenshot:
Ghost Post ScreenShot
Some of the ones I enabled with search words worked fine, I think it might be one or two that I have scheduled that may be causing the problem. Maybe because it doesnt find any data and creates “ghost” posts?
Successful posts via autopost with search keywords:
Successful posts created
Hi guys, you can close this, I ended up moving off this hosting provider (asmallorange) they seemed to have some settings causing issues. I believe this is one of the root causes for my phantom posts. I moved back to Dreamhost and working much better. Thank you for the support.
Thanks for keeping us informed – much appreciated.