Loading...
 
Skip to main content

editing a tracker field with perms on view and edit yields mysql error

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
editing a tracker field with perms on view and edit yields mysql error
Version
2.x
Category
  • Error
Feature
Trackers
Submitted by
Xavier de Pedro
Lastmod by
sylvie greverend
Rating
(0)
Description

Using tiki 2.1

Attempting to edit a tracker item,
the "field is hidden" option has specified viewable and editable for group editors, only. I want to change that setting to a "viewable only by creator and admin", and set the other two multiselect fields, left as blank (selecting the first option wich is blank), but I get this error on save:

Copy to clipboard
Context:
File	tiki-admin_tracker_fields.php
Url	tiki-admin_tracker_fields.php
Query:
update `tiki_tracker_fields` set `name`=? ,`type`=?,`isMain`=?,`isSearchable`=?, `isTblVisible`=?,`isPublic`=?,`isHidden`=?,`isMandatory`=?,`position`=?,`options`=?,`isMultilingual`=?, `description`=?, `itemChoices`=?, `errorMsg`=?, visibleBy=?, editableBy=? where `fieldId`=?
Values:
0	Correu-e
1	m
2	n
3	n
4	n
5	y
6	c
7	y
8	29
9	1
10	n
11	
12	
13	
14	
15	
16	59
Message:
Unknown column 'Array' in 'field list'
Built query was probably:
update `tiki_tracker_fields` set `name`='Correu-e' ,`type`='m',`isMain`='n',`isSearchable`='n', `isTblVisible`='n',`isPublic`='y',`isHidden`='c',`isMandatory`='y',`position`='29',`options`='1',`isMultilingual`='n', `description`='', `itemChoices`='', `errorMsg`='', visibleBy='Array', editableBy='Array' where `fieldId`='59'


the url is:
http://www.moviments.net/cursos/tiki-admin_tracker_fields.php?trackerId=4&max=100&sort_mode=position_asc&fieldId=59Question

Solution
backported in tw 2 - revision 15622.
Importance
6
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2140
Created
Tuesday 11 November, 2008 10:52:42 UTC
by Unknown
LastModif
Wednesday 12 November, 2008 13:06:28 UTC


Show PHP error messages