How to fix the Drupal n/a error and deleting users error

You first need to open phpMyAdmin and select your Drupal database.
Once you have selected your database you need to go in and select the SQL command button and enter the following command:
SELECT node.* FROM node
LEFT JOIN users ON node.uid=users.uid
WHERE users.uid IS NULL;
This command tells your database to delete all the nodes where the user information is null, or nothing. This occurs when Drupal deletes the user account from the database. Here is a screenshot of the command. Hit GO after you cut and paste it.
It may take a couple of minutes for this command to work, so don’t panic. The more nodes you have in your Drupal databse the longer it’s going to take. When it comes back you’ll see the following. You want to select all the results and hit the red X for delete.
OK, you’re finished. When everything goes according to plan you’ll see the following.

Content Creation

How are you going to fill out all of that empty space on your website?
How are you going to make it effective and to choose the words which will help your SEO?
What seems like such a complicated task is nothing more than creating a complex business brochure. The advantage of a website is that you are not limited to the ‘tri-fold’ brochure method. You now have the ability to expand on every topic in greater detail.
We will show you how to take your simple business brochure and expand it into a complex website presence.

Categories SEO

Landing Page Optimization

Landing Page optimization is a unique science. Many companies will create hundreds of landing pages which are essentially duplications of one page of your website that are customized to focus on different keywords. This will get you penalized and you can lose your rankings as fast as you earned them. Be careful. Have a professional … Read more

Categories SEO

Bring your website to LIFE!

Video Spokesperson,
Virtual Spokesperson
Website Spokesperson
Web Spokesperson
Spokesmodel
Walk On Actor
Talking Heads
Virtual Actor
Person on Website
Online Spokesperson
What do these all mean?
A Video Spokesperson gives your website the added edge of modern techniques that catch your site visitors’ ears and eyes. This gives a more personalized approach to bringing information to your potential clients.
Many sites like http://www.websitetalkingheads.com/ provide amazing tools to implement such objects and services into your website. We will bring you the options of these providers and integrate them into your design so that they maximize the SEO potential of your website/

Categories SEO

Affiliate Marketing

Affiliate marketing is a marketing practice in which a business rewards one or more affiliates for each visitor or customer brought about by the affiliate’s marketing efforts. Examples include rewards sites, where users are rewarded with cash or gifts, for the completion of an offer, and the referral of others to the site. The industry … Read more

Reputation Management

Your firm may need Reputation Management. What are others saying about you and your business? Are there negative things that are being posted about you on the Internet?
Maybe one of your employees is using Facebook to cause a negative impact on your reputation.
We will help you to discover how to optimize your online presence so that your name is associated with the best scenarios.

X