Loading...
 
Skip to main content

Item Link & Time Sheet got System error.

  • Tracker item actions
Trackers
Items
Status
Open
Subject
Item Link & Time Sheet got System error.
Version
12.x
Category
  • Error
Feature
Trackers
Resolution status
New
Submitted by
Park JoonHyun
Lastmod by
Park JoonHyun
Rating
(0)
Description

After created trackers with Item Link fields, Time Sheet features got system error as follows;

Copy to clipboard
The following error message was returned:

 Incorrect integer value: '{"trackerId":2' for column 'trackerIdThere' at row 2
The query was:

INSERT INTO temp_tracker_field_options SELECT tiki_tracker_fields.trackerId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4 -1)) + 1 ), ',', ''), tiki_tracker_fields.fieldId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5 -1)) + 1 ), ',', ''), tiki_tracker_fields.type, tiki_tracker_fields.options FROM tiki_tracker_fields WHERE tiki_tracker_fields.type = 'l';
The built query was likely:

INSERT INTO temp_tracker_field_options SELECT tiki_tracker_fields.trackerId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 1 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 2 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 3 -1)) + 1 ), ',', ''), REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 4 -1)) + 1 ), ',', ''), tiki_tracker_fields.fieldId, REPLACE(SUBSTRING( SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5), LENGTH(SUBSTRING_INDEX(tiki_tracker_fields.options, ',', 5 -1)) + 1 ), ',', ''), tiki_tracker_fields.type, tiki_tracker_fields.options FROM tiki_tracker_fields WHERE tiki_tracker_fields.type = 'l';



In addition, I catched stacktrace...

Copy to clipboard
* /d1/scms/tiki12b/tiki-timesheet.php : 0 -> {main}(array ( ))
* /d1/scms/tiki12b/tiki-timesheet.php : 27 -> tracker(array ( ))
* /d1/scms/tiki12b/lib/core/Tracker/Query.php : 116 -> __construct(array ( ))
* /d1/scms/tiki12b/lib/core/Tracker/Query.php : 571 -> query(array ( ))
* /d1/scms/tiki12b/lib/core/TikiDb/Bridge.php : 27 -> query(array ( ))
* /d1/scms/tiki12b/lib/core/TikiDb/Pdo.php : 121 -> handleQueryError(array ( ))
* /d1/scms/tiki12b/lib/core/TikiDb.php : 148 -> handle(array ( ))


I hope it could be help to solve. If it need more, please let me know what to do next or action plan.

Importance
4
Easy to solve?
6
Priority
24
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
4977
Created
Sunday 24 November, 2013 12:14:48 UTC
by Park JoonHyun
LastModif
Wednesday 27 November, 2013 03:00:08 UTC


Show PHP error messages