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
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
- 2467
- Created
- Tuesday 28 April, 2009 11:37:38 UTC
by Unknown - LastModif
- Wednesday 10 June, 2009 19:59:01 UTC