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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 1946
- Created
- Friday 08 August, 2008 21:39:10 GMT-0000
by Unknown - LastModif
- Saturday 08 April, 2017 16:15:30 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Should the CSS and JS source maps be part of Git? Part of the released version?
- Tracker properties, Status; Inconsistantcy between display preferences and status options
- Files; Values in Maximum width / height of images for a file gallery can to chain of errors and corrupt image files
- Slideshow; Content is not displayed the same depending on the browser used (content may be truncated)
- Wiki page; Being able to save editing but staying in edit mode will help when creating (long) content
;){kind=link}
;){kind=link}