Jump to content

Removing manually PMs(personal messages)


Recommended Posts

Hello, after using Mass PM from marketplace, i have tried to remove some pms to reduce sql size.

My question is when a pm is created , what is changed in DB? I have removed pm contents with this query:

DELETE FROM `ipm_core_message_posts` WHERE `msg_post` LIKE '%message contents%'

and for message titles this query:

DELETE FROM `ipm_core_message_topics` WHERE `mt_title` LIKE '%message title%'

is there anywhere else contents of pms?

Link to comment
Share on other sites

DELETE FROM core_message_topics, core_message_posts, core_message_topic_user_map 
USING core_message_topics 
LEFT JOIN core_message_topic_user_map ON core_message_topics.mt_id=core_message_topic_user_map.map_topic_id
LEFT JOIN core_message_posts ON core_message_topics.mt_id=core_message_posts.msg_topic_id 
WHERE core_message_topics.msg_post LIKE '%message contents%'

Provided with no warranties.  Will delete messages from ALL linked PM tables in one shot based on your WHERE clause.

Link to comment
Share on other sites

im getting this error after i removed manually pms:

OutOfRangeException:  (0)
#0 /home/maxtor99/public_html/applications/core/modules/front/messaging/messenger.php(394): IPS\Patterns\_ActiveRecord::load(NULL)
#1 /home/maxtor99/public_html/system/Dispatcher/Controller.php(96): IPS\core\modules\front\messaging\_messenger->manage()
#2 /home/maxtor99/public_html/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute()
#3 /home/maxtor99/public_html/applications/core/modules/front/messaging/messenger.php(71): IPS\Content\_Controller->execute()
#4 /home/maxtor99/public_html/system/Dispatcher/Dispatcher.php(146): IPS\core\modules\front\messaging\_messenger->execute()
#5 /home/maxtor99/public_html/index.php(12): IPS\_Dispatcher->run()
#6 {main}


#0 /home/maxtor99/public_html/init.php(523): IPS\_Log::log('OutOfRangeExcep...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(OutOfRangeException))
#2 {main}


Some members cannot view their pms. what to do next?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...