By liliplanet on

Hi!

Hope you would be so kind to point me in the right direction on how to find content that came with my upgrade from D6 to D7 that is causing errors ..

I've tried for several weeks now to find the offending problem, even rebuilding a vanilla site and then importing the 30 000+ nodes and yet still have several errors on cron run:

Errors:

Search is stuck at 2% ..

Notice: Trying to get property of non-object in _node_index_node() (line 2632 of /home/public_html/modules/node/node.module).

EntityMalformedException: Missing bundle property on entity of type node. in entity_extract_ids() (line 7405 of /home/public_html/includes/common.inc).

Notice: Undefined property: stdClass::$type in _node_extract_type() (line 370 of /home/public_html/modules/node/node.module).

Results in sql and views:

All nodes are related to a nid, vid, type and uid in sql
In views no orphaned nodes when 'filter is not of content type' (so all nodes are related to a content type)

What it might be was the conversion of image fields in D6 to managed files in D7, could that be it? Yet the error claims to be a node?

Most most appreciate any help, and thank you.
Lilian

⋅ Categories: Drupal 7.x

Comments

vm’s picture

vm commented

you want to read and follow through on http://drupal.org/node/1277376

liliplanet’s picture

liliplanet commented

Thank you so much for your reply VM, and yes I have read that thread before as well

I have found by disabling modules one by one to rule out Views, Aggregator and Taxonomy.

It happens with the Search module when cron is run.

Please what does that mean Trying to get property of non-object in _node_index_node() (line 2632 of /home/public_html/modules/node/node.module).?

and how can I start tracking down what is causing the error? I don't think it's a bug in a module, it could be a bad node or something to do with the files attached to nodes that got corrupt in the upgrade.

Most appreciate any direction on how to find the troubled content :)

vm’s picture

vm commented

That error when used as a google search term target at d.o. reveals this thread http://drupal.org/node/1028230 which you may want to read through and if necessary reopen.

On a test site, I'd empty the search index table and try reindexing

imoreno’s picture

imoreno commented

i just empty 2 tables from the DB

search_dataset
search_index

and then re-indexing the site content via cron run - solved the prublem for me!

THX!

shimmertron’s picture

shimmertron commented

This one worked for me! Had tried almost everything else - thanxs for posting!

  • i just empty 2 tables from the DB

    search_dataset
    search_index

liliplanet’s picture

liliplanet commented

I think I found the way to find bad content in the database as mine was the cause of an upgrade from D6 to D7 with over 30 000 nodes.

Create a view with http://drupal.org/project/views_bulk_operations

that contains 'title' | (sort by) 'nid' | 'file usage' | (sort by) 'entity type' | 'edit'

found that when I tried to edit the node that had a nid of '0' receive 'page not found'. Great! so I know that is not a good bunny.

Copied all those that I want to delete (with '0' nid) into mysql database as 


DELETE from node where nid IN (111, 222, 333, etc )

So far all looking good, search is running at cron with no errors.

hyperglide’s picture

hyperglide commented

Hi Liliplanet -- Would you kindly export your view or put a screen shot online to take a look at. Having the same problem as I posted about here

http://drupal.org/node/1360034

Thanks!
Hg

hyperglide’s picture

hyperglide commented

Hi -- Okay I think I was able to set up the view. I did not install VBO (yet) just trying to make a table to see if I can find the problems first. Then either use VBO or do manually (ouch)

Now I have the view generating the same error I was seeing before, when I an trying to sort by "entity type"

-- So I can see I am getting closer to finding the bad 'nodes'. But am a bit stuck.

Also I have noted that some of the items in the view have no vale for "entity type" "module" and "use count".

Suggestions please?

Thanks for your previous post.

liliplanet’s picture

liliplanet commented

Hi Hyperglide,

I quick created a view for you without VBO. Any nodes with an empty nid you should delete. If you can't delete in on the system you need to go to your sql database and delete as described earlier in this thread.

Hope this helps some ..

$view = new view;
$view->name = 'check_content';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'check-content';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'check-content';
$handler->display->display_options['access']['type'] = 'role';
$handler->display->display_options['access']['role'] = array(
  6 => '6',
);
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'title' => 'title',
  'nid' => 'nid',
  'type' => 'type',
  'field_type' => 'field_type',
  'type_1' => 'type_1',
  'delete_node' => 'delete_node',
  'type_2' => 'type_2',
  'module' => 'module',
  'count' => 'count',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
  'title' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'nid' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'type' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_type' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'type_1' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'delete_node' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'type_2' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'module' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'count' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['style_options']['empty_table'] = 0;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Nid */
$handler->display->display_options['fields']['nid']['id'] = 'nid';
$handler->display->display_options['fields']['nid']['table'] = 'node';
$handler->display->display_options['fields']['nid']['field'] = 'nid';
$handler->display->display_options['fields']['nid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['nid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['nid']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['nid']['alter']['external'] = 0;
$handler->display->display_options['fields']['nid']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['nid']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['nid']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['nid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['nid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['nid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['nid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['nid']['alter']['html'] = 0;
$handler->display->display_options['fields']['nid']['element_label_colon'] = 1;
$handler->display->display_options['fields']['nid']['element_default_classes'] = 1;
$handler->display->display_options['fields']['nid']['hide_empty'] = 0;
$handler->display->display_options['fields']['nid']['empty_zero'] = 0;
$handler->display->display_options['fields']['nid']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['nid']['link_to_node'] = 0;
/* Field: Content: Type */
$handler->display->display_options['fields']['type']['id'] = 'type';
$handler->display->display_options['fields']['type']['table'] = 'node';
$handler->display->display_options['fields']['type']['field'] = 'type';
$handler->display->display_options['fields']['type']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['type']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['type']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['type']['alter']['external'] = 0;
$handler->display->display_options['fields']['type']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['type']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['type']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['type']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['type']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['type']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['type']['alter']['trim'] = 0;
$handler->display->display_options['fields']['type']['alter']['html'] = 0;
$handler->display->display_options['fields']['type']['element_label_colon'] = 1;
$handler->display->display_options['fields']['type']['element_default_classes'] = 1;
$handler->display->display_options['fields']['type']['hide_empty'] = 0;
$handler->display->display_options['fields']['type']['empty_zero'] = 0;
$handler->display->display_options['fields']['type']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['type']['link_to_node'] = 0;
$handler->display->display_options['fields']['type']['machine_name'] = 0;
/* Field: File Usage: Entity type */
$handler->display->display_options['fields']['type_1']['id'] = 'type_1';
$handler->display->display_options['fields']['type_1']['table'] = 'file_usage';
$handler->display->display_options['fields']['type_1']['field'] = 'type';
$handler->display->display_options['fields']['type_1']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['external'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['type_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['type_1']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['type_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['type_1']['element_label_colon'] = 1;
$handler->display->display_options['fields']['type_1']['element_default_classes'] = 1;
$handler->display->display_options['fields']['type_1']['hide_empty'] = 0;
$handler->display->display_options['fields']['type_1']['empty_zero'] = 0;
$handler->display->display_options['fields']['type_1']['hide_alter_empty'] = 1;
/* Field: Node: Delete link */
$handler->display->display_options['fields']['delete_node']['id'] = 'delete_node';
$handler->display->display_options['fields']['delete_node']['table'] = 'views_entity_node';
$handler->display->display_options['fields']['delete_node']['field'] = 'delete_node';
$handler->display->display_options['fields']['delete_node']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['delete_node']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['delete_node']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['trim'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['html'] = 0;
$handler->display->display_options['fields']['delete_node']['element_label_colon'] = 1;
$handler->display->display_options['fields']['delete_node']['element_default_classes'] = 1;
$handler->display->display_options['fields']['delete_node']['hide_empty'] = 0;
$handler->display->display_options['fields']['delete_node']['empty_zero'] = 0;
$handler->display->display_options['fields']['delete_node']['hide_alter_empty'] = 1;
/* Field: File Usage: Module */
$handler->display->display_options['fields']['module']['id'] = 'module';
$handler->display->display_options['fields']['module']['table'] = 'file_usage';
$handler->display->display_options['fields']['module']['field'] = 'module';
$handler->display->display_options['fields']['module']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['module']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['module']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['module']['alter']['external'] = 0;
$handler->display->display_options['fields']['module']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['module']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['module']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['module']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['module']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['module']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['module']['alter']['trim'] = 0;
$handler->display->display_options['fields']['module']['alter']['html'] = 0;
$handler->display->display_options['fields']['module']['element_label_colon'] = 1;
$handler->display->display_options['fields']['module']['element_default_classes'] = 1;
$handler->display->display_options['fields']['module']['hide_empty'] = 0;
$handler->display->display_options['fields']['module']['empty_zero'] = 0;
$handler->display->display_options['fields']['module']['hide_alter_empty'] = 1;
/* Field: File Usage: Use count */
$handler->display->display_options['fields']['count']['id'] = 'count';
$handler->display->display_options['fields']['count']['table'] = 'file_usage';
$handler->display->display_options['fields']['count']['field'] = 'count';
$handler->display->display_options['fields']['count']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['count']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['count']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['count']['alter']['external'] = 0;
$handler->display->display_options['fields']['count']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['count']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['count']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['count']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['count']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['count']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['count']['alter']['trim'] = 0;
$handler->display->display_options['fields']['count']['alter']['html'] = 0;
$handler->display->display_options['fields']['count']['element_label_colon'] = 1;
$handler->display->display_options['fields']['count']['element_default_classes'] = 1;
$handler->display->display_options['fields']['count']['hide_empty'] = 0;
$handler->display->display_options['fields']['count']['empty_zero'] = 0;
$handler->display->display_options['fields']['count']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['count']['format_plural'] = 0;
/* Sort criterion: Content: Post date */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 0;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'check-content';
videographics’s picture

videographics commented

Found 4 nodes without a node type (how did that happen?) and deleted them but now, whenever I get to a page with what must be a problematic Nid, the view craps out. Looking through the node table, everything looks fine -- every record seems to have a normal integer for a Nid entry with no "0"s. Now what? Any ideas?

standingtall’s picture

standingtall
Location Sydney
commented

Thanks for posting this view..

When I run it, almost half of my nodes show up.

They all have nodeids... please see the below shot.

http://i.imgur.com/zr2Zo.jpg

hyperglide’s picture

hyperglide commented

Subject says it all!

videographics’s picture

videographics commented

Oooooo, this is good. (I haven't even tried it yet but I've been struggling with this kind of thing for a while and it's looking very much like you've found a solution.)

What about a module that would do some consistency checks on the node data and offer options for dealing with it? ...already sounds like a good candidate for inclusion in core. ;-)

hyperglide’s picture

hyperglide commented

If need more help let me know.

nothinghere’s picture

nothinghere commented

I've exactly this error, but I'm a begginer with Drupal. Please help me ...

I've added the view of "Liliplanet on December 4, 2011 at 5:44am". Thank you Liliplanet !

I have that (traducted from my french install of Drupal) :

|x| Nid | Type | content type | Delete link | Module | Nb use

|Public Album|18 | Galery | node | delete | media | 1

Welcome forums | 19 | Topic |  | delete |  |

Here is a problem : for the topic "Welcome forums" of "Advanced Forums module's", content type is blank. There is no content type.

How can I modify my content type to define my content to one specific "content type" ?

I have no "content type" for all new content that is actually created on my site ! How this can happens ? (maybe I've done a error with Organic Groups?)
Please, help !!

liliplanet’s picture

liliplanet commented

Hi nothinghere,

Hmm, it definitely needs to be a 'content type'. When you look at the view, make sure you are looking at 'type' for content and not 'entity type' (which are for images and files).

What happens when you click on the link, does it exist? If you receive 'not found', go into the phpmyadmin and delete the node there.

A screenshot would help.

nothinghere’s picture

nothinghere commented

Here is a screenshoot :
http://imageshack.us/photo/my-images/522/drupalbug.png/

Yes, when I click on the link it exist. I don't have any "not found" error.

So, my bug don't come from problem described here?

liliplanet’s picture

liliplanet commented

hi nothinghere, yes when you click on the link and it does not exist, we are on the right path :)

when you mouse over the edit link for that node, see the node id, write that down

go into your phpadmin, see the node table, find the node id (from above) and delete it.

if you have many nodes you want to delete, just DELETE from node where nid IN (111, 222, 333, etc )

replace 111, 222, 333 etc with your node id's

Imaaxa-Cory’s picture

Imaaxa-Cory commented

Check your node table for content without a content type. This fixed my problem.

I had a single node created when I had the OG Example feature enabled. Later I turned off the feature , the node stayed, and caused the permission rebuild to hang. I removed the node and the permission rebuild ran smoothly.

Paradoxetion’s picture

Paradoxetion commented

I'll tell you how I fixed it.

I got EntityMalformedException: Missing bundle property on entity of type node error in my watchlog (recent log messages) after trying to index search (so after cron run). Before my index was let's say 48%, after cron run it stayed same.

I did lots of things, other suggestions didn't help me, but finally I did this and suggest you too:

0. Backup your database!!!
1. Go to phpMyAdmin, to "run sql" section.
2. Put here "SELECT n.nid FROM node n LEFT JOIN search_dataset d ON d.type = 'node' AND d.sid = n.nid WHERE d.sid IS NULL OR d.reindex <> 0 ORDER BY d.reindex ASC, n.nid ASC LIMIT 0,1"
if you have table prefix, don't forget to put it here.
3. As result you'll get one row with nid, pick it mind.
4. go to node table and run here "SELECT * FROM node WHERE nid=your-nid" where your-nid is nid from step 3
5. Try to open your-website/node/your-nid - for me I got "404 error"
6. Go back to phpMyAdmin and delete this row
7. Run cron again

AS for me I did this 7-8 times to delete all "bad" nodes from database and finally get 100% index

if you don't have access to phpMyAdmin I guess you can do this:
0. Turn on PHP filter module and backup database
1. create node type of page for example, to body add code

$result = db_query_range("SELECT n.nid FROM {node} n LEFT JOIN {search_dataset} d ON d.type = 'node' AND d.sid = n.nid WHERE d.sid IS NULL OR d.reindex <> 0 ORDER BY d.reindex ASC, n.nid ASC", 0, 1);
echo $result;

choose "PHP Filter" of course
2. Click "Preview"
3. You should see node id on the screen. Test it like in step 5 of directions for phpMyAdmin and pick in mind
4. Now you can delete it with

$nid = "your-nid";
db_delete('node')
  ->condition('nid', $nid)
  ->execute();

5. Run Cron again

Code above I didn't test, so if you'll use it please post here if it works

Thank you and happy indexing ;)

Anonymous’s picture

Anonymous (not verified) commented

The procedure above solved it for me. Although it seems to be much handwork at a glance, it's the way to find out the bad node directly responsible for crashing the indexer. You can then remove it carefully without affecting anything else.

Please note, the query is copied from the Search module itself! It's exactly the way the indexer fetches the next node during cron and points out who's the malformed entity.

drumrwaldo’s picture

drumrwaldo commented

I had tried a bunch of things from several other threads and issues of this type, but your method was what enabled me to eliminate the offending nodes. Thanks for taking the time to detail the process.

Anonymous’s picture

Anonymous (not verified) commented

+1 to this solution. This happened for me after upgrading from D6 to D7. Not sure what caused it but the site is fully indexed again.

thumb’s picture

thumb commented

Thanks to Paradoxetion for pointing me in the right direction. A malformed node does cause all sorts of problems. Here are a few queries to help others identify them.

Make sure all nodes have a node type. This will give you a quick report of how many nodes your site has for each type, including those without a type.

SELECT COUNT(*) AS nodes, type FROM node GROUP BY type;

Find nodes that don't have at least one node revision, as all nodes should in Drupal 7. This will identify nodes can't be added to the search index.

SELECT nid FROM node WHERE nid NOT IN (SELECT nid FROM node_revision);

Then either fix these nodes or delete them.

gottaknow’s picture

gottaknow commented

I'm still stuck on this. When I run the code (PHP filter enabled) I get.
Recoverable fatal error: Object of class DatabaseStatementBase could not be converted to string in eval() (line 3 of /var/www/xxx/modules/php/php.module(80) : eval()'d code).

Also I I look in the database under node I did have one entry that had 0 I removed that but the problem still persists. There are no other nodes without content types specified. Not sure what else to do.

History - Can't build permissions when I enable CONTENT ACCESS : FORUM ACCESS AND/OR ACL. All or singularly permissions fails to build 0 out of 1

shabana.navas’s picture

shabana.navas commented

This really helped!! Had some nodes that didn't have revisions. Deleting them solved the problem. Thanks a lot, you really saved the day.

Shabana Navas
snavas@acromedia.com
Software Developer
Acro Media
https://www.acromedia.com
1-800-818-4564
Skype: super.shaba

adellefrank’s picture

adellefrank commented

Thanks, thumb! Your tip about group nodes by type helped me find an empty one - and solved my problem!

chowdah’s picture

chowdah commented

In views, use fields title, nid and added a bulk operation. Filter results by content type but select node that are not any of the content types you currently have on the site.

Example - listed content types are all of my current ones

SELECT node.title AS node_title, node.nid AS nid, node.created AS node_created
FROM 
{node} node
WHERE (( (node.status = '1') AND (node.type NOT IN  ('advertisement', 'camp', 'directory', 'event', 'page', 'panel', 'program', 'recipe', 'story', 'testimonial', 'webform', 'website')) ))
ORDER BY node_created DESC
LIMIT 10 OFFSET 0

I used title and node id, and I found nodes with no content type and no title, but did have a node id. Some deleted easily, others required deleting the node content in phpMyAdmin

mrupsidown’s picture

mrupsidown
Location Switzerland
commented

Good hint! Thank you for this. My site stopped indexing at 76% and was throwing the same error until I found a ghost node and deleted it.

masssimino1’s picture

masssimino1 commented

Thank you very much, Paradoxetion! I've deleted "bad" node with PhpMyAdmin and now Cron runs without any errors.

alfthecat’s picture

alfthecat commented

Wow, thank you so much for this.

I really hope to see a module for this one day. I run a few sites with feeds. And this scenario basically happens every day on every website. I've been fighting with this forever as it's nearly impossible to debug.

It's a major downer for D7 that this sort of stuff happens and breaks the search API. Great to see this solution, sad it will have to be a daily routine.

Thanks Paradoxetion!

----
"People make mistakes. To really mess something up you need a computer."

sp09’s picture

sp09 commented

Mine was doing the same! Had 3 bad nodes that went to "page not found"

yves_s’s picture

yves_s commented

I added dpm($node); at the first line of the function function _node_index_node($node) in the "node.module" file.
After the cron job crashed, I got just one item with a nid displayed in the message section. After deleting that node everything was fine.

jessZ’s picture

jessZ commented

• Notice: Trying to get property of non-object in _node_index_node() (line 2782 of /home/reimagi8/public_html/new/modules/node/node.module).

I used the php query from the post above

Fixed for me
Paradoxetion

"SELECT n.nid FROM node n LEFT JOIN search_dataset d ON d.type = 'node' AND d.sid = n.nid WHERE d.sid IS NULL OR d.reindex <> 0 ORDER BY d.reindex ASC, n.nid ASC LIMIT 0,1

found an event node from an event calendar module that was installed in drupal 5 . We had deleted all content and all fields no issues until we migrated 6>7 in not a single bound. .... I also getting some cron errors from RSS feeds. easier to fix cause the error message indicates which feed item is the problem...ok now back to trying to index the site.

ibrail5’s picture

ibrail5 commented

i tried your method ,Paradoxetion and it's worked
but i noticed that some working node are in the sql result ; i didn't delete them
how could we explained that ?

nickonom’s picture

nickonom commented

The discussion in #1299530: php errors triggered during search indexing if content contains broken internal links might be relevant.