Loading...
 
Skip to main content

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
(0)
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=17801Question

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=17919Question

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+
Demonstrate Bug (older Tiki versions)
Ticket ID
2411
Created
Saturday 11 April, 2009 02:12:48 UTC
by Unknown
LastModif
Tuesday 09 June, 2009 20:34:41 UTC


Show PHP error messages