Loading...
 
Skip to main content

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
(0)
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 clipboard
Warning: 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+
Please demonstrate your bug on show2.tiki.org
Demonstrate Bug (older Tiki versions)
Ticket ID
498
Created
Wednesday 01 February, 2006 01:27:41 UTC
by Unknown
LastModif
Tuesday 16 January, 2007 10:26:16 UTC


Collapse/expand modules below
Show PHP error messages