TYPO3 Forger
  • Dashboard
  • Get involved
  • Reviews
    Overview Ready for review Work in progress Needs action Needs review Needs verification Needs rebase Negative votes Reviewed and verified Ready to merge
  • Issues
    Stale issues Possible duplicates By category By month
  • Sprints
    Overview Initiatives TYPO3 Core Review board
  • Tools
    Backports ReST helper
  • Help
  • Search
  • Login
Esc

Words find the open ones, a number the issue and the change with it.

  1. Issues
  2. #67155
Issue Bug Closed

#67155Invalid SQL Query for sys_categories

Morton Jonuschat 05/26/15, 21:24 updated 10/02/18, 11:44

Open in Forge Comment in Forge

Description

DBAL/AdoDB Error message:

#1421053336: ADOdb could not run this query: SELECT "uid" FROM "sys_category" WHERE FIND_IN_SET('0', "parent") != 0 OR "parent" = ''

Environment: TYPO3 7.3-dev, PostgreSQL 9.4

How to reproduce: Open the „Backend User Listing” and try to add a new account.

Reviews 2

  • TYPO3_6-2 41842[BUGFIX] dbal: Cast field to CHAR for FIND_IN_SET() Resolves this issue Merged Morton Jonuschat CR +2 V +2 → main, 6.2 Normal +122 −10 07/22/15, 18:23
  • main 39779[BUGFIX] dbal: Cast field to CHAR for FIND_IN_SET() Resolves this issue Merged Morton Jonuschat CR +2 V +2 → 6.2 issue/67155 Normal +97 −9 07/22/15, 16:50

Related issues 3

  • Bug #46271DB-error with postgreSQL Related to Closed v7 Gerald Buttinger 03/14/13, 13:14
  • Epic #64459Make TYPO3 run on PostgreSQL Related to Closed Mathias Schreiber 01/23/15, 21:05
  • Bug #67172AdoDB error on editing a page Related to Closed Database API (Doctrine DBAL) v7 alexis nicolas 05/27/15, 16:55
Author
Morton Jonuschat
Priority
Should have
Category
Database API (Doctrine DBAL)
TYPO3 version
7
PHP version
5.6
© 2026 TYPO3 GmbH.
  • API
  • Privacy Policy
  • Legal Notice
  • Feedback