Support » Fixing WordPress » WordPress Sitemap, Posts & Hack issue

  • hi, first post here, please excuse me if some of my terminology is incorrect!

    Here’s what’s happened (I’m in a real pickle). Firstly, I’ve got a habit of meddling by renaming or deleting categories and tags.

    Up until around mid-July, my site was doing really well and everything was ticking along nicely. Then my stats dropped heavily and I’ve spent six weeks trying to fix this.

    I use a translation plugin (Transposh) that adds to the permalinks to denote the translated page (i.e. – – and same with post URLs). I’ve suffered from high-CPU and server resource usage for months (and have increased from a standard shared hosting to my own dedicated VPS, the highest level possible with HostGator and I still have issues).

    Very foolishly I deleted the row in my table that said xx_translations (renamed the first part for security). This caused the history of all my translations to be deleted – I restored this about 24 hours later when I realised my issue. However, my readership has dropped by around 80-90% since before the drop in stats in July.

    Some of my other changes include switching to WordPress SEO by Yoast (instead of All-In-One SEO) and implementing Jetpack by WordPress to provide a secondary set of stats.

    I’ve resubmitted numerous sitemaps to Google (using XML Sitemap Generator) but the volume of readers is still really low. In real terms, we’re talking about the fact I’ve lost the readership built up in the last 8-9 months, which is a really tough pill to swallow.

    I’ve also looked at Webmaster Tools who says Google has found around 33,000 404 errors but I’ve tried to manually fix each one using a 301 redirect in my .htaccess as well as run Broken Link Checker yet the figure still remains extremely high. (A lot of these point back months and months).

    I’ve got one option left which is to export content using WordPress exporter or using PHPMyAdmin and then hit the reset switch by deleting everything and starting over. This is quite a long task but I’d be interested to see if anyone has any thoughts on this?

    Now I’m not averse to changing domains but this would really have to be a massive last resort (due to the fact I really really like my current domain and it has worked wonders for me business-wise).

    The site URL is and with some new features and functionality we’re currently planning to roll out, I desperately need to get this fixed.

    Can anyone make any suggestions (this would be REALLY appreciated) or point me in the direction of someone (free/paid) who could help resolve this once and for all?

    Thanks in advance, it is REALLY appreciated!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator kmessinger


    kmessinger, thanks!

    Does anyone have suggestions that I can possibly do myself before hiring an external person?


    Hi nirave,

    Looks like you didn’t make backups of your wp on a regular basis, or did you? If you did, you should wipe out you site completely and restore the backup to what it was when it was still working.
    You say you lost your readership. Does this mean that most of your visitors came from organic searches? And it also suggests that your visitors were not really returning, otherwise you wouldn’t have lost so many in such a short time period.

    Also, if your google visitors have dropped so drastically, then it should mean that you’ve penalized for some reason. Otherwise if your google positions for your oroginal keywords were still there, but only the permalinks are messed up, you should be getting a lot of 404 hits. Have you checked that?

    Nevertheless, an in depth “investigation” should help as to what happenned to the keywords you were targeting. You might also have been hit by duplicate content punishment by google for having posts in multiple categories.

    If you want, I could take a look.



    I also want to know this issu.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress Sitemap, Posts & Hack issue’ is closed to new replies.