comments admin page is empty

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

comments admin page is empty

Post by jazcyk » Mon Sep 21, 2009 10:19 am

Help!

'comments' page (http://www.webyog.com/faq/admin/index.p ... n=comments) displays empty.
Only the header line is there. No content displayed. Tried both IE and FF.

"SELECT COUNT(*) FROM faq_faqcomments" against database returns 27.

PMF 2.0.17. It used to work with earlier versions. Is it reproducible? What can the problem be? Is there a patch?

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Mon Sep 21, 2009 5:17 pm

Hi,

I'll check it.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Mon Sep 21, 2009 5:23 pm

Hi,

I checked it and it works for me. Strange, we didn't changed anything there since 2.0.10.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

Re: comments admin page is empty

Post by jazcyk » Mon Sep 21, 2009 6:49 pm

I am happy that Torsten is happy, but that reply did not help me much. What can I check?

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Mon Sep 21, 2009 7:55 pm

Hi,

this is a good question. Could you please send me your faqcomments table?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

Re: comments admin page is empty

Post by jazcyk » Fri Dec 18, 2009 1:58 pm

I am sorry for not coming back, but I have been too busy.

Actually not only ACP 'comments' page display empty but also 'categories'. We tried an upgrade to 2.5.5 on a staging server and weird enough that solved the problem with 'comments' bot not with 'categories'. It is data-related. A fresh installation (2.0 or 2.5) does not have such issue. Can we dump the database, upload the dump and and post the link so that you can check/verify with our data? It is a few MBs only.

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Fri Dec 18, 2009 2:17 pm

Hi,

sure, just send me the dump.

It's very strange that you see the categories in the frontend but not in the admin backend.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

Re: comments admin page is empty

Post by jazcyk » Fri Dec 18, 2009 2:32 pm

OK .. my colleague Supratik will arrange. (upload to our server and mail you a link).

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Fri Dec 18, 2009 2:33 pm

Hi,

okay... btw, 2.6.0 is available in a few days/weeks, so you should wait with the upgrade.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

Re: comments admin page is empty

Post by jazcyk » Fri Dec 18, 2009 3:38 pm

I think we would like to deploy 2.5.5 now and wait for a few months with 2.6. But Supratik is the server guy now.

supratik
Posts: 2
Joined: Fri Dec 18, 2009 3:25 pm

Re: comments admin page is empty

Post by supratik » Fri Dec 18, 2009 4:18 pm

Hi

I have uploaded the database dump in our server, You may download the file from here.

Warm Regards

Supratik
Last edited by supratik on Fri Dec 18, 2009 4:21 pm, edited 1 time in total.

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Fri Dec 18, 2009 4:20 pm

Hi,

thanks, I downloaded it and removed the URL.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

supratik
Posts: 2
Joined: Fri Dec 18, 2009 3:25 pm

Re: comments admin page is empty

Post by supratik » Fri Dec 18, 2009 4:26 pm

The URL was not displayed properly so I edited the post, so after you have removed, it is posted once again.
Can you please remove the URL once again if it is not required anymore.

Warm Regards

Supratik

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Fri Dec 18, 2009 4:35 pm

Hi,

I already downloaded it and I can reproduce this issue.

My PHP produces segmentation faults when I open the category page. Very strange. I try to debug this.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten » Fri Dec 18, 2009 4:48 pm

Hi,

I found the issue.

You have on broken entry in the faqcategories table. Please remove the entry with the id = 0 and the parent_id = 0. This causes infinite loops and PHP crashes.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply