Blog — Page 16 — The Web Files

WP_Posts database crashed – HELP!

February 28, 2009 by Tricia

If you see this post a few times it’s because I really need help and I’m posting it on three of my blogs – sorry for the repeat, but if you can help, please do!

I need some help fixing my husbands blog – Guitar Licks. Today when he visited the site (while I was still sleeping) the blog had error messages stating that the WP_posts database had crashed.

When you visit his site it loads with the WP theme and sidebars, but there’s error messages at the top and a “post cannot be found” message where current posts should be listed on the index page.

Some of the errors state:

ALTER TABLE wp_posts ADD FULLTEXT `yarpp_title` ( `post_title`)

ALTER TABLE wp_posts ADD FULLTEXT `yarpp_content` ( `post_content`)

So I’m assuming this error has something to do with the Yet another related post plugin that I’m using on most of my blogs. This blog is using the plugin version 2.16 and is using WP 2.62.

In the Yet another related posts plugin admin area there was a message that said:

YARPP’s “consider titles” and “consider bodies” relatedness criteria require your wp_posts table to use the MyISAM storage engine, but the table seems to be using the engine. These two options have been disabled.
To restore these features, please update your wp_posts table by executing the following SQL directive: ALTER TABLE `wp_posts` ENGINE = MyISAM; . No data will be erased by altering the table’s engine, although there are performance implications.
If, despite this check, you are sure that wp_posts is using the MyISAM engine, press this magic button:

I clicked on the “magic button” as the plugin seems to be working just fine in all of my other blogs and I ended up with even more errors!

Help!

I’ve looked at the WP database for this blog and the WP_posts table says “in use” and I can’t browse it. I also can’t use the backup plugin in Guitar licks – it’s there and functioning but just hung when I tried to do a back up.

I’ve backed up the whole database using PHPmyAdmin so I have a copy in case something goes terribly wrong. Now I just need to know how to fix it.

Should I just place a check mark on WP_posts and then click the repair function at the bottom of the structure screen in PHPmyAdmin and see if that repairs the problem?

I’m nervous about attempting to fix this as I’ve never had to try to repair a database error before. Any help would be appreciated.

PLRpro opens it’s doors today – exciting site creation software

December 10, 2008 by Tricia

The doors to PLRpro are opening again today at 9:00 a.m.. If you’ve been waiting for your chance to join this fantastic PLR content site here’s your chance!

Note: that time above was wrong. It was supposed to be 9:00 pm PST but I think it will be more like 11 PM. Sorry.

I decided to check out PLRPro a few months ago when the doors to this membership site last opened, and I must say that I’m impressed with the content, the resources and the level of service.

I’m impressed, not just because of the quality they bring to the table in regards to PLR Content, but also because of the additional education and material that they provide for free. In fact, something you’ll probably want to checkout before you join PLRPro is their http://www.ninetydaychallenge.net site which takes a user from start to finish, and they offer that for free.

When I first joined PLRpro there were offering the following:

440 articles across 11 niches (40 articles in each niche)
Full keyword research in each niche
Affiliate lists for each niche
Header Graphics for each niche
5 Website Templates each month
Articles done in 8 languages
50 PR4 sites that you can get links from to get your sites indexed and crawled

In addition to the above I also joined because they were creating a new system, Project Green Button, which would make it easy to create HTML and eventually WordPress Websites within minutes.

“Imagine A “Push Button” System That Automates 95% Of Site Creation, Content Creation and Traffic Generation… Now Open Your Eyes, That “Push Button” System Is Here…”

I’ve had a chance to use the Project Green Button or PGB software and I’m impressed. Right now this software is in Phase One and with PGB you’ll be able to

Site Creation – Automatically building HTML sites that are fully structured and ready to go with perfect onpage optimization in just 3 minutes (you can do it in under 60 seconds but you have to type fast…) that requires zero technical knowledge.
Content Management – 440 articles each month across 11 niches
Site Templates – 25 beautiful templates as the initial “bank of templates” from which you can draw upon to build your niche sites
Adsense Monetization – Stage one of PGB introduces the core monetization method behind building an income online… Adsense. Stage two will add additional monetization such as Kontera, Clickbank, eBay and Amazon.
Full Silo Keyword Search – Each and every niche has all of this already done for you so you don’t need to go search for the next greatest keyword…just look for, and find an ideal keyword for maximum traffic and speed. The keyword research for each niche is done in an easily laid out Excel sheet that you can quickly glance at and find perfectly targeted long tail keywords to start generating traffic in as little as 5 days.
10,000 strong blog network – This networks makes it easy to get one way backlinks via PLRpro’s Article Marketing Automation system. As a Member of PLRpro you’ll get access to this system completely free of charge.
RSS Feed Submission module
Social bookmarking poster module
PGB desktop command center. You simply install the PGB software on you computer and from there you can access the site building software and traffic related modules.
$0-6000 a month training plan – If you follow the system that the guys at PLRpro have put together you should be able to make between $2000 and $6000 every month.

There are many additional features that are available right now too many to tell you about in this article! Product reviews, the ability to drag and drop YouTube videos into your articles, aided rewriting of your articles to make them unique, weekly live training and more! Plus Project Green Button isn’t finished! There will be a second and third phase which will add even more modules that will assist in the building of site and generating traffic.

They could easily charge double or triple what they are charging for membership.

I’ve used the system to create a few sites and it works. I’m pleased with the sites I’ve created, I’m pleased with the quality of the PLR content and I’m excited about Project Green Button.

Now, as I said at the beginning of this article PLRpro is opening it’s doors this morning and it will likely only be for a short time as there are only 262 spots to fill. That’s it. When those 262 memberships are taken the doors will be closed again and likely won’t open again until sometime in 2009.

So if all that I’ve written above sounds like it might be something you’re interested in please go and check out the PLRpro website today.

Search Engine Strategy Basics

November 15, 2008 by Tricia

How much you succeed can be directly tied to how much SEO work you do, good internet marketers know that SEO is very important.

Using SEO techniques you can ensure that your website comes up at the top of searches and you get a ton of new traffic to your site. The process of SEO involves choosing the best keywords for your website content.

In this article we’ll show you several key ways that you can optimize your site for search engine spiders.

Know all your keywords and make sure you use them not only in titles but in content too. Doing this will make sure that your niche specific keywords will come up high in the search engines when people are using them in searches. Having your site show up in search results will get you way more traffic.
When designing and building your website, make sure that your keywords are in your web page headings and sub-headings.
Have high quality, unique and fresh content on your website. Duplicate content can result in your website being penalized by search engines. Having fresh content means that your website will get indexed by search engines and more people will visit your website because you have useful content on your website.
Submit your site to lots of web directories. This will help your site get found more easily by search engines.
Make links with other sites that are similar. In and Outbound links can greatly improve the popularity of your website. To get lotsof inbound links, try article and forum marketing, simple tricks that can drive lots of traffic. Link exchanges with other similar sites will help.
Get a blog and use your keywords daily to post about things in your niche. This increases the authority and ranking of your blog so that you can rank better and get more visitors to your site.

These steps can help to increase your website ranking on major search engines, Follow them, use your keywords in everything you do and you’ll see more traffic directed to your websites.

WP_Posts database crashed – HELP!

Search Engine Strategy Basics

Meta

Archives

Blogroll

Other Sites

Search our Site

Pages