Loading...
 
Skip to main content

Cannot add new page to Structure

Status
Closed
Subject
Cannot add new page to Structure
Version
1.9.x
Category
  • Error
Feature
Wiki (page view, edit, history, rename, etc)
Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)
Wiki Structure (book & table of content)
Resolution status
Fixed or Solved
Submitted by
HamletCygar
Volunteered to solve
HamletCygar
Lastmod by
Beestje
Rating
(0)
Description

When trying to add a new page to an existing structure I got the following error:

Field 'structure_id' doesn't have a default value


I could correct this very simply by going into the MySQL administrator and changing that column to have a default value of 0. I guess this is just that the DB set up SQL is incorrect and needs to have default value added to that column. I used the update SQL from 1.8 to 1.9 to create this tikiwiki so I guess that is the SQL that would need to be changed. I have not tested the new clean DB install of 1.9.

Cheers Mike

Solution

Xavi (Jan 15th, 2009):

  • Works for me.
  • Please retest on current stable branch 2.x.
  • Thanks in advanced for reporting it.

Beestje(Apr 21st, 2009)

  • Works for me on 1.9.11
  • Works for me on 2.2 and 2.1
  • Closing Bug
Importance
7
Priority
35
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1019
Created
Tuesday 20 February, 2007 11:43:58 UTC
by Unknown
LastModif
Tuesday 21 April, 2009 10:36:22 UTC


Show PHP error messages