1
hoffswell
NewBB2 Can't delete topics
  • 2005/3/24 18:50

  • hoffswell

  • Just popping in

  • Posts: 6

  • Since: 2005/1/25


Hi -

We are having a problem where we cannot delete a topic. When the admin user or a moderator tries to delete the topic, all the replies are deleted, but not the topic itself.

We have checked and repaired our database, no problem there.

We can edit and move the topic, just not delete!

Any ideas?

2
hoffswell
Re: NewBB2 Can't delete topics - Additional info
  • 2005/3/24 20:36

  • hoffswell

  • Just popping in

  • Posts: 6

  • Since: 2005/1/25


mysql debug throws an error

Quote:

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 = '4d7e4e8a2013012276130cc01ea8a7d7'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = 9) ORDER BY conf_order ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_itemid = 9 AND gperm_modid = 1)
SELECT uid FROM xoops_groups_users_link WHERE groupid=1
SELECT uid FROM xoops_groups_users_link WHERE groupid=5
-300
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 < 1111693236
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1111693536, online_module = 9 WHERE online_uid = 1
SELECT COUNT(*) FROM xoops_bb_online WHERE online_uid=1
UPDATE xoops_bb_online SET online_updated= '1111693536', online_forum = '1', online_topic = '0' WHERE online_uid = 1
SELECT online_uid, online_ip FROM xoops_online WHERE online_module = 9
DELETE FROM xoops_bb_online WHERE ( online_uid NOT IN (1) )
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 4
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2,4,5)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,9) AND b.bid IN (1,2,3,4,5,44,6,7,45,43,8,9,46,42,10,11,30,12,21,13,19,20,14,15,16,17,28,18,31,29,27,26,22,23,24,25,32,39,40,41) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops_modules WHERE dirname = 'news'
SELECT COUNT(*) FROM xoops_stories WHERE published=0
SELECT COUNT(*) FROM xoops_modules WHERE dirname = 'mylinks'
SELECT COUNT(*) FROM xoops_modules WHERE dirname = 'mydownloads'
SELECT COUNT(*) FROM xoops_xoopscomments WHERE com_status=1
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'fpc-default' AND tpl_file = 'system_block_waiting.html') ORDER BY tpl_refid
SELECT * FROM xoops_modules WHERE (hasmain = 1 AND isactive = 1 AND weight > 0) ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2 OR gperm_groupid = 4 OR gperm_groupid = 5))
SELECT * FROM xoops_modules WHERE dirname = 'news'
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'fpc-default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
DELETE FROM xoops_online WHERE online_updated < 1111693236
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1111693536, online_module = 9 WHERE online_uid = 1
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module = 9
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'fpc-default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT * FROM xoops_users WHERE (level > 0) ORDER BY user_regdate DESC LIMIT 0, 10
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'fpc-default' AND tpl_file = 'system_block_newusers.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = 0 AND to_userid = 1)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'fpc-default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT p.*, t.* FROM xoops_bb_posts p, xoops_bb_posts_text t WHERE p.topic_id = 14 AND p.pid = 0 AND t.post_id = p.post_id
SELECT * FROM xoops_bb_posts WHERE pid=25
SELECT MAX(post_id) AS last_post FROM xoops_bb_posts WHERE forum_id = 1
SELECT COUNT(*) AS total FROM xoops_bb_posts WHERE forum_id = 1
SELECT COUNT(*) AS total FROM xoops_bb_topics WHERE forum_id = 1
UPDATE xoops_bb_forums SET forum_last_post_id = 25, forum_posts = 18, forum_topics = 7 WHERE forum_id = 1
SELECT max(post_id) AS last_post FROM xoops_bb_posts WHERE topic_id = 14
SELECT COUNT(*) AS total FROM xoops_bb_posts WHERE topic_id = 14
UPDATE xoops_bb_topics SET topic_replies = 0, topic_last_post_id = 25 WHERE topic_id = 14
DELETE FROM xoops_xoopsnotifications WHERE (not_modid = 9 AND not_category = 'thread' AND not_itemid = 14)
Total: 52 queries

Blocks
Login: No Cache
Waiting Contents: No Cache
Main Menu: No Cache
Who's Online: No Cache
New Members: No Cache
User Menu: No Cache
Total: 6 blocks

Execution Time
XOOPS took 0.20552611351013 seconds to load.

Extra?



Any ideas?

3
jdseymour
Re: NewBB2 Can't delete topics - Additional info

There was a bug like this in Newbb 2.01. Check your version, if it is 2.01 upgrade to 2.02 fixes the bug.

HTH.

4
Dave_L
Re: NewBB2 Can't delete topics - Additional info
  • 2005/3/24 22:06

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Note that the version number in 2.02 still says "2.01". If you're not sure which one you have, download 2.02 and compare the files.

Login

Who's Online

390 user(s) are online (64 user(s) are browsing Support Forums)


Members: 0


Guests: 390


more...

Donat-O-Meter

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

Latest GitHub Commits