7.0b2 Error trying to validate newly uploaded file draft
- Status
- Closed
- Subject
- 7.0b2 Error trying to validate newly uploaded file draft
- Version
- 7.x
- Category
- Error
- Regression
- Less than 30-minutes fix
- Feature
- File Gallery (elFinder or standard UI)
- Resolution status
- Fixed or Solved
- Submitted by
- nethog
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
Uploaded a new version of a file.
Clicked "verify" option
Was prompted to confirm.After clicking confirm, got the following error:
System error.
The following error message was returned:
Unknown column 'fileId' in 'where clause'
The query was:
SELECT * FROM `tiki_file_galleries` WHERE 1=1 AND `fileId` = ?
Values:
1.1The built query was likely:
SELECT * FROM `tiki_file_galleries` WHERE 1=1 AND `fileId` = '1'- Solution
In lib\filegals\filegallib.php
In function validate_draftNote line:
$filesTable = $this->table('tiki_file_galleries');This should be:
$filesTable = $this->table('tiki_files');- Workaround
- See solution
- Importance
- 8
- Easy to solve?
- 8
- Priority
- 64
- 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
- 3898
- Created
- Monday 23 May, 2011 04:09:04 UTC
by nethog - LastModif
- Tuesday 30 June, 2026 22:01:14 UTC