Upgrade to Tiki4: You can't specify target table 'tiki_file_galleries' for update in FROM clause
- Status
- Closed
- Subject
- Upgrade to Tiki4: You can't specify target table 'tiki_file_galleries' for update in FROM clause
- Version
- 4.x
5.x - Category
- Error
- Feature
- File Gallery (elFinder or standard UI)
- Resolution status
- Invalid
- Submitted by
- Marc Laporte
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
- Copy to clipboardUPDATE `tiki_file_galleries` SET `parentId` = (SELECT * FROM (SELECT `galleryId` FROM `tiki_file_galleries` WHERE `type` = 'system') AS t) WHERE `parentId` = -1 AND `type` != 'system' You can't specify target table 'tiki_file_galleries' for update in FROM clause
Suggestion: use php for this, and rely less on sqlhappened on MySQL 4.1.22-standard
- Solution
- Workaround
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3000
- Created
- Thursday 21 January, 2010 21:55:32 UTC
by Marc Laporte - LastModif
- Monday 01 June, 2026 18:01:40 UTC