26783[BUGFIX] Missing column sys_file.fileinfo
Commit message
Review
-
Code review CR 0
-
Verified V 0
Issues 1
Files 2
Review log 21
-
Oliver Klee commented on patch set 1 01/13/14, 13:09
QueryView.php:509Can't we use some of the native PHP array functions for this? -
Mr. Jenkins commented on patch set 1 01/13/14, 13:16
Build Successful https://ci.typo3.org/job/typo3-v4-core-gerrit/12940/ : SUCCESS -
Steffen Ritter commented on patch set 1 CR -1 01/13/14, 13:16
the current implementation will slow down thing way more than it helps; please consider a more performant implementationQueryView.php:508this will do an extra query for each table... please think about introducing that for "multiple tables" at once -
Oliver Klee commented on patch set 1 01/13/14, 13:18
QueryView.php:508Reply… or we cache the fields for each table, e.g., in a static property. -
Oliver Klee commented on patch set 1 01/13/14, 13:19
Or maybe the search should use only TCA columns that have certain (whitelisted) types that always will exist in the DB. -
Stefano Kowalke uploaded patch set 2 01/13/14, 14:31
-
Mr. Jenkins commented on patch set 2 01/13/14, 14:43
Build Successful https://ci.typo3.org/job/typo3-v4-core-gerrit/12947/ : SUCCESS -
Oliver Klee commented on patch set 2 01/13/14, 15:05
QueryView.php:499No abbr, pls. "stmt" is nt vry rdbl. -
Stefano Kowalke uploaded patch set 3 01/13/14, 18:22
-
Mr. Jenkins commented on patch set 3 01/13/14, 18:34
Build Successful https://ci.typo3.org/job/typo3-v4-core-gerrit/12957/ : SUCCESS -
Alexander Opitz commented on patch set 3 CR -1 01/14/14, 09:49
The SQL Statement is MySQL/PostgreSQL specific. "The Oracle equivalent for information_schema.COLUMNS is USER_TAB_COLS for tables owned by the current user, ALL_TAB_COLS or DBA_TAB_COLS for tables owned by all users." See also: http://stackoverflow.com/questions/8739203/oracle-query-to-fetch-column-names -
Georg Ringer commented on patch set 3 CR -1 01/14/14, 10:09
this makes everything slower. If the query fails, show an error and it must be fixed in install tool with a compare or whatever. don't hide the problems which shouldn't be there -
Alexander Opitz commented on patch set 3 01/14/14, 10:14
@Georg This isn't for hiding database fields which should be added by install tool. This is for "virtual fields", fields that are used in the TCA but don't need any database field. -
Stefano Kowalke commented on patch set 3 01/16/14, 13:24
@Alexander: So its better to introduce a new method in DatabaseConnection to be able to use DBAL to translate this to other DBMS? @Georg: Its exactly like Alexander says. Its not a field which should add to the table. -
Alexander Opitz commented on patch set 3 01/16/14, 14:30
@Stefano: I donÄt know what the best way is and who is responsible for DBAL. Maybe Ernesto knows whom to ask for this issue. -
Xavier Perseguers commented on patch set 3 01/17/14, 13:25
Hi, you need this: https://review.typo3.org/#/c/3997/ -
Stefano Kowalke commented on patch set 3 01/18/14, 15:58
Thanks Xavier for having a look on it. Your mentioned PatchSet is about removing it from ext:dbal but its abandoned. In Forge I found this [1] issue doing nearly the same beside other stuff. Was this issue simply forgotten? Its better to update the issue and get this into the core and dbal? [1] http://forge.typo3.org/issues/23051 -
Xavier Perseguers commented on patch set 3 01/19/14, 15:23
@Stefano, this is related, the ticket you mentioned needed a cached version of the columns. The abandonned patch was about moving the logic from DBAL where it had been initially developped to the Core to have it for MySQL as well. -
Steffen Ritter commented on patch set 3 06/11/14, 11:56
why don't we use admin_get_fields() ?? -
Xavier Perseguers commented on patch set 3 CR -2 06/11/14, 12:17
This is a no-go in this form as it does not use a DBAL-compatible way to retrieve the list of columns. IIRC I pointed you to the Core method to be used. -
Georg Ringer abandoned the change 12/07/14, 18:12
has been resolved with #63273
QueryView.php:507