Bug #9648
Phenomenon where all topics get deleted
| Status: | New | Start date: | 2010-09-08 | |
|---|---|---|---|---|
| Priority: | Must have | Due date: | ||
| Assignee: | - | % Done: | 0% |
|
| Category: | - | |||
| Target version: | - | |||
| Votes: | 1 (View) |
Description
Hi there
We encountered a weird phenomenon in one of our installations (TYPO3 4.4.0, mm_forum 1.9.0):
At random intervals all topic records got their tstamp set to the same value and deleted was set to 1.
These occurences were spaced sometimes a few days, sometimes a few weeks.
During the longer period we had the indexer cron deactivated.
The weird thing is, that the topics table is the only table affected and only tstamp (all records have the same tstamp) and deleted.
Also t3lib_db->UPDATEquery() is not invoked, so it must be a plain query.
I suspect some query is assembled faulty and no 'LIMIT 1' appended.
If you need more information please contact me directly.
Regards Nils
History
Updated by Martin Helmich over 2 years ago
- Status changed from New to Under Review
Updated by Willi Martens over 1 year ago
I have the same problem. (TYPO3 4.5.10, mm_forum 1.9.2)
Assumption: Maybe this problem is initated by the lowlevel_cleaner.
Updated by Willi Martens over 1 year ago
After switching on the sql-log found following query:
UPDATE tx_mmforum_topics SET tstamp='1329492953',deleted='1' WHERE shadow_tid=''
Most likely executed by the function saveAdminChange in pi1/class.tx_mmforum_postfunctions.php :
1054 $GLOBALS['TYPO3_DB']->exec_UPDATEquery('tx_mmforum_topics', 'shadow_tid = ' . $topicId, $updateArray);
I also found following SQL-Queries in the sql-log:
UPDATE tx_mmforum_topics SET deleted='1' WHERE uid='' UPDATE tx_mmforum_forums SET forum_posts = forum_posts-1 WHERE uid = ''
For me it looks like a bug in the moderation-module?!
Updated by Willi Martens over 1 year ago
- Status changed from Under Review to New