Cannot delete comment.

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

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

Cannot delete comment.

Post by jazcyk » Thu Oct 14, 2010 9:23 am

Admin backend of 5.6.9 fails to delete a comment in the news section (I tried Firefox and Opera). I will delete manually in database but before doing I will export the row to a CSV-file in case the error is data-specific. So please tell if you will need it.

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

Re: Cannot delete comment.

Post by Thorsten » Thu Oct 14, 2010 3:02 pm

Hi,

sure.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

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

Re: Cannot delete comment.

Post by jazcyk » Thu Oct 14, 2010 3:14 pm

I do not get you. Do you need my file to debug this? You cannot reproduce


Anyway the comment (to be imported into faq_comments table with LOAD DATA stmt. for instance) is like this (just a typical spam comment):

"80","28","news","coach outlet","linhanyi2009@live.cn","Coach outlet<br />
coach factory outlet<br />
coach outlet store<br />\
coach handbags<br />\
coach boots<br />\
gucci handbags<br />
gucci bags<br />
coach handbags<br />
Supra Shoes<br />
cheap supra shoes<br />
cheap gucci handbags<br />
coach bags<br />
chanel bags outlet<br />
chanel bags <br />
gucci outlet online<br />
mbt shoes<br />
mbt shoes on sale<br />
chanel bags","1287017363",""


But you will probably use th PK in the WHERE clause, so I doubt it is data specific.

Did you get that I was reporting a BUG? :-)

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

Re: Cannot delete comment.

Post by jazcyk » Sat Oct 16, 2010 1:23 pm

This is not a privilege issue? Comments in NEWS section cannot be deleted - not by a fully privileged user either.

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

Re: Cannot delete comment.

Post by Thorsten » Sat Oct 16, 2010 2:14 pm

Hi,

I re-checked it once again and found the issue. I'll work on a fix.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

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

Re: Cannot delete comment.

Post by Thorsten » Sat Oct 16, 2010 2:32 pm

Hi,

this will fix your problem: http://github.com/thorsten/phpMyFAQ/com ... a8c6bb61a7

The fix will be also included in 2.6.10.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Mercury
Posts: 51
Joined: Fri Dec 17, 2010 9:25 pm
Contact:

Re: Cannot delete comment.

Post by Mercury » Wed Dec 22, 2010 7:49 pm

@jazcyk,
I’m glad you made this thread. So this is a bug even in the latest version. I have this same problem in 2.5.4 (except that I can’t delete (some) comments in news or anywhere else).

I also had to edit the database by hand to remove the comment. As I had never before edited a database by hand it was a white-knuckle experience. And believe it or not the same damn spammer made the same damn comment on my site too! I hate spammers.

@thorsten
Can I use the file “record.comments.php” with 2.5.4? Thanks.
www.puppylinuxforum.org

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

Re: Cannot delete comment.

Post by Thorsten » Thu Dec 23, 2010 6:28 am

Hi,

deleting comments is working for me in 2.6.13 for FAQs and News. I don't think you can use this file in 2.5.4, because the heavily changed the code there.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Mercury
Posts: 51
Joined: Fri Dec 17, 2010 9:25 pm
Contact:

Re: Cannot delete comment.

Post by Mercury » Thu Dec 23, 2010 2:49 pm

@ Thorsten
OK I won’t try that file with 2.5.4.

The possibility of comments that cannot be deleted is for me a very serious problem. This was what first forced me to edit the database by hand. I have a comment on my site right now that I cannot delete with the admin tools. Like the OP I tried other browsers and in other OS.

I am clueless as to why some comments can be deleted and why others can’t. Without knowing why this happens I’m left wondering if it will reoccur even after upgrading to the latest rev.

Does anyone know why some comments can be deleted but others can’t? If this bug is cured in the latest rev then that’s good but I still would like to know what causes this behavior. If you prefer not to say why publicly then please send me a PM in the forum.

For now though I won’t be editing the database as I am currently in process of moving my site to a new host. I am also in process of using the MySQL database admin tools at my new host to see if that might be easier than editing by hand. What I have found thus far has been very encouraging. Time permitting I may make a new thread and report what I find out about this.
www.puppylinuxforum.org

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

Re: Cannot delete comment.

Post by Thorsten » Thu Dec 23, 2010 3:19 pm

Hi,

we had some logical bugs in the 2.5 series and the early 2.6 releases for comment deletion. But it should be fixed now.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply