Categories feature enabled breaks database
- Status
- Closed
- Subject
- Categories feature enabled breaks database
- Version
- 3.x
- Category
- Error
- Usability
- Feature
- Database MySQL (MyISAM)
Category - Resolution status
- Fixed or Solved
- Submitted by
- Comnenus
- Lastmod by
- pkdille
- Rating
- Description
3.0 Beta 2:
After enabling the Categories feature through Admin -> Features, the following error occurs when adding or editing pages, articles, file galleries, and everything that needs to alter the database.
(Names are arbitrary)
An error occured in a database query!
Context:
File tiki-editpage.php
Url tiki-editpage.php
Query:
insert into `tiki_objects`(`type`,`itemId`,`description`,`name`,`href`,`created`,`hits`,`comments_locked`) values(?,?,?,?,?,?,?,?)
Values:
0 wiki page
1 sdf
2 sadfsa
3 sdf
4 tiki-index.php?page=sdf
5 1239375431
6 0
7 n
Message:
Unknown column 'comments_locked' in 'field list'
Built query was probably:
insert into `tiki_objects`(`type`,`itemId`,`description`,`name`,`href`,`created`,`hits`,`comments_locked`) values('wiki page','sdf','sadfsa','sdf','tiki-index.php'1239375431'page=sdf','0','n',?)- Solution
The problem was identified and solved. Please download and install 3.0 beta3. Everything should be ok.- Importance
- 9 high
- Priority
- 45
- 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
- 2409
- Created
- Friday 10 April, 2009 15:01:40 UTC
by Unknown - LastModif
- Sunday 12 April, 2009 19:05:04 UTC