certain content won't show up

I have now checked the db and the content is all still there, even for the 'empty' nodes. I can't see any difference between entries in the db where the content is displayed, and those where it is not - but I am not at all familiar with checking databases. I also can't see any obvious difference between nodes which display their content, and those which don't: there are book, blog and quotes entries which show up, and there are book, blog and quotes entries which do not show up. It also doesn't seem to be date related (newly created nodes do seem to show up, but so do a few of the older nodes - see the attached screenshot)

I have now tried all of the following:

- upgrading from drupal 5 to 6
- clearing the cache (browser and drupal's)
- editing the 'empty' nodes (the content shows up in the editing box), then saving again.
- editing new nodes and saving as a new version
- optimising and repairing the db
- rebuilding permissions on the site
- changing the theme
- disabling all but core modules

Nothing works.

Don't know if it's relevant, but sometimes when I try to edit an 'empty' node, I get the message about having run out of memory.

I am attaching a screenshot: all these nodes are quotes - including the boxes down the right hand side. As you can see, one of them shows its content, although those either side do not. The same thing happens for book and blog entries.

Please help if you can!

No - I don't think so. I won't be able to access it till this evening and I'm a newbie at this... can you tell me what I should look for, and which table I need to look in?
Many thanks

Hhere are a few ... all slightly different. Is this what I should be looking at?

Rows statistics for Quotes table:

Format dynamic
Collation utf8_general_ci

Statistics for node_revisions, node, nodeteaser, vocabulary, blocks :

Format dynamic
Collation latin1_swedish_ci

statistics for book, content_type_blog:

Format fixed
Collation utf8_general_ci

I've checked that: all are input format full html, and the content in the edit box appears perfectly normal.

I tried another track: creating a new node with the same data as the one that wouldn't show up. I found that I couldn't create a new node that would show the content - I unless I adapt the content first.

eg. if I create a node with this content:

'Too bad one columnist wrote. Too bad, he said, Khadafi's infant daughter died, but that's the game of war. Well, if that's the game, then let's get the hell out of it, because it is poisoning us morally, and not solving any problem. It is only continuing and escalating the endless cycle of retaliation which will one day, if we don't kick our habits, kill us all. (Howard Zinn)'

.. it doesn't show up at all. Just the title does, and the tags.

If I remove the words 'Khadafi's infant daughter died, but that's the game of war. ' then the node shows up. Don't want to seem paranoid, but to me this looks like something is filtering out certain content (the length is not significant because I can add other words and it still shows up). Is this something that's technically possible?
thanks

thanks for the response! I normally have the following enabled:

Admin menu
Quotes
CCK
image
links
multilanguage
tagadelic
views + viewsbonus
addthis
archive
backup and migrate
excerpt
nice menus
pathauto
related links
update status
taxonomy manager

These were were all working fine until I changed my hosting service and rebuilt my site. What's strange is that when I do a fresh install (Dr 5 or 6) all the nodes seem to show up. I did that earlier today, but now I see the site is again not showing content on most of the nodes.

Could this be a memory issue? I was kicked off my old hosting provider (bluehost) because apparently my site was using too many resources. But the site is relatively small (about 900 nodes) and certainly doesn't have a big flow of traffic through it. Very often when I try to edit one of the 'empty' nodes I get that drupal message about memory being exceeded.

I'm baffled and cant' think what else to try now. Except to start again (and maybe not with drupal)

32 mb. Should that be enough?

IN any case, I've just done yet another fresh install. This time without importing my old database because I decided that I must have been hacked and the problem was in the db (is this likely?).

Curiouser and curiouser ... my brand new site suffers exactly the same problem:

I created 2 blog entries: the first a copy-paste job from BBC website about higgs boson particle. No problem: the node is created and shows up both as teaser and full content. 2nd node was a post about activism/protest and although the teaser shows, the rest of the content doesn't when I click on the node title. Then I edited that second post: I kept the title the same but copy-pasted another harmless piece of BBC content (arty, culture, ie politically harmless) - and hey presto, the node suddenly appears!! When I revert to my old content and then publish, it disappears again. All I can see is the title. Editing the node shows that the content is still there, in the system, but I can't get it to show up in a published node.

What the hell is going on here!? I have no modules except core ones enabled on the new site and a brand new database (ie almost empty). SO it can't be a memory issue. If the old site was hacked - could the problem carry through to a brand new site, brand new database??

thanks for any help!

(do you think I have this issue listed under the correct component? just changed it from nodesystem to basesystem but I am not sure that is right either)

A few answers...

First - I cleared the cache.

I had enabled a few contributed modules, but have now disabled all except update status.

I'm creating stories. I also tried blog entries (before I disabled the blog module) and quotes (briefly enabled then disabled). Input filter is filtered html. I did try full html but no joy.

Now I'm trying to narrow down offending words...

This paragraph won't show:

Too bad one columnist wrote. Too bad, he said, Khadafi's infant daughter died, but that's the game of war. Well, if that's the game, then let's get the hell out of it, because it is poisoning us morally, and not solving any problem. It is only continuing and escalating the endless cycle of retaliation which will one day, if we don't kick our habits, kill us all. (Howard Zinn)

This will:

Too bad one columnist wrote. Too bad, he said, infant daughter , but that's the game of . Well, if that's the game, then let's get the out of it, because it is us , and not solving any problem. It is only continuing and escalating the cycle of which will one day, if we don't kick our habits, us all. (Howard Zinn)

If I insert back into the text any one of the words I have removed

khadafi's war hell poisoning morally retaliation kill

then the node disappears again.

If I post any of the offending words individually as my 'story', they show up (eg 'kill' shows up on its own). In fact, if I post all 7 together (khadafi's war hell poisoning morally retaliation kill) but without anything else - the node shows up!

And now the really strange news: if I post all the words from the original quote, but in a different order, the node shows up. This shows, for example:

khadafi's war hell poisoning morally retaliation kill Too bad one columnist wrote. Too bad, he said, infant daughter , but that's the game of . Well, if that's the game, then let's get the out of it, because it is us , and not solving any problem. It is only continuing and escalating the cycle of which will one day, if we don't kick our habits, us all. (Howard Zinn)

So it looks like my paranoia was misplaced and it's not to do with 'offending words'. Next I tried removing 'unoffensive' words, and sure enough the following will show up:

Too bad one columnist . Too bad, he , Khadafi's infant daughter died, but that's the of war. , if that's the game, then let's get the hell out of it, it is poisoning us morally, and not solving problem. It is continuing and escalating endless cycle of retaliation which one day, if we don't kick , kill us all. (Howard Zinn)

That was the original quote with about 10 words removed (the, only, because, wrote, said...)

Now I am wondering could the content somehow be interfering with my old database which is still in the same mysql process??

@ NancyDru

I had the same thought.. although my host calls themselves 'nearlyfreespeech.net'. Thing is, I can post that same content on a (separate) wiki that I have with the same host. So if they are filtering, then it seems to be only the drupal site. I will contact them in a few days to ask, but they have a stupid rule that if you have posted an enquiry in the forum, you can't send a separate one to the administrators! (and no-one has responded to my forum post yet). When it gets to page 2 I will .

I tried the fullhtml option as well. No joy there.

thanks so much for your help with this.

hello fearfox
I tried what you suggested - if I understood you correctly. Created a 'page' with my content and also a block. Both with filteredhtml and then when that didn't work, fullhtml. Same old story: with the same content, the node won't show. If I remove bits and pieces, it will.

What do you mean this will confirm or eliminate the filtering idea? That this is a new content type, so the caching / existing database entries shouldn't interfere?? (Just in case, I also tried creating a new mysql process with only the new clean database. Nothing doing, as you suggested.)

but anyway, I am going off the filtering idea (at least if this means at the level of the hosting provider) because as I said above, I can post this content without any difficulty on my tikiwiki site with the same provider. Why is just my drupal site being filtered?????

I just posted that paragraph on my D6 test site without any trouble.

yes - and I just set up a new site with my host, installed a fresh drupal site, and posted the troublesome paragraph. No problem! So the host is definitely not filtering content. The only difference between the test site and my main site (I think!) is that I have a redirect on for the main one. The main site is located at nfshost.com and redirects to my domain name. With the test site, I used the nfshost address without redirection.

They have assured me that this would make no difference to content. But it seems to. Don't know where to go next.

(@Pasqualle : I didn't use a teaser - and anyway, neither teaser nor main content are showing! No wysiwyg. Site is currently offline - but you wouldn't see much anyway. I've included a screenshot under my first post above, so you can see what it looked like before I reinstalled with an empty database. Now I have bluemarine not customised theme - so that's not the problem either)

Can you tell which input format is used for the problematic nodes, and which filters are enabled for that input format.

I have switched between full html and filtered html for all nodes - problematic and otherwise - and it doesn't make any difference. I don't think I fiddled with the filters at all: for both types all available filters are checked.

Did you ever used any node access module on the site?

no.

How many rows do you have in the {node_access} table?

you may have to help me with this: if I hover over that table, it gives me 1 row. If I try to browse it it gives the following:

Showing rows 0 - 0 (1 total, Query took 0.0004 sec)

1 row, right?