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.

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 […]

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