marklcfc Posted January 14, 2023 Posted January 14, 2023 (edited) Is this an official IPS table or related to the member map mod I used to use a few years ago? I'm guessing its part of IPS due to the name of the table having 'core' in it. I am seeing these errors a bit so I thought I'd ask REPLACE INTO `ibf_core_item_member_map` (map_member_id, map_item_id, map_latest_date, map_class) SELECT DISTINCT `author_id`, `topic_id`, UNIX_TIMESTAMP(), 'IPS\\forums\\Topic' FROM `ibf_forums_posts` AS `forums_posts` WHERE ( queued IN(0,2) ) AND ( topic_id IN(125376) ) IPS\Db\Exception: Deadlock found when trying to get lock; try restarting transaction (1213) #0 /home/**/public/system/Db/Db.php(972): IPS\_Db->preparedQuery() #1 /home/**/public/system/Node/Statistics.php(295): IPS\_Db->replace() #2 /home/**/public/system/Node/Statistics.php(76): IPS\forums\_Forum->rebuildPostedIn() #3 /home/**/public/system/Node/Statistics.php(160): IPS\forums\_Forum->authorsPostedIn() #4 /home/**/public/system/Helpers/Table/Content.php(499): IPS\forums\_Forum->contentPostedIn() #5 /home/**/public/system/Helpers/Table/Table.php(494): IPS\Helpers\Table\_Content->getRows() #6 /home/**//public/applications/forums/modules/front/forums/forums.php(568): IPS\Helpers\Table\_Table->__toString() #7 /home/**/applications/forums/modules/front/forums/forums.php(38): IPS\forums\modules\front\forums\_forums->_forum() #8 /home/**/public/system/Dispatcher/Controller.php(118): IPS\forums\modules\front\forums\_forums->manage() #9 /home/**/public/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #10 /home/**/public/index.php(13): IPS\_Dispatcher->run() #11 {main} Edited January 14, 2023 by marklcfc
Randy Calvert Posted January 14, 2023 Posted January 14, 2023 I don't use the member map application, and that table exists for me.
Daniel F Posted January 14, 2023 Posted January 14, 2023 This is a IPS core database table! (In theory, any table starting with core or YOURPREFIX_core belongs to the core! 🙂 That's also why we're trying to enforce that plugins have their own database table prefix instead of using core/forum/downloads/etc...
Recommended Posts