Upgrade to Tiki4: You can't specify target table 'tiki_file_galleries' for update in FROM clause
- Status
- Open
- 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)
- Submitted by
- Marc Laporte
- Lastmod by
- Marc Laporte
- Rating
- Description
UPDATE `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
- Importance
- 9 high
- Priority
- 45
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 3000
- Created
- Thursday 21 January, 2010 21:55:32 GMT-0000
by Marc Laporte - LastModif
- Thursday 21 January, 2010 22:06:21 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Tracker properties, Status; Inconsistantcy between display preferences and status options
- Files; Values in Maximum width / height of images for a file gallery can to chain of errors and corrupt image files
- Slideshow; Content is not displayed the same depending on the browser used (content may be truncated)
- Wiki page; Being able to save editing but staying in edit mode will help when creating (long) content
- Accessibility; Adding accessibility tools to Tiki
;){kind=link}
;){kind=link}