1
ja_n1ne
Cannot Delete Forum Posts
  • 2005/1/26 18:10

  • ja_n1ne

  • Just popping in

  • Posts: 8

  • Since: 2005/1/25


Hi all,
Im having a small issue. Seems I cannot delete forum posts. Let me clarify a bit I can delete the child posts just not the parent posts. We made a couple of posts in our forums to test out the new mod and then replied to them. We could delete the replies just not the main post. Any ideas would be greatly appreciated. Thanks in advance

2
brash
Re: Cannot Delete Forum Posts
  • 2005/1/26 21:18

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


I take it your using NewBB 2.01? Are you given any error on screen when trying to delete the parent post? Are there any errors with PHP or MySQL debug modes turned on?

3
ja_n1ne
Re: Cannot Delete Forum Posts
  • 2005/1/27 0:13

  • ja_n1ne

  • Just popping in

  • Posts: 8

  • Since: 2005/1/25


Queries
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '314869563068564d1af4727158e3f9b3'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = 2) ORDER BY conf_order ASC
SELECT * FROM xoops_bb_forums WHERE forum_id = 1
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_itemid = 2 AND gperm_modid = 1)
SELECT uid FROM xoops_groups_users_link WHERE groupid=1
SELECT p.*, t.*, tp.topic_status FROM xoops_bb_posts p LEFT JOIN xoops_bb_posts_text t ON p.post_id=t.post_id LEFT JOIN xoops_bb_topics tp ON tp.topic_id=p.topic_id WHERE p.post_id=9
SELECT topic_status FROM xoops_bb_topics WHERE topic_id=3
SELECT p.*, t.*, tp.topic_status FROM xoops_bb_posts p LEFT JOIN xoops_bb_posts_text t ON p.post_id=t.post_id LEFT JOIN xoops_bb_topics tp ON tp.topic_id=p.topic_id WHERE p.post_id=9
-300
Quote:
Error number: 1064
Error message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-300' at line 1

DELETE FROM xoops_online WHERE online_updated < 1106785616
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1

4
Anonymous
Re: Cannot Delete Forum Posts
  • 2005/1/27 1:25

  • Anonymous

  • Posts: 0

  • Since:


Use this patch for this stupid delete Bug:

http://downloads.xoops2.org/patchfor2.0.1.zip

5
saturn_de
Re: Cannot Delete Forum Posts
  • 2005/1/27 2:11

  • saturn_de

  • Just popping in

  • Posts: 11

  • Since: 2004/11/8


could you please provide diffs also? ok, I can try to extract them from cvs... but
Thx

6
saturn_de
Re: Cannot Delete Forum Posts
  • 2005/1/27 14:50

  • saturn_de

  • Just popping in

  • Posts: 11

  • Since: 2004/11/8


Ok, this helped...
cat xoops-delete.patch
--- modules/newbb/class/post.php        2005-01-25 13:59:46.000000000 +0100
+++ modules/newbb/class/post.php        2005-01-25 18:58:04.000000000 +0100
@@ -812,+812,@@
                 
$this->_delete($childpost);
                 unset(
$childpost);
             }
+            
$this->_delete($post);
         }

         return 
true;

The other changes in the patches file were to big and obscure to me. Also the sourceforge cvs does not seem to be the one, which was used for the release and this patches file

7
ja_n1ne
Re: Cannot Delete Forum Posts
  • 2005/1/27 18:13

  • ja_n1ne

  • Just popping in

  • Posts: 8

  • Since: 2005/1/25


Thanks I installed the patch and everything seems to be working as it should

8
Anonymous
Re: Cannot Delete Forum Posts
  • 2005/1/28 19:02

  • Anonymous

  • Posts: 0

  • Since:


Quote:

The other changes in the patches file were to big and obscure to me. Also the sourceforge cvs does not seem to be the one, which was used for the release and this patches file


We have started a new Branch for the 2.1 version so the changes are in the newbb_2_1_branch

Login

Who's Online

335 user(s) are online (267 user(s) are browsing Support Forums)


Members: 0


Guests: 335


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits