missmarymac
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsOr, you can First try this simple, possible solution that EssaySnark gave me in the last reply:
http://halfelf.org/2014/not-the-bug-i-expected/
I will keep this on file for future reference.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsEssaySnark:
You did give me a lot of things to try and that helped me home in on the source of the problem which I believe was somewhere in the database.
Thank you.
For anyone else who experiences this problem, here is a recap of everything I did and what finally worked:
This is for beginners with a small, simple site like mine.
WordPress Dashboard:
1. Check Settings: Discussion to make sure you are set up to receive comments.2. Check that posts are set to enable comments: Posts: Bulk Actions: Check All: Edit: Comments: Allow Comments, Save.
No success? Next:
Now is a good time to create a backup (I did mine on WPOnline Backup plugin, which I suspect may have been part of the problem, I later backedup through DreamHost which also created database backup, Dreamhost also keeps several days database backups so you can restore from that if needed).
Now is a good time to also export a copy of your posts and save on you computer or cloud service.
Now, with everything backedup:
WordPress Dashboard:
1. Plugins: Deactivate all plugins. If this solves the problem, you can reactivate them one by one until you identify the one that needs to go!
2. Updates: Reinstall WordPress. Check for success, if not:
3. Appearence: Themes: activate a new theme. Don’t worry, everything will be all over, but when you switch back everything will be back in its proper place.
These were the basic troubleshooting tips. You investigated if the problem was with settings, plugins, WordPress, theme.
Now you need to work on your site from the back end through FTP.
Here is a good source of information on using FTP:
http://www.wpbeginner.com/wp-tutorials/how-to-fix-are-you-sure-you-want-to-do-this-error-in-wordpress/I used Cyberduck, which is for Macs.
Cyberduck FTP:
You will see three files, one has your website name. Open it. Now you see all the files that make up your site from behind the curtain. Don’t be afraid, you have a backup and can always go back to your broken site.
1.Deactivate the plugins folder by renaming it ‘plugins.deactivated’ confirm by looking at your WordPress dashboard: plugins that the plugins are deactivated. Check site to see if problem solved.
2. Remove the folder for your theme, allowing the default theme to operate. Check site again to see if problem solved.
3. WordPress.org: download a copy of WordPress. Remove everything except the contents folder from your FTP files and upload a fresh copy of WordPress. Add the wp-config.php file from your backup and edit according to the instructions found here:
http://www.wpbeginner.com/wp-tutorials/how-to-fix-are-you-sure-you-want-to-do-this-error-in-wordpress/Still not working?
Next turn your attention to the database. At DreamHost, you have an option to repair and optimize your database. Try that. By now your head hurts.
If that does not work, last big BLOW-OUT:
Here’s what finally worked for me:
1. Put your database up in one window.
2. Put your backup up in another window.
3. Put WordPress download up in another window.
4. Put FTP connection up in another window.Now:
1. Delete all the tables (not the database) in the database.
2. Delete all the files from your site folder through your FTP connection.
3. Upload to your FTP file all the files from your WordPress download.
4. Copy to your FTP file the wp-config.php from your backup.This takes you back to hello. All content, media, plugins are gone. But you will be able to restore them. There will be a ‘Hello’ post on your site. See if you can leave a comment. I could.
Next, I generated new keys for the wp-config.php using this:
http://wordpress.org/search/secret+key+service
and used the new keys to replace the ones in the file.You’ve been through the worst and can always go back to your backup.
Then, I redid my header, widgets info, and I imported my posts. I had to re-import the media that went with my posts. I installed the Askismet plugin to help with spam. But this was just because I was afraid to mess things up. If I had to do this again, I would have uploaded the contents folder from the backup via FTP and if the problem re-occurred, I could just go back to square one if it did.
This is a beginners solution. If anyone has a more elegant way around this, please let me know for future reference.
And again, thank you to your help. I took a long time for me to get over that this was not as simple a some box I didn’t check. I was new to WordPress and had not customized anything and I only had one plugin. What could go wrong? After all this, I’m not afraid of the thing at all anymore. Delete your problems away and install new ones!
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsIf you read the post above my last one, starting with “I don’t know if this will help anyone.” You’ll see that I solved the problem and how I did it. This is possibly not a solution for everyone, but since I only have 10 posts and a simple non-customized site, I decided to try it (I did have backups of the site, the database, and had exported my posts for protection, so I could take it back to it’s original, albeit broken, state if need be).
It is possible that I could re-import my posts now and have everything work, but I would rather just rebuild my posts.
I am guessing the problem was with the database, so it may be a DreamHost problem. DreamHost, however, has been most unhelpful. As you may remember I had done as you suggested with getting rid of plugins and doing a clean install of WordPress via FTP. I also did many other things to try to fix it. Everything I did is listed in this thread.
essaysnark, I thank you for your help. I have learned a lot.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsSheheb,
You’ll have to begin at the beginning. And hopefully your problem will be less intractable. I was a beginner too and it’s been a long two months of learning.
1. Dashboard: Posts: Check All: Edit: Enable Comments, Save.
2. Make sure Dashboard: Settings: Discussion, are set the way you want them.
If this does not resolve:
3. Access your DreamHost account and create a back-up. Download a copy to your computer if you can.(account backup is in the left side bar on the home page)
4. Deactivate any plugins you have. Does this solve it? If it does, reactivate plugins one by one to find the problem.
5. Dashboard: Updates: WordPress Updates: Reinstall now (will reinstall WordPress.
Still not working?
1. Go to your DreamHost webpanel: Web Administration: click on phpMyAdmin: click on your database: this will take you to your database tables: on the bottom it will say check all: ‘check all’ and ‘with selected’ pull down use ‘repair table’.Be patient, you will slowly learn a lot about how your site is put together. If these steps do not help, then write back. Good Luck!
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsI don’t know if this will help anyone.
I was desperate, after a month+ of working on this and facing the possibility of spending money I don’t have.
So, with all my new-found knowledge from reading hundreds of forums, help sites, tips…..I had only ten posts and a few drafts, so this might not work well for others, but I’d rather do this than another month of fruitless installing, and editing, and optimizing, and….
I nuked it.
1. I logged onto my DreamHost database, I did not delete the database, but I deleted all the tables.
2. Via FTP (Cyberduck), I removed all the files. I uploaded a fresh copy of WordPress (content folder and all) and copied my wp-config.php from my DreamHost back-up (which I had downloaded to my computer).
This took me back to the beginning— “Hello”. I re-customized my theme (header, menu, widgets) and created a new post.
I also activated Akismet (plug-in).
Comments are working fine now. I will slowly rebuild the site, backing it up through DreamHost each step of the way.
And maintain a positive outlook and thank the WordPress and DreamHost spirits.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsTo add more information:
I received an email to moderate a comment today. I have been getting one of these every few days.
As usual there is no comment in the dashboard nor is there a record in either of the comment tables in the database.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsNevermind,
I went ahead and reduced the tables down to the 11
listed here:http://codex.wordpress.org/Database_Description
no change.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsI think posts may exist in the database also, so that may be where they are coming from.
I looked at my database and compared it to the one on:
http://codex.wordpress.org/Database_DescriptionMy database appears to have extra copies of these files as well as some tables by the online backup plugin, although I can’t be sure if it is from the plugin or part of DreamHost’s backup.
wp_comments
wp_wgmi2w_commentmeta__20140303_034154
wp_wgmi2w_comments__20140303_034154
wp_wgmi2w_links
wp_wgmi2w_links__20140303_034154
wp_wgmi2w_options
wp_wgmi2w_options__20140303_034154
wp_wgmi2w_postmeta
wp_wgmi2w_postmeta__20140303_034154
wp_wgmi2w_posts
wp_wgmi2w_posts__20140303_034154
wp_wgmi2w_terms
wp_wgmi2w_terms__20140303_034154
wp_wgmi2w_term_relationships
wp_wgmi2w_term_relationships__20140303_034154
wp_wgmi2w_term_taxonomy
wp_wgmi2w_term_taxonomy__20140303_034154
wp_wgmi2w_usermeta
wp_wgmi2w_usermeta__20140303_034154
wp_wgmi2w_users
wp_wgmi2w_users__20140303_034154
wp_wgmi2w_wponlinebackup_activity_log__20140303_034154
wp_wgmi2w_wponlinebackup_event_log__20140303_034154
wp_wgmi2w_wponlinebackup_generations__20140303_034154
wp_wgmi2w_wponlinebackup_items__20140303_034154
wp_wgmi2w_wponlinebackup_local__20140303_034154
wp_wgmi2w_wponlinebackup_scan_log__20140303_034154
wp_wgmi2w_wponlinebackup_status__20140303_034154Any ideas?
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsThese are great ideas and they should work. Right?
So here’s what I did:1. Via DreamHost webFTP: I removed all the plugins, even the ones I never activated.
No change.
2. I created a safety backup through DreamHost and downloaded a copy to my computer. Yes, the previous backups were all created using Online Backup for WordPress plugin.
3. I exported all my posts.
4. I downloaded an even fresher copy of WP 3.8.1
5. Via Cyberduck FTP, I removed everything, contents folder, everything, and reloaded wordpress.
6. I coped the wp-config.php from the DreamHost backup.And
All my posts were still there but with all the photos (media) missing. And I couldn’t restore from the exported posts because ‘posts already exist’
I uploaded the contents folder from the DreamHost backup just to keep everything up while I try to sort this out.
Where is this content coming from? I would guess that is part of the problem. Technically, if I wipe everything clean, I should be able to solve the problem.
I also looked at halfelf, it seems she works and sometimes helps with support questions in the forums. She recommends some professionals, if it comes to that. Which it shouldn’t for an itty-bitty little blog.
If you have any more ideas, please! I appreciate your time and interest and your last suggestions, although they haven’t worked yet, may reveal what the true issue is.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsJust because this is so much more fun than working on posts:
FTP connection via AjaXplorer (Dreamhost FTP connection):
I downloaded another, fresher copy of WP.
Replaced everything but the contents
and generated new keys & salts for the config filerepaired and optimized database.
no change.
maybe I need a shaman.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsI contacted dreamhost and this is what they said:
Hello,
I sincerely apologize for the delayed response. We have a large amount of
incoming support and it’s taking longer than usual to get through it all.
But it sounds like you’ve already taken the basic troubleshooting steps
to correct this. Since those have not solved the issue the problem is
most likely with the database itself. It’s possible the posts table for
example may not be set to auto-increment. That’s just a guess. I’m afraid
this goes a little outside the scope of our support. We recommend you
contact the WordPress forums here for more insight.If there is anything on our end regarding the server or logs you’d like
us to check please let us know.Chris J.
I did what they suggested. Did not help.
Here is a complete recap of what I have done including the database work:
Everything worked perfectly until mid-January: I would receive several comments (dashboard > Comments) each day (mostly spam) and I could approve, edit, delete, or mark as spam.Original problem:
Now there are two problems:
1. Only one comment can appear for moderation at a time, additional comments, even for different posts, never appear for moderation or anywhere.2. I cannot approve, edit, delete, or mark as spam. When I try to edit, I get “Oops, no comment with this ID. Go back” when there is clearly a comment. If I try to approve, delete, or mark as spam, I get “are you sure you want to do this? Please try again,” which simply loops me back to the comments dashboard.
The only thing I can do is remove comments using WP-DBManager.
Here is what I have tried so far:
Through the dashboard:
1. I deactivated all plug-ins (had installed only Online Backup for WordPress & WP-DBManager)
2. I reinstalled WordPress
3. I changed my theme.Through Cyberduck FTP:
1.I deactivated the plugins folder and confirmed that the plugins were deactivated.
2. I removed the theme allowing the default theme to operate.
3. I removed everything but the contents folder and uploaded a fresh copy of WordPress and edited the wp-config.php file according to the instructions found here:
http://www.wpbeginner.com/wp-tutorials/how-to-fix-are-you-sure-you-want-to-do-this-error-in-wordpress/
4. Via FTP I installed a back-up I created on 12/15/13 — before the problem began (and strangely two posts created after the back-up still appeared, with just the photo missing)
Leaving the contents folder from the back-up on 12/15/13, I again reinstalled wordpressAfter these steps > New version of problem:
Now, not even one comment appears in dashboard > comments. However, one comment at a time will appear in the database tables.
Here is what I tried at this point:
I repeated all of the steps taken for the original problem above.
Dreamhost > MySQL Databases> I checked, repaired, optimized and confirmed that auto_increment was set for the appropriate tables.
I used the WordPress secret key generator to replace the keys I removed from wp-config.php according to the instructions found here: http://www.wpbeginner.com/wp-tutorials/how-to-fix-are-you-sure-you-want-to-do-this-error-in-wordpress/Anomaly:
I installed the back-up I created on 12/15 via FTP before the problem began. There were two posts created after this back-up. To me, they should not be there, but they appeared so something is being stored/backed up elsewhere.And that’s where I am.
my site is lostonearth.infoThanks essaysnark for you time and interest
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsNo, I have not solved the problem.
It appears that I will have to hire professional help which sort of defeats the purpose of using wordpress for a small blog.This is the link to wordpress beginner:
http://www.wpbeginner.com/wp-tutorials/how-to-fix-are-you-sure-you-want-to-do-this-error-in-wordpress/They list all the basic steps to take to try to solve the problem. I have already tried these as you see above, but they may work for you. I any event you need to try these solutions before you can move on.
Please let me know if you find a solution.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsAs you know from my previous post, I have tried all the steps you mention. But just for fun, I tried them all again.
Did not solve anything.
So for even more fun, I replaced everything with the back-up I created on 12/15/13 way before the problem began.
Did not solve anything.
Everything has now been deactivated, themes switched, fresh downloads of everything via FTP. Where could this problem be?
To recap: People will submit comments, they appear to go through and I receive emails asking me to moderate these comments. However only one comment appears in the dashboard. If I try to delete it or mark as spam, I get “are you sure you want to do this? Please try again.”
If I try to edit the comment I get: “Oops, no comment with this ID” when there is clearly a comment.
If I try to quick edit a comment I get: “Warning: get_object_vars() expects parameter 1 to be object, null given in /home/mrstrauss/lostonearth.info/wp-includes/comment.php on line 171 -1 “
If I try to unapprove I get: “Comment 0 does not exist”
The only thing I can do is delete from the table using WordPress-DBManager.
Something is wrong! But where!
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsStill looking for help.
In the meantime a recap of the problem and solutions I have tried:Everything worked perfectly until mid-January: I would receive several comments (dashboard > Comments) each day (mostly spam) and I would approve, edit, delete, or mark as spam.
Now there are two problems:
1. Only one comment can appear for moderation at a time, additional comments, even for different posts, never appear for moderation or anywhere.2. I cannot approve, edit, delete, or mark as spam. When I try to edit, I get “Oops, no comment with this ID. Go back” when there is clearly a comment. If I try to approve, delete, or mark as spam, I get “are you sure you want to do this? Please try again,” which simply loops me back to the comments dashboard.
The only thing I can do is remove comments using WP-DBManager.
Here is what I have tried so far:
Through the dashboard:
1. I deactivated all plug-ins (only one: Online Backup for WordPress)
2. I reinstalled WordPress
3. I changed my theme.Through Cyberduck FTP:
1.I deactivated the plugins folder and confirmed that the plugins were deactivated.
2. I removed the theme allowing the default theme to operate.
3. I removed everything but the contents folder and uploaded a fresh copy of WordPress and edited the wp-config.php file according to the instructions found here:
http://www.wpbeginner.com/wp-tutorials/how-to-fix-are-you-sure-you-want-to-do-this-error-in-wordpress/I did log on to administer the site from Thailand, Laos, and Cambodia from December 17- January 8, but I don’t see how this could cause the problem, especially now that I have replaced everything.
Now I am out of ideas. I have tried my inexperienced best to solve this problem, but now I would really appreciate some help.
Forum: Fixing WordPress
In reply to: can't mark as spam or delete commentsI have found a way to get rid of the comment using the WP-DBManager.
I still cannot delete or mark as spam from dashboard > comments.
It still asks me:
Are you sure you want to do this?
Please try again.
and loops back leaving the comment as pending.Now I have discovered two new problems: There can only be one comment held for moderation at a time, if I try to send a second comment, even about another post, is does not ever show up, even after the first comment is removed. Also, after hitting ‘post comment’ I get a warning page:
Warning: get_object_vars() expects parameter 1 to be object, null given in /home/mrstrauss/lostonearth.info/wp-includes/comment.php on line 171Warning: Cannot modify header information – headers already sent by (output started at /home/mrstrauss/lostonearth.info/wp-includes/comment.php:171) in /home/mrstrauss/lostonearth.info/wp-includes/comment.php on line 679
Warning: Cannot modify header information – headers already sent by (output started at /home/mrstrauss/lostonearth.info/wp-includes/comment.php:171) in /home/mrstrauss/lostonearth.info/wp-includes/comment.php on line 680
Warning: Cannot modify header information – headers already sent by (output started at /home/mrstrauss/lostonearth.info/wp-includes/comment.php:171) in /home/mrstrauss/lostonearth.info/wp-includes/comment.php on line 681
Warning: Cannot modify header information – headers already sent by (output started at /home/mrstrauss/lostonearth.info/wp-includes/comment.php:171) in /home/mrstrauss/lostonearth.info/wp-includes/pluggable.php on line 896.
Any help greatly appreciated. I’m very new to this, hopefully someday I’ll be able to help someone else.