Structure creation fails
- Status
- Closed
- Subject
- Structure creation fails
- Version
- 2.x
- Category
- Error
- Feature
- Wiki Structure (book & table of content)
- Resolution status
- Fixed or Solved
- Submitted by
- PaulN
- Lastmod by
- Xavi (as xavidp - admin), lindon
- Rating
- Description
Tring to create a structure results in the error:
An error occured in a database query!Context:
File tiki-admin_structures.php
Url tiki-admin_structures.php
Query:
insert into `tiki_structures`(`parent_id`,`page_id`,`page_alias`,`pos`) values(?,?,?,?)
Values:
0 0
1 2
2 Test Structure
3 1
Message:
Field 'structure_id' doesn't have a default value
Built query was probably:
insert into `tiki_structures`(`parent_id`,`page_id`,`page_alias`,`pos`) values('0','2','Test Structure','1')If the process is repeated the error thrown is different: 1 page not added (Exists)
Found with clean installs of 2.0RC4 on Windows Server 2003 x32 and also server 2008 x64. PHP 5.2.6 (x32); MySQL 5.0.51b (x32 and x64); Apache 2.2.9 (x32)
- Solution
Modified tiki_structures.structure_id to allow NULL values.
Assume this issue is closed given lack of response. Please open a new ticket on a supported version if issue still exists.
- Workaround
Xavi (Jan 15th, 2009):
- Works for me. Changed status to "pending"
- Please retest on current stable branch 2.x.
- Thanks in advanced for reporting it.
- Importance
- 7
- Priority
- 35
- 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 not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. 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 not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 1946
- Created
- Friday 08 August, 2008 21:39:10 UTC
by Unknown - LastModif
- Saturday 08 April, 2017 16:15:30 UTC