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 »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

Hi,

I'll check it.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

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 »

I am happy that Torsten is happy, but that reply did not help me much. What can I check?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

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 »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

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 »

OK .. my colleague Supratik will arrange. (upload to our server and mail you a link).
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

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 »

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 »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

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 »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: comments admin page is empty

Post by Thorsten »

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