1
Cavan
Admin cannot delete messages...
  • 2005/4/3 5:52

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


I'm having a stange issue trying to delete messages: Other members can delete their old private messages in the inbox without issue yet I've been unable to do so without actually going into phpMyAdmin and deleting the messages from the xoops_prv_msgs table. Is this normal or is this something that can be fixed? Our site just went live (finally!) today and I don't want to get bogged down trolling through my inbox as it fills up...Anyone have any ideas as to what's going on here?

2
zoullou
Re: Admin cannot delete messages...
  • 2005/4/3 8:56

  • zoullou

  • Quite a regular

  • Posts: 250

  • Since: 2004/3/2 0


Turn your site into MySQL debug mode to show SQL request.

3
Cavan
Re: Admin cannot delete messages...
  • 2005/4/3 21:29

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


The problem is worse than I thought:

When trying to delete a private message from the 'inbox page' (viewpmsg.php), you cannot delete any messages.

And, when trying to delete a private message from the 'read private message page' (readpmsg.php), this leads to a blank white page.

The reply function seems to work fine.

Apparently, no one can delete any private messages. How do I fix this?

4
jdseymour
Re: Admin cannot delete messages...

When turn on PHP debug to get the blank page error. Turn on MySQL debug to see the queries taking place when attempting to delete a message.

5
Cavan
Re: Admin cannot delete messages...
  • 2005/4/4 3:56

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


MySQL Debug ON displays the following when attempting to delete a message from the inbox (viewpsmg.php):

Queries 
SELECT 
FROM xoops_config WHERE (conf_modid AND conf_catid 1ORDER BY conf_order ASC 
SELECT sess_data FROM xoops_session WHERE sess_id 
'0b918d0493a496b29c6e1a55417e05d5' 
SELECT FROM xoops_users WHERE uid=
SELECT 
FROM xoops_config WHERE (conf_modid AND conf_catid 3ORDER BY conf_order ASC 
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name 
'block_read' AND gperm_modid AND gperm_groupid IN (1,2
SELECT b.* FROM xoops_newblocks bxoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=AND b.visible=AND m.module_id=AND b.bid IN (1,2,72,3,4,5,6,7,8,9,10,11,12,46,31,17,18,20,21,22,23,40,39,41,42,43,177,178,166,181,180,179,182ORDER BY b.weight,b.bid 
SELECT 
FROM xoops_priv_msgs WHERE to_userid 1 ORDER BY msg_id ASC 
SELECT 
FROM xoops_users WHERE uid=
SELECT 
FROM xoops_users WHERE uid=
SELECT 
FROM xoops_users WHERE uid=10 
Total
10 queries 

Blocks 
Total
0 blocks 

Execution Time 
XOOPS took 0.059154033660889 seconds to load


Extra


With PHP Debug on and attempting to delete a message from the read message page (readpmsg.php), there is no output---the page comes up blank.

6
jdseymour
Re: Admin cannot delete messages...

Well, unfortunately that does not seem to help much. I tested the deletion on my test site with MySQL debug enabled, same output as yours. Only mine deleted.

Just before this started occurring is there any changes that you remember making at all? Maybe module install, group permission change and so on.

7
Cavan
Re: Admin cannot delete messages...
  • 2005/4/4 8:38

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


No, no changes made. No new modules, no permission changes. Still can't figure this one out. ???

8
brash
Re: Admin cannot delete messages...
  • 2005/4/4 8:43

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


I suggest we put all issues on hold until further notice. Short of it is Cavan as I have little doubt you have realised by now is that you simply should not be having this much trouble using Xoops. I'll set you up a test site on my server and we can start working backwards from there. What would be helpful is if you could itemise all the problems you've been having with XOOPS as a whole so we can check them off one by one.

9
Cavan
Re: Admin cannot delete messages...
  • 2005/4/6 8:03

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


Much thanks to brash for helping me out on this one...turns out one problem I'd inadvertently created was causing many others.

Thanks, brash.

Login

Who's Online

379 user(s) are online (312 user(s) are browsing Support Forums)


Members: 0


Guests: 379


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