Comments and sidebar not showing on one entry

[mdnava]

I've found one entry on my Blog that doesn't show any related comments and neither it shows the sidebar plugins. Every other entry I've checked seems to be working fine.

This is the entry: http://www.venelogia.com/archivos/695/

I did a check on the database and the content is there... Any ideas?

[Don Chambers]

The entry says comments are not allowed.... although the meta box suggests there are 1500+ comments to your entry (are you kidding? 1500+ comments??!!!!)

Anyway, check the entry itself - did you disable comments for that entry?

As far as the sidebars, the code says the sidebars are being emitted, but the content of them is blank. Someone else might have a better idea, but I would need to see your template's index.tpl file, and possibly the permissions for this entry, and all sidebar plugins.

Can you think of anything that is distinctly different about this entry?

[mdnava]

Those numbers are correct, besides that nothing out of the ordinary. Yes the comments are disabled (there are too many already and I decided to limit them to 500) but even when enabled they won't show.

I can give you an example of other posts with a high number of comments but none other is failing:
http://www.venelogia.com/archivos/2392/
http://www.venelogia.com/archivos/2250/
http://www.venelogia.com/archivos/707/
http://www.venelogia.com/archivos/2481/

If there were a problem with smarty it should happen on some other entries as well right? but I haven't found any other issue, all over s9y is working fine.

One other thing, on the statistics plugin this entry appears listed several times on "suscriptions" with different number of suscriptions, but the entry ID remains the same there is not one duplicated entry con the database.

[mdnava]

The sidebar issue was fixed when I replaced:

Code: Select all

{serendipity_printComments entry=$entry.id mode=$CONST.VIEWMODE_LINEAR}

With:

Code: Select all

{serendipity_printComments entry=$entry.id mode=$CONST.COMMENTS_VIEWMODE_LINEAR}

Which I found comparing my template with bulletproof, I guess hat was older code or something but still the comments are not showing.

I remember the last time I saw the comments printed in that post, I was deleting several of them (spammy) and they haven't been printed ever since. That makes me think about the database but the content is there.

[mdnava]

Problem Fixed!!

I had to rollback the changes I made since comments started failing globally, but this had an unexpected side effect, now everything including the troubled entry is working again.

[mdnava]

This issue started to happen again by itself!... No changes have been made in smarty.

This is getting annoying!.

[garvinhicking]

Hi!

Hm, it could be memory related. Did you check your apache/php error log to check for PHP errors?

Regards,
Garvin

[mdnava]

Well, I upgraded to 1.4.1 and now this issue seems fixed for good but I'm still getting blank pages every now and then. I just hit the F5 button and loads correctly.

Any idea why this other issue is happening?

[garvinhicking]

Hi!

Most probably due to Memory outage. Check your apache/php error log.

Regards,
Garvin

[mdnava]

Most probably due to Memory outage. Check your apache/php error log.

Hello Garvin,

I was able to replicate easily the blank page issue, on the cpanel error log it showed a server error 400 (bad request)... So I'm guessing at this stage it has something to do with either with htaccess entries and/or URL rewriting.

On the PHP error log I see many errors like this (thousands of lines):

Code: Select all

[07-mar-2009 23:57:38] PHP Warning:  Cannot use a scalar value as an array in /home/venelog/public_html/plugins/serendipity_event_entrysplit/serendipity_event_entrysplit.php on line 94
[07-mar-2009 23:59:52] PHP Warning:  Cannot use a scalar value as an array in /home/venelog/public_html/plugins/serendipity_event_entrysplit/serendipity_event_entrysplit.php on line 93

I've uninstall the plugin (not using it) but still I get some blank pages.

Besides that, the other errors I saw can be explained, like database connection refusals when mysql wasn't available.

[garvinhicking]

Hi!

Hm, HTTP 400 errors might be caused by the PHP-CGI failing completely, maybe even coredumping. Have you checked for possible syslogs or anything where such fatal errors could be logged?

Do you use mod_security or some PHP bytecode cache? Those could also have such an influx.

Regards,
Garvin

[mdnava]

Hm, HTTP 400 errors might be caused by the PHP-CGI failing completely, maybe even coredumping. Have you checked for possible syslogs or anything where such fatal errors could be logged?

Do you use mod_security or some PHP bytecode cache? Those could also have such an influx.

weird syslogs I THINK NOT
mod_security YES
PHP bytecode NO

But now that you mentioned coredumping I've actually done some adjustments to apache/mysql in the "quest" for performance. I'll look into it!.

******************
By the way Garvin, we talked once about s9y causing a high server load when publishing new entries, there was this theory that it was caused by the simple_cache plugin when files were erased. However, after a new entry is published (mostly during rush hours), mysqld takes between 30% and 99% of the CPU for the next 2 to 5 minutes... Sometimes even taking the server over the 100 CPU load mark (for real).

Index updates???

[garvinhicking]

Hi!

Index updates???

Hm, generally, this could be. How large are your *.MYD and *.MYI files? If they are really large, it could really be the index updating. I've never worked with so high amounts of data. Maybe there is a mysql forum where some people know about the mysql reindexing performance implications?

Regards,
Garvin

[mdnava]

Hm, generally, this could be. How large are your *.MYD and *.MYI files?

Are these big enough to cause this? (numbers are kilobytes)

6768172 blog_entries.MYD
7876608 blog_entries.MYI

40875332 blog_comments.MYD
3023872 blog_comments.MYI

660592 blog_references.MYD
183296 blog_references.MYI

[garvinhicking]

Hi!

Whoah. Yeah. That's huge. How much RAM does your SQL DB server have? It should have 16GB or so.

Regards,
Garvin