Database error on saving wiki page (when categories/freetags are in use)
- Status
- Closed
- Subject
- Database error on saving wiki page (when categories/freetags are in use)
- Version
- 3.x
- Category
- Error
- Regression
- Feature
- All / Undefined
- Resolution status
- Fixed or Solved
- Lastmod by
- pkdille
- Rating
- Description
Database error as follows:
Context:
File tiki-editpage.php
Url tiki-editpage.php
Query:
insert into `tiki_objects`(`type`,`itemId`,`description`,`name`,`href`,`created`,`hits`,`comments_locked`) values(?,?,?,?,?,?,?,?)
Message:Unknown column 'comments_locked' in 'field list'
installer/schema/20090205_forum_and_comments_locking_tiki.sql appears not to be run on fresh install. This file was introduced in:
http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=rev&revision=17801
Shouldn't the filename be 20090405....? Is this the problem?
Also, is this related to http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=rev&revision=17919

- Solution
Temporary workaround is to execute sql command in:
installer/schema/20090205_forum_and_comments_locking_tiki.sql
manually on the database after installation
- Workaround
Fixed in r/17921. Fresh installs have now the missing column.
- Importance
- 9 high
- Priority
- 45
- 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 currently unavailableUnable to connect to show2.tiki.org. Please let us know of the problem so that we can do something about it. 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 currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 2411
- Created
- Saturday 11 April, 2009 02:12:48 UTC
by Unknown - LastModif
- Tuesday 09 June, 2009 20:34:41 UTC