Project

General

Profile

Actions

Defect #4048

closed

Index revision incorrect

Added by James Turnbull over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database
Target version:
-
Start date:
2009-10-18
Due date:
% Done:

0%

Estimated time:
Resolution:
Cant reproduce
Affected version:

Description

The missing index revision - http://www.redmine.org/projects/redmine/repository/revisions/2928 - the wiki_pages migration specified the parent_id column which does not exist in this table.

Actions #1

Updated by Eric Davis over 14 years ago

  • Status changed from New to Closed
  • Assignee set to Eric Davis
  • Resolution set to Cant reproduce

James,

wiki_pages does have a parent_id column. It was added in migration 95 for #528. Can you check if that migration was applied to your Redmine?

mysql> describe wiki_pages;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| id         | int(11)      | NO   | PRI | NULL    | auto_increment | 
| wiki_id    | int(11)      | NO   | MUL | NULL    |                | 
| title      | varchar(255) | NO   |     | NULL    |                | 
| created_on | datetime     | NO   |     | NULL    |                | 
| protected  | tinyint(1)   | NO   |     | 0       |                | 
| parent_id  | int(11)      | YES  | MUL | NULL    |                | 
+------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
Actions

Also available in: Atom PDF