Category: Trackers

Due to (I guess) change in the calculation field, the if condition or the way the index is rebuilt a previous condition to perform a calculation stopped to work and interfere with the rebuild index operation.

{CODE(caption="calculation that doesn't work")}
(if timeworkDateIn (round (div (sub timeworkDateOut timeworkDateIn) 3600)1))
{CODE}

The "if" here was checking if there is a value in the field "timeworkDateIn" to avoid a different error (Divide by zero on "0") that was displayed to the visitor of the site. After I upgrade this Tiki20 to Tiki21 I got an error on rebuild index:
{CODE()}
[root@server html]# php console.php i:r --log
[04-03-2020 09:48] Started rebuilding index... logging to file: /tmp/Search_Indexer_mysql_tsaharoniki_tiki21_console.log
Unified search engine: MySQL, version 10.1.44-MariaDB
error: The search index could not be rebuilt.
Variable not found "timeworkDateIn".
.../...
2020-03-04T09:48:36+02:00 INFO (6): addDocument trackeritem 53 {"memoryUsage":"22.3 MiB"}
(where it stopped)
{CODE}

I found a workaround see below, but we should have a way to keep it as is or to better verbose so the admin knows what to do.

{FADE(label="Long story" icon="y")}
I have a field that calculate time from 2 dates field to set a work clock.
Worker enter when he come to work and when he get out.
The calculation is done on save so data are updated constantly and the user can see results in real time.

{img fileId="1374" thumb="box"}

It was working fine on Tiki20.

Since I upgraded to Tiki21 it has stopped to work.
(on the sample a new employee entered 3 row after the Tiki was upgraded)
{img fileId="1375" thumb="box"}

@Roberto: I think we have similar case setup as we worked together on some solution for a "Tiki" company :-) but else I can provide playground to help.

!!!Update1
I got an error on rebuild index:
{CODE()}
[root@server html]# php console.php i:r --log
[04-03-2020 09:48] Started rebuilding index... logging to file: /tmp/Search_Indexer_mysql_tsaharoniki_tiki21_console.log
Unified search engine: MySQL, version 10.1.44-MariaDB
error: The search index could not be rebuilt.
Variable not found "timeworkDateIn".
.../...
2020-03-04T09:48:36+02:00 INFO (6): addDocument trackeritem 53 {"memoryUsage":"22.3 MiB"}
(where it stopped)
{CODE}

trackeritem 53 is an old work clock item (closed).
The calculation was ok and all field looked ok.
I edited and saved and had the following error:
{CODE()}
The search index could not be updated. The site is misconfigured. Contact an administrator.
Variable not found "timeworkDateIn".
{CODE}

The field is here and the permaname is correct:
{img fileId="1376" thumb="box"}

Retested on the same Tiki still on version 20 (I kept for test) and there it is working fine.
(calculaltion are made, indexing is ok)

I escalated the bug to upgrade blocker.
If something corrupt a working index or block Tiki from indexing then it just kill the website (IMO).

!!!Update2
Above I see that the operation stopped very early, trackeritem 53 (I have more than 1500 trackeritems).
It stopped because it couldn’t find the field "timeworkDateIn" during a calculation.

I have 2 calculation field that use the same field "timeworkDateIn"
If I keep the first one and remove the second it work:
{CODE(caption="First calculation")}
(concat (date (str F) (str-to-time (str +0 day) timeworkDateIn)) (str |) timeworkName)
{CODE}

{CODE(caption="second calculation that doesn't work")}
(if timeworkDateIn (round (div (sub timeworkDateOut timeworkDateIn) 3600)1))
{CODE}

I reworked the code starting by the smallest value and up till the complete formula;
From: (sub timeworkDateOut timeworkDateIn)
To: (if (IsEmpty timeworkDateIn) NA (round (div (sub timeworkDateOut timeworkDateIn) 3600)1))
{FADE}

When I export and import Tracker fields, all of the values are works well except some of features. That is Permissions value of "Visible by" or "Editable by" in Tracker fields are not exported or imported well.

As I have tested, it does not work in Tiki 11 or 12, and doesn't know the above versions are works well or not.

I have been worked export and import Trackers in production. When I doing this, I have to update the permissions values manually every time. It is an tiresome job for me as you may know.

Is there any other good idea?
Or is it an excluded feature in Tracker export? If it is, could you enable the feature?

Thanks,
Joon

{syntax type="tiki" editor="plain"}
When I create a tracker, say trackerId=6, and populate it with a few items in a fieldId, say fieldId=10, and then go to a different tracker, say trackerId=7 and create a field of type "Item Link", with options 6,10 it works as I would expect. In particular, I am presented with a drop-down of the items in tracker 6, field 10. If I save an item using this drop-down in tracker 7 and try to then edit that item, the drop-down is blank.
In summary, the tracker type "Item Link" works as I would expect when adding items to a tracker, but does not work when attempting to edit the items in a tracker. When editing, the drop-down is blank.

While creating a new tracker in 1.10 error occurring.

An error occured in a database query!

Context:
File tiki-admin_trackers.php
Url tiki-admin_trackers.php
Query:
insert into `tiki_trackers`(`name`,`description`,`descriptionIsParsed`,`created`,`lastModif`) values(?,?,?,?,?)
Values:
0 daaku
1
2 NULL
3 1213325032
4 1213325032
Message:
Unknown column 'descriptionIsParsed' in 'field list'
Built query was probably:
insert into `tiki_trackers`(`name`,`description`,`descriptionIsParsed`,`created`,`lastModif`) values('daaku','',NULL,'1213325032','1213325032')

In database couldn't find 'descriptionIsParsed' field. Is it missed ?

A tracker is used for the contact form at tiki.org. Normally when somebody leaves a message, the tracker item can be edited, like to change the status and make a comment, but currently (Aug. 3 2020), when I click save (or preview) the form just refreshes with its original content -- no edits saved. I haven't checked if this happens at Tiki instances other than tiki.org.

{img src=https://dev.tiki.org/tiki-download_item_attachment.php?attId=567}

Once you have related something using a Relations field (or I imagine any other ways you can relate objects) you cannot remove the last related object, only change it to something else.

We had a similar issue with category checkboxes a while ago, it's because once none of the checkboxes are checked the request doesn't contain anything of that -+name+- so the field doesn't get updated.

Note: This for me is when the number of possible results is more than tiki_object_selector_threshold and the objects are shown as checkboxes - but others report it works ok... hmmm {sign user="jonnybradley" datetime="2019-05-07T14:59:15+00:00"}

I edited several items in the tracker 24.
But I couldn’t save edit on this item : https://tiki.org/item10362 (They should be some restriction to view this tracker as it is not public)

I tried several times, refreshed several times (MacOSX, Safari and Chrome):
{img fileId="1238" thumb="box"}

I can’t upload a thumbnail at :https://doc.tiki.org/item2737#contenttabs_view_tracker_item-2

{img fileId="1292" thumb="box"}

I retried and refresh the page several times.

{syntax type="tiki" editor="plain"}
With elFinder enabled attaching as file to a tracker items doesn't work and fails silently (but sometimes you get "File #1550620800 missing (was attached to trackerfield "picture" on item example title".

Seems ok (but ugly) without elFinder.

Reproduced on https://trunkdev.tiki.org/tracker10 - can't find nextdev to try it on 30.x (well, dev.tiki.org live site is already on 30.x {sign user="luci" datetime="2026-07-10T10:42:03+00:00"}) but it also fails on my locals.

--It seems the function -+addFile+- is no longer being called and I suspect {mr id=7598} may have been involved...-- correction, {mr id=6530} seems more likely (so it's been broken for over a year?) - maybe not either of these then...

This is the case even if {if $tracker_info.showStatus eq 'y' or ($tracker_info.showStatusAdminOnly eq 'y' and $tiki_p_adm
in_trackers eq 'y')} is true.

In order to fix this I can think of 2 options:

option 1) have the status selector there in the edit/insert popup.

option 2) have on the tracker item view screen another button to toggle the status, depending on the perms the user has. Surely the user should only be able to change the status to statuses he has perms to view, right?

I actually like option 2 as it provides a separate tracker status switcher apart from the editing but that's just my opinion.

Clicking "Create" button brings up pop-up which is lower z-index and thus unclickable than the grayed overlay. Clicking anything closes it again. Unable to create new tracker manually. Seen in FF.
{img fileId="955" thumb="y" rel="box[g]" width="640"}

When nesting pretty trackers inside a wiki page, the trackerlist for the inside pretty tracker should be able to accept "metadata" from the outside pretty tracker, specially {$f_itemId}, to use as a filtervalue for the inside pretty tracker.

However this results in the following error:
trackerlist: Pretty tracker reference "$f_itemId" could not be replaced in plugin "trackerlist".

This is true with all of the pretty tracker "metadata" such as:
{$f_created}
{$f_status_input}
{$f_status}
{$f_itemId}
{$f_lastmodif}
{$itemoff}
{$tr_offset}

Note that items such as {$f_xx} where xx is the field id and items such as {{page}} work correctly. The issue seems to be limited to using the pretty tracker "metadata" inside the trackerlist of the inside pretty tracker.

An outline:

Three trackers: one for Movies, one for Actors, and one for Cast using two "Item link" fields to link movies and actors.

Three Pretty Trackers: one for Movies, one for Actors, and one for Cast

Wiki page for "Raiders of the Lost Ark":
- Calls trackerlist using the Pretty Tracker for Movies with page=view to show details for this specific movie such as release date, studio, poster, etc.

Wiki page for "Harrison Ford":
- Calls trackerlist using the Pretty Tracker for Actors with page=view to show details for this specific actor such as birth date, birth place, etc.

Pretty Tracker for Movies:
- Contains a trackerlist using the Pretty Tracker for Cast that should have filterfield="xx" where xx is the Item Link field for the Movies tracker and filtervalue={$f_itemId}

Pretty Tracker for Actors:
- Contains a trackerlist using the Pretty Tracker for Cast that should have filterfield="yy" where yy is the Item Link field for the Actors tracker and filtervalue={$f_itemId}


Using the {$f_itemId} in the Pretty Trackers results in the error:
trackerlist: Pretty tracker reference "$f_itemId" could not be replaced in plugin "trackerlist".



Workaround:

Make both the Cast fields Page Selectors and use either filtervalue={$f_xx} or filtervalue={{page}}

It works, but this approach loses the relational benefits of using Item Link. Also, instead of using drop down selectors to select the Movie and Actor for the Cast tracker, the names themselves are required to be typed in, which can be cumbersome and error prone.


Setting "Importance" to 8 based on multiple discussions of nested pretty trackers over the past 7 years:
https://tiki.org/forumthread63281
https://tiki.org/forumthread61654
https://tiki.org/forumthread60207
http://tikiwiki.1073613.n5.nabble.com/Nested-trackerlists-td18465.html

And also this reported bug: https://dev.tiki.org/item5084

Additionally, I believe this simple fix would greatly enhance the possibilities for Mediawiki-type of infoboxes, such as outlined here: https://dev.tiki.org/item1843

Setting "Easy to solve?" to 8 based on the idea that it should be fairly simple to solve since the Pretty Tracker already allows {$f_xx} and {{page}} etc., it's just a matter of including the "metadata" fields into that group.

We have a registered user X with right tiki_p_modify_tracker_items.
X tries to update a field using the tracker wiki plugin, and fails.
"You do not have permission to modify an item"
Please review my correction proposal. I am rather new with both php and TW.

Have an issue which is not consistent across all of my trackers, but appears in those most recent, ie. within last year. Although the View all trackers lists all items, when an individual tracker item is selected, nothing is showing on the view tab, but you can see the information when selecting the edit tab. Example at [http://cytopathnet.org/tiki-view_tracker.php?trackerId=3|CLIA Forum-CYTOPATHNET ].

Please advise me on how to create a nice tracker comment section as it is here for this tracker. The way I used to do it in 6.x is not working in 18.3

tiki-view_tracker_item.php?trackerId=1&itemId=2534

does not show the comments
under some config it shows a tabs with the number of comments, but when clicking the tab it is empty

if I get it right
tiki_tracker_comments got moved to tiki_comments
and the old interface
$trklib->replace_item_comment etc
got removed

anyway, the new way is fine with me (seems like an improvement to me), just would you give me a pointer how to do it?

Please see:
http://www.seomoz.org/blog/canonical-url-tag-the-most-important-advancement-in-seo-practices-since-sitemaps

tiki-print.php -> tiki-index.php

In trackers, if you find a tracker item following a search, you have some parameters in the URL for item 6 of 70. The canonical format should be just the tracker item.

In blogs,
tiki-send_blog_post.php?postId=xyz
and
tiki-print_blog_post.php?postId=6079
should be:
tiki-view_blog_post.php?postId=xyz

Hello. Hope you're doing well.
I'm encountering an issue when i click on a tracker (from tracker list) and im getting a blank page. or whenever i click to view or edit tracker.

On inspect element (network) the GET request for the tracker have a 500 status every time i click on a tracker.

Or else, new ones are added at the bottom and it looks bad.

probably related to #283

When trying to use a tracker category field as a filter, only the value "Any" is displayed.

I would like to take work from my users (so basically myself) and categorize automagically.

I am thinking of some kind of

Type: Category
Options: parentId, 1

where 1 would mean to automatically check all check-boxes.
Then I'd make the field invisible and mandatory(is that needed any more) and voila - no one realized you got some more metadata.. ;)

{syntax type="tiki" editor="plain"}
See the attached word document for a step-by-step example of how
to recreate this issue.

It is also unclear how to created nested categories by using
the "Batch Upload (CSV File)" feature.

-----------------------------------------
When a category is more than one-level deep, the "Category" field type on Trackers will only display one level.

Example:

Furniture Level 1
_________|__________
| | |
Tables Chairs Sofas Level 2
__________| __|___ ___|_____
| | | | | |
legs top legs back cloth leather Level 3

In the above example, if one selects the parent id corresponding
to "Level 2" in the above example, then the category field only
contains choices "Tables, Chairs, Sofas", rather than those choices,
plus the levels below them (i.e. "legs, top, legs, back, cloth, leather").

It could be very useful to have all levels starting with a given "parent" level as part of the Category field.

{syntax type="tiki" editor="plain"}
Filtering by category in trackers yields zero results. However, there are tracker items in the category, and they appear if you browse the category. Other filtering appears to work properly.

The URL appears to be malformed:


Note the extra bracket after filtervalue[33] parameter.
http://www.casesofinterest.com/tiki/tiki-view_tracker.php?trackerId=7&status=o&sort_mode=lastModif_desc&filterfield=33&filtervalue[31]=&filtervalue[32]=&filtervalue[49]=&filtervalue[47]=&filtervalue[41]=&filtervalue_other=&filtervalue[35]=&filtervalue[33][]=102&filtervalue[40]=&filtervalue[34]=&filtervalue[45]=&filter=Filter

However, manually removing the extra bracket also fails:
http://www.casesofinterest.com/tiki/tiki-view_tracker.php?trackerId=7&status=o&sort_mode=lastModif_desc&filterfield=33&filtervalue[31]=&filtervalue[32]=&filtervalue[49]=&filtervalue[47]=&filtervalue[41]=&filtervalue_other=&filtervalue[35]=&filtervalue[33][]=102&filtervalue[40]=&filtervalue[34]=&filtervalue[45]=&filter=Filter

Using 1.10cvs code from mid june 2007

I created several trackers. Enabled RSS for individual trackers. Created rss modules for two individual trackers (rss 1 and rss 2).
Granted common permissions for anon. (view, ...), and most tracker permissions for Registered group.

Added a call to rss plugin within a wiki page:
{CODE()}
{rss id=1}

{rss id=2}
{CODE}

When viewing the page as registered, I see:

^
Tiki RSS Feed Error Message: Permission denied you cannot view this section
^

Did I miss any special perm to be granted for registered? A bug?

(I granted all perms from tracker section - to them, or inherited from anonymous - except for tiki_p_admin_tracker)