error if inserting tracker item from wiki plugin (simple tracker)
- Status
- Closed
- Subject
- error if inserting tracker item from wiki plugin (simple tracker)
- Version
- 1.9.x
- Category
- Error
- Feature
- Database MySQL (MyISAM)
Trackers - Resolution status
- Works For Me
- Submitted by
- Xavi (as xavidp - admin)
- Lastmod by
- Xavi (as xavidp - admin)
- Rating
- Description
I created a tracker with several fields, mainly rating, textareas, dropdown, user selector, date selector.
Id position name type options isMain Tbl vis Searchable Public Hidden Mandatory 291 0 Rating system -2,-1,0,1,2 - y - y - - 293 edit 20 Descricpión de la incidencia textarea 1,60,5,1000 y y y y n y remove 294 edit 21 TipologÃÂa de redacción colaborativa drop down elegir uno,documentos de ofimática solo... n y y y n y remove 295 edit 22 Comentarios textarea 1,60,5,1000 n y y y n n remove 297 edit 27 Dia jscalendar n y y y n n remove 296 edit 30 Informante user selector 1 n y y y n n remove
Called all fields from a wiki TRACKER plugin (the data field and user selector are not shown through plugin, even if configured as "public"), and submit some data (required and visible fields).Then I got this error:
Copy to clipboardWarning: mysql error: Duplicate entry '240-296' for key 1 in query: insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?) in /var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikidblib.php on line 134 Context: File /tiki-index.php Url /tiki-index.php?trackit=10&page=prova&refresh=1&track%5B293%5D=prueba&track%5B294%5D=Wiki&track%5B295%5D=prueba&authorfieldid=296&track%5B296%5D=Xavi&action=Envia-ho Query: insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?) Values: 0 240 1 296 2 Xavi Message: Error Message Duplicate entry '240-296' for key 1 array(6) { [0]=> array(6) { ["file"]=> string(65) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikidblib.php" ["line"]=> int(84) ["function"]=> string(9) "sql_error" ["class"]=> string(10) "trackerlib" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &string(80) "insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?)" [1]=> &array(3) { [0]=> int(240) [1]=> int(296) [2]=> string(4) "Xavi" } [2]=> &bool(false) } } [1]=> array(6) { ["file"]=> string(75) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/trackers/trackerlib.php" ["line"]=> int(619) ["function"]=> string(5) "query" ["class"]=> string(10) "trackerlib" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(80) "insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?)" [1]=> &array(3) { [0]=> int(240) [1]=> int(296) [2]=> string(4) "Xavi" } } } [2]=> array(6) { ["file"]=> string(87) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/wiki-plugins/wikiplugin_tracker.php" ["line"]=> int(69) ["function"]=> string(12) "replace_item" ["class"]=> string(10) "trackerlib" ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> &string(2) "10" [1]=> ∫(0) [2]=> &array(1) { ["data"]=> array(6) { [0]=> array(3) { ["fieldId"]=> int(293) ["value"]=> string(6) "prueba" ["type"]=> int(1) } [1]=> array(3) { ["fieldId"]=> int(294) ["value"]=> string(4) "Wiki" ["type"]=> int(1) } [2]=> array(3) { ["fieldId"]=> int(295) ["value"]=> string(6) "prueba" ["type"]=> int(1) } [3]=> array(3) { ["fieldId"]=> int(296) ["value"]=> string(4) "Xavi" ["type"]=> int(1) } [4]=> array(4) { ["fieldId"]=> string(3) "296" ["value"]=> string(4) "Xavi" ["type"]=> string(1) "u" ["options"]=> int(1) } [5]=> array(2) { ["fieldId"]=> bool(false) ["value"]=> string(5) "prova" } } } [3]=> &string(1) "o" } } [3]=> array(4) { ["file"]=> string(63) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikilib.php" ["line"]=> int(4117) ["function"]=> string(18) "wikiplugin_tracker" ["args"]=> array(2) { [0]=> &string(156) "Formulari per informar d'incidències durant la redacció colaborativa de la "Guia Erasmus", segons la tipologia de redacció colaborativa emprada" [1]=> &array(7) { ["trackerId"]=> string(2) "10" ["fields"]=> string(23) "291:293:294:295:297:296" ["action"]=> string(8) "Envia-ho" ["showtitle"]=> string(1) "y" ["showdesc"]=> string(1) "y" ["showmandatory"]=> string(1) "y" ["embedded"]=> string(1) "y" } } } [4]=> array(6) { ["file"]=> string(63) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikilib.php" ["line"]=> int(4399) ["function"]=> string(11) "parse_first" ["class"]=> string(7) "tikilib" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &string(752) "{img src="img/wiki_up/Categories-ADMIN-001.png" } img src="img/wiki_up/Categories-ADMIN-001.png" {TRACKER(trackerId=>10,fields=>291:293:294:295:297:296,action=>Envia-ho,showtitle=>y,showdesc=>y,showmandatory=>y,embedded=>y)}Formulari per informar d'incidències durant la redacció colaborativa de la "Guia Erasmus", segons la tipologia de redacció colaborativa emprada{TRACKER} {TRACKERLIST(trackerId=>10,fields=>291:293:294:295:297:296,showtitle=>y,showlinks=>y,showdesc=>y,showinitials=>y,showstatus=>n,status=>opc,sort_mode=>asc,max=>3,filterfield=>294,filtervalue=>documentos de ofimática solo acesibles en local,exactvalue=>)}Notice{TRACKERLIST}" [1]=> &array(2) { ["data"]=> array(0) { } ["key"]=> array(0) { } } [2]=> &array(2) { ["data"]=> array(0) { } ["key"]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(62) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/tiki-index.php" ["line"]=> int(401) ["function"]=> string(10) "parse_data" ["class"]=> string(7) "tikilib" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(752) "{img src="img/wiki_up/Categories-ADMIN-001.png" } img src="img/wiki_up/Categories-ADMIN-001.png" {TRACKER(trackerId=>10,fields=>291:293:294:295:297:296,action=>Envia-ho,showtitle=>y,showdesc=>y,showmandatory=>y,embedded=>y)}Formulari per informar d'incidències durant la redacció colaborativa de la "Guia Erasmus", segons la tipologia de redacció colaborativa emprada{TRACKER} {TRACKERLIST(trackerId=>10,fields=>291:293:294:295:297:296,showtitle=>y,showlinks=>y,showdesc=>y,showinitials=>y,showstatus=>n,status=>opc,sort_mode=>asc,max=>3,filterfield=>294,filtervalue=>documentos de ofimática solo acesibles en local,exactvalue=>)}Notice{TRACKERLIST}" [1]=> &string(1) "0" } } }- Solution
- it seems to work already
- Importance
- 5
- Priority
- 25
- 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
- 498
- Created
- Wednesday 01 February, 2006 01:27:41 UTC
by Unknown - LastModif
- Tuesday 16 January, 2007 10:26:16 UTC