Project

General

Profile

Actions

Bug #68464

closed

TYPO3 uses id for wrong table

Added by Kornexl Anton over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2015-07-22
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Typo3 uses id (19681 here) from pages-table and updates the tt_content-table with same id.
I have shortened the record titles in the following excerpt.
(see 9:40:34 and 9:40:39, 9:40:43 and 9:41:09)

09:41:09 ze@LIVE DB Move Moved record 'Wirt.-...' (pages:19681) on page 'Forschungsschwerpunkte' (19623) (msg#1.4.4)
09:41:09 ze@LIVE DB Update Record 'Prüfungen' (tt_content:19681) was updated. (Online). (msg#1.2.10)
09:41:09 ze@LIVE DB Update Record 'Prüfungen' (tt_content:19681) was updated. (Online). (msg#1.2.10)
09:40:43 ze@LIVE DB Update Record 'Wirt.-...' (pages:19681) was updated. (Online). (msg#1.2.10)
09:40:39 ze@LIVE DB Move Moved record 'Wirt.- ...' (pages:19681) from page 'CEP' (19621) (msg#1.4.3)
09:40:39 ze@LIVE DB Move Moved record 'Wirt.-...' (pages:19681) to page 'Forschungsschwerpunkte' (19623) (msg#1.4.2)
09:40:39 ze@LIVE DB Update Record 'Prüfungen' (tt_content:19681) was updated. (Online). (msg#1.2.10)
09:40:39 ze@LIVE DB Update Record 'Prüfungen' (tt_content:19681) was updated. (Online). (msg#1.2.10)
09:40:34 ze@LIVE DB Update Record '...' (pages:19681) was updated. (Online). Changes in fields: title. (msg#1.2.10)
09:39:41 ze@LIVE DB Update Record '...' (pages:19681) was updated. (Online). Changes in fields: title. (msg#1.2.10)
09:39:36 ze@LIVE DB Insert Record '...' (pages:19681) was inserted on page 'CEP' (19621) msg#1.1.10)

The tt_content record is associated with a page (6559) the user has no access to.
He can't update this page and the content on this page.

The effect of this wrong update was a disorder of the CEs on the containing page(6559).

Maybe the installed php-suhosin disturbed the request.


Files

19803.mysqlbinlog (2.9 KB) 19803.mysqlbinlog mysqlbinlog-entries at the time of the problem Kornexl Anton, 2015-08-13 14:52
Actions

Also available in: Atom PDF