Bug #82105

Bookmarking a file leads to SQL error

Added by Oliver Hader over 2 years ago. Updated about 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Backend User Interface
Target version:
-
Start date:
2017-08-15
Due date:
% Done:

100%

TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

If bookmarking a file in the file > filelist module, reloading the whole backend fails with an SQL error:
An exception occurred while executing 'SELECT `uid`, `pid`, `file:type`, `t3ver_state` FROM `sys_file_metadata` WHERE `uid` IN (?)' with params [417]: Unknown column ‘file:type’ in ‘field list

How to reproduce:
  • open filelist module
  • edit an existing file
  • click the bookmark icon (the star a the top right)
  • reload the whole backend
  • see the SQL error

Associated revisions

Revision 29f6093e (diff)
Added by Wouter Wolters about 2 years ago

[BUGFIX] Fix SQL error when bookmarking a sys_file_metadata record

The type field contains a non existing field. Do not select this
field in the query.

Resolves: #82105
Releases: master, 8.7, 7.6
Change-Id: I9840712f4f87135740512ddf91a2b921b2515612
Reviewed-on: https://review.typo3.org/53710
Tested-by: TYPO3com <>
Reviewed-by: Andreas Fernandez <>
Tested-by: Andreas Fernandez <>
Reviewed-by: Sascha Egerer <>
Tested-by: Sascha Egerer <>
Reviewed-by: Christian Kuhn <>
Tested-by: Christian Kuhn <>

Revision 4d103fe5 (diff)
Added by Wouter Wolters about 2 years ago

[BUGFIX] Fix SQL error when bookmarking a sys_file_metadata record

The type field contains a non existing field. Do not select this
field in the query.

Resolves: #82105
Releases: master, 8.7, 7.6
Change-Id: I9840712f4f87135740512ddf91a2b921b2515612
Reviewed-on: https://review.typo3.org/53746
Reviewed-by: Oliver Hader <>
Tested-by: TYPO3com <>
Reviewed-by: Christian Kuhn <>
Tested-by: Christian Kuhn <>

Revision 79ced4a4 (diff)
Added by Wouter Wolters about 2 years ago

[BUGFIX] Fix SQL error when bookmarking a sys_file_metadata record

The type field contains a non existing field. Do not select this
field in the query.

Resolves: #82105
Releases: master, 8.7, 7.6
Change-Id: I9840712f4f87135740512ddf91a2b921b2515612
Reviewed-on: https://review.typo3.org/53747
Reviewed-by: Oliver Hader <>
Tested-by: TYPO3com <>
Reviewed-by: Christian Kuhn <>
Tested-by: Christian Kuhn <>

History

#1 Updated by Gerrit Code Review over 2 years ago

  • Status changed from New to Under Review

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53710

#2 Updated by Gerrit Code Review over 2 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53710

#3 Updated by Gerrit Code Review about 2 years ago

Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53746

#4 Updated by Wouter Wolters about 2 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100

#5 Updated by Gerrit Code Review about 2 years ago

  • Status changed from Resolved to Under Review

Patch set 1 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53747

#6 Updated by Wouter Wolters about 2 years ago

  • Status changed from Under Review to Resolved

#7 Updated by Benni Mack about 1 year ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF