Project

General

Profile

Actions

Bug #26077

closed

Fallback to DELETE if TRUNCATE not allowed

Added by Noel Bossart about 13 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2011-04-18
Due date:
% Done:

0%

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

Description

We have an installation within a very restrictive security environment where the db-guys disabled truncate rights on the db. Now the clear-cache commands don't work. I suggest a fallback when TRUNCATE is not allowed and switch to DELETE...

Related Issue: http://forge.typo3.org/issues/17189


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #68734: Document required MySQL privileges in INSTALL.mdClosedMorton Jonuschat2015-08-04

Actions
Actions #1

Updated by Oliver Hader almost 13 years ago

  • Target version changed from 1061 to 1264
Actions #2

Updated by Christian Kuhn over 12 years ago

  • Category changed from Caching to Database API (Doctrine DBAL)

This should be changed in t3lib_db then, taking care of a truncate alternative is not domain of the caching classes.

Actions #3

Updated by Christian Kuhn over 12 years ago

  • Complexity set to medium
Actions #4

Updated by Oliver Hader over 12 years ago

  • Target version changed from 1264 to 1341
Actions #5

Updated by Ernesto Baschny almost 11 years ago

  • Target version deleted (1341)
Actions #6

Updated by Mathias Schreiber over 9 years ago

  • Target version set to 7.4 (Backend)
  • Is Regression set to No
Actions #7

Updated by Morton Jonuschat over 8 years ago

  • Status changed from New to Closed
  • Assignee set to Morton Jonuschat

Checking the current privileges on every call to TRUNCATE to determine if a fallback to DELETE is needed will not be implemented to solve a very specific edge case.
The required MySQL privileges for the database/user documented in the INSTALL file, TRUNCATE (DROP privilege) is a hard requirement.

Actions

Also available in: Atom PDF