Error creating group
- Status
- Closed
- Subject
- Error creating group
- Version
- 3.x
- Category
- Error
- Feature
- Group
- Resolution status
- Fixed or Solved
- Submitted by
- crisse
- Lastmod by
- pkdille
- Rating
- Description
When I try to create new group I receive this error from MySQL:
Error
An error occured in a database query!Context:
File tiki-admingroups.php
Url tiki-admingroups.php
Query:
insert into `users_groups` (`groupName`, `groupDesc`, `groupHome`,`groupDefCat`,`groupTheme`,`usersTrackerId`,`groupTrackerId`, `registrationUsersFieldIds`, `userChoice`, `usersFieldId`, `groupFieldId`) values(?,?,?,?,?,?,?,?,?,?,?)
Values:
0 ffff
1
2
3 0
4
5 0
6 0
7
8
9
10
Message:
Incorrect integer value: '' for column 'usersFieldId' at row 1
Built query was probably:
insert into `users_groups` (`groupName`, `groupDesc`, `groupHome`,`groupDefCat`,`groupTheme`,`usersTrackerId`,`groupTrackerId`, `registrationUsersFieldIds`, `userChoice`, `usersFieldId`, `groupFieldId`) values('ffff',,,'0',,'0','0',,,,'')- Solution
Fix the default values in add_goup in the userslib.php.
It's done in r19412 for trunk and proposed in r19413 for future Tiki v 3.1. This release should occur in the next days.
You can fix by yourself by applying that patch
Thanks for the bug report.
- 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
- 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 currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 2467
- Created
- Tuesday 28 April, 2009 11:37:38 UTC
by Unknown - LastModif
- Wednesday 10 June, 2009 19:59:01 UTC