Loading...
 
Skip to main content

can't create new structure, because structlib has problem

Status
Closed
Subject
can't create new structure, because structlib has problem
Version
1.9.x
2.x
3.x
Category
  • Error
Feature
Wiki Structure (book & table of content)
Resolution status
Partially solved
Submitted by
datadev
Lastmod by
Xavi (as xavidp - admin)
Rating
(0)
Description

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

Field 'structure_id' doesn't have a default value

I check mySQL DB tiki_structure table, find the field 'structure_id' is not NULL,I check structlib.php,I find structlib.php not set the value of 'structure_id',only set 'parent_id',I guess that struclib.php have wrong.
structure is important feature ,wish to solve this problem


kerrnel22: Unable to reproduce this in 1.9.10.1 CVS ...are you running CVS or release package 1.9.x? Also unable to reproduce in 1.10.0b1 CVS ...same question, are you running CVS or release package 1.10.0b1? If you are running the package in either, then it may be that the bug has been fixed in a patch to the CVS tree and you may need to wait for the next beta release.


re kerrnel22:,i edit structlib.php line 202 :"$query = 'insert into `tiki_structures`(`parent_id`,`page_id`,`page_alias`,`pos`) values(?,?,?,?)';",to "$query = 'insert into `tiki_structures`(`structure_id`,`page_id`,`page_alias`,`pos`) values(?,?,?,?)'; ,then out tiki can run,and can create a new structure.

Files
  1. Structlib
Workaround

Use MySQL in non-strict mode.


-

Xavi: Please retest in Tiki 3.1+, since it works for me there.

Importance
7
Priority
35
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1649
Created
Friday 21 March, 2008 14:43:02 UTC
by Unknown
LastModif
Saturday 06 July, 2024 10:21:44 UTC


Show PHP error messages