FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Comments disappearing randomly (!?)





leontius
My site is getting very weird lately - in some pages, comments are not shown. For example, in http://leapon.net/en/i-wish-every-employer-is-like-google you can see the comments but in http://leapon.net/en/windows-vista-and-ubuntu-804-first-looks you cannot. I'm using Drupal CMS.



I can only say that the site works perfectly before July 2, 2008. I sighted the bug on July 9, 2008. I also cannot reproduce the bug on test server (meaning that it is not the fault of Drupal).



The test server version is:



Code:


leon@leon-laptop:~$ /opt/lampp/bin/httpd -v

Server version: Apache/2.2.8 (Unix)

Server built:   Jan 23 2008 12:04:44

leon@leon-laptop:~$ /opt/lampp/bin/php -v

PHP 5.2.5 (cli) (built: Jan 23 2008 14:13:03)

Copyright (c) 1997-2007 The PHP Group

Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies





this is different from the version used by frihost. Can I know if/what server tuning was made between July 2 and July 9 (perhaps a server upgrade)? Because I couldn't think of any other ways the bug appears...
Bondings
I don't remember changing anything special. Besides, it this would be due to different software.

I commented on both pages, feel free to remove them. On the one that works, it did appear, on the other it didn't. Pretty obvious, but better to test it again.

Either there is some option to not show comments for a certain blog post and you accidently activated it. Otherwise it might be an issue with your database. Maybe the link between the comments and the post got lost or something similar. Can you maybe check if the comments are still in the database? Also there is probably a table that links the post id to the comment id (or something similar). It could very well be that the last for some reason disappeared. Also, simply repairing the tables in phpMyAdmin could help.
leontius
Whoa thanks for the rapid response!

Quote:
Either there is some option to not show comments for a certain blog post and you accidently activated it.


Actually there is an option to disable comments but if it is disabled then the comment form would not be there.

Quote:
Otherwise it might be an issue with your database. Maybe the link between the comments and the post got lost or something similar. Can you maybe check if the comments are still in the database? Also there is probably a table that links the post id to the comment id (or something similar). It could very well be that the last for some reason disappeared. Also, simply repairing the tables in phpMyAdmin could help.


I can even access the comments from administration pages meaning that the comments really go into the DB. I also checked the database and repaired them all (is it the right thing to do?) but nothing changes... Also if I take the database dump and put it on a test server, the problem goes away so it is not about the database. Confused Confused Confused
Bondings
Unfortunately I don't understand it either. I don't think it is due to the server software since in that case it would rather give an error, not show all comments or never show certain comments (not even in administration), like with a character set problem. Also, there would most likely be other people on the internet having the same problem.

Searching on Google for it, didn't help much either. First I thought I found a solution, but apparently it was the same question, but posted at drupal and unanswered. I did find an old post about some comments disappearing: http://drupal.org/node/4624 . Maybe they are in some kind of moderation queue and still need to be accepted?

Otherwise, the only thing I can think of is to try to install/put the drupal code somewhere else on frihost (like on your subdomain of us) and try there if it works. Maybe something in the code got changed.
leontius
I've uploaded the exact PHP files that work fine in my test server at http://leapon.net/drupal5 (it's a quick setup, things may break and it uses the same database as the original one) but it still has the problem... I'll try to clone the database and turn off some functionalities/modules in the dummy site to narrow down the problem.
Related topics
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.