Category: Trackers

see https://www.evernote.com/shard/s37/sh/21c2afa8-8a91-41bb-896e-278d2d33502d/e76c906c21c6743510dc7faf6948cced

experienced during submitting bug

When I use trackerfilter with the option sqlsearch in a wiki page to search a tracker it does not work as expected.

On PCs running Windows 7 and Windows 10 respectively. I can reproduce the problem in Tiki14.0 and 14.2 (both with MYSQL). In both versions there is no search box created on the wiki page with trackerfilter to enter the search string.

I have tested on the demo site and the versión 14.x demo site has the same problem.

Versión 12.x on the demo site does give a me a field to enter the search string, however, it appears to only search for the string in the first field and not in both fields.

To reproduce:
I created a Tracker with 2 fields ( "Name" a Text Field and "Description" a TextArea Field).

Then I créated a Wiki page with:
{trackerfilter filters="(1:2)/sqlsearch" displayList="y" noflipflop="y" trackerId="1" fields="1:2"}

In versión 14.x wiki page does not give área to enter search string.
In versión 12.x wiki page gives área to enter search string but search only appears to search first field regardless of field(s) requested. In my example there are two ítems. The word "Green" appears in ITEM1 field 2 and in ITEM2 field 1. If I search for Green only ITEM2 is listed (where Green appears in field1). If I search for "fruit" which appears in field 2 of both ítems there are no records found.
I understood that sqlsearch option should find the search string in any of the fields specified i.e. in my case "green" in field 1 AND/OR field2.

I have listed below:
tracker_1.csv to recreate the simple tracker used
itemId,status,created,lastModif,"Name -- 1","Description -- 2",
1,o,1453722833,1453722833,"Apple","A green or red fruit",
2,o,1453722869,1453722869,"Green","The color of some fruits",

I have uploaded the following images:
tiki14.png a screen shot showing the filter created which has no space to enter data in 14.x
tiki12.png a screen shot showing the filter created which has space to enter data in 12.x
tiki12_incorrect.png a screen shot showing how search does not opérate as I expected in 12.x only Ítem2 is listed and not Item1 despite the search string appearing in field 2 of first Ítem.

We have a tracker where we use a "Wiki page"-tracker-field.
This field uses as page name the results of a mathematical calculation tracker field, which inscludes a formula concatenating strings and tracker item id).
The mathematical calculation tracker field is set to calculate at save time (not at indexing time).

The error message when inserting a new tracker item seems to be related to the order, as if the results from the mathematical calculation field are not available for the wiki page tracker field when the new tracker item is being created:

{QUOTE()}
Error. Missing Page Name field #XX value for Wiki field #YY (so page not created)
{QUOTE}

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

This implies that if the user adds plenty of content (at tracker item creation time) to the text area of the wiki page field, that content is lost.

Wiki syntax is not enabled in Tracker comments on this site. May be usability bug in later Tiki versions.

After upgraded to 14.1, Wiki template page can not be applied as an input form in the PluginTracker. The error message shows "Missing template Name". But the same template while using in Plugin Trackerlist can display items and work fine. Does anyone have same problem? Or what setting I missed?
*My Plugin Tracker Setting
{img fileId="1007" thumb="y" rel="box[g]"}
*Tracker setting
{img fileId="1009" thumb="y" rel="box[g]"}
*Error while wiki template page used in PluginTracker as an input form: ~~#F06:Missed Template File~~
{img fileId="1008" thumb="y" rel="box[g]"}
*Work properly in PluginTrackerlist to display items.
{img fileId="1010" thumb="y" rel="box[g]"}

I've been trying to use trackertimeline in a wiki plugin alias and I cannot tell you why when I view the result it doesnt display as intented.

example: {CODE()}{TRACKERTIMELINE(lower="2011-03-22 07:00:00",upper="2011-03-22 17:00:00",(...))}{TRACKERTIMELINE}{CODE}

(like up here, but in a wiki-plugin alias)

would display a timeline that goes from 07:00 to 17:00 correctly. BUT. The elements in it, wont display in its proper place

example: An element has a start-time of 9h00 to 12h00

So, instead of placing it properly on the timeline, it will show it +/- 3hours later.

WHAT I CHECKED
* I checked if there is timezone problem in the phpinfo()
* I made sure that every fields were linking to the right tracker fields Id
* I made sure the format was fitting

When a wiki page is renamed, all links in Wiki pages are fixed. Excellent!

However, menu items are not updated. This would be a nice to have. Same thing for wikilinks in forum posts, trackers, etc

I guess it could get tricky because some use links like tiki-index.php?page=blabla, but some just but blabla and use the .htaccess

Update it is still here and visible at : https://dev.tiki.org/Tiki16

The page : https://dev.tiki.org/Tiki15 has autotoc showing:
• Begin Footnote Test
• Expected Result
• End Footnote Test
• N hours
• X

Those are nowhere to be found on the page BUT they are part of some tracker items within the plugin list that contain a wikiplugin to demonstrate a bug :
https://dev.tiki.org/item5760?highlight=Begin+Footnote+Test
https://dev.tiki.org/item5908?highlight=N hours

The TOC page consider it is part of the wiki page markup and is trying to do something with it.

This is a regression as it was not working that way not so long ago.

In WikiPluginTracker the confirmation message should have an option to send to any URL. That way, insted of having a confirmation message when the user click on send, he is send to another wiki page, etc where you can put the confirmation message you want. Because confirmation message may be more than one sentence, it may be very useful; and it open to the possibility to have another WikiPluginTracker on the second page... So you can have a tracker on multiple page.

__french__
Dans WikiPluginTracker, exemple la fonction qui permet d'afficher un texte comme message de confirmation devrait avoir une option de renvoyer vers une URL. De cette façon, l'utilisateur a plus de latitude sur la forme du message de confirmation. Surtout, il peut étaler un formulaire sur plusieurs pages wiki !

ex.:
TRACKER(trackerId=>4,fields=>13:14:15:16:17:18:19:20,url=>http://www.google.com)}{TRACKER

When you double clic in a text box in a wikiplugintracker, your send to /tiki-editpage.php?page=... This fonction sould be disable in wikiplugintracker.

The field "User Selector", "Header" and "email", "date and time", "JSCalendar" do not work with Wiki Plugin Tracker.

This is true also for "country", "date time". (Franck)

En remplaçant la fonction qui permet d'afficher un texte lorsque l'utilisateur enregistre le formulaire par un lien vers une page wiki, on aurait plus de lattitude sur la forme du message de remerciement et... en plus, on pourrait répartir les formulaires sur plusieurs pages.

ex.: au lieu d'avoir les wikiplugin comme ceci (avec le texte "Merci de votre contribution" indiqué dans le wiki plugin)
TRACKER(trackerId=>4,fields=>1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20,action=>youpi!)}Merci pour votre contribution !{TRACKER

on aurait ceci :

TRACKER(trackerId=>4,fields=>1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20,action=>youpi!)}NomDeLaPageWikiDeDestination{TRACKER

De cette façon, on peut indiquer le texte dans la page wiki de destination et, alternativement, répartir le formulaire sur plusieurs pages wiki !

Wildcard items feature was added in ((doc:Tii17)), using some new functionality added in "item link/items list" tracker fields.

You can see it reproduced in the show2 instance linked to this tracker item, setup with
https://profiles.tiki.org/Wildcard_items

Once you link trakcer items from tracker2 "projext tasks" with an item from tracker1 "projects" and save the item in tracker1, the pId is lost from the linked items in tracker2.

Reproduced here:
http://xavi-9794-7119.show2.tikiwiki.org/tiki-ajax_services.php?controller=tracker&action=update_item&trackerId=2&itemId=18&modal=1
u: admin
p: 12345

Once you clik at the "update" button, the numbers selected in the pID from tab 2 "2) Tasks and resources": Checklist of Project Tasks, get lost. And instead, they should be kept, and the selected items with wildcard should be converted (afair) to the pID from that item.


And when you create a new project, and select some wildcard-item project tasks from the list, after saving their pID don't get converted from wildcard to the project number (as they should), but they stay as asterisk.

A tracker has been categorized (using admin category add cat to the tracker). (16 = 2019)
The same tracker has a category field for the same category selection. (16 =2019 or 17 = 2020, radio button or dropdown)

On the item level, in the field category the tracker category is forced ''displayed'' even if it is not select in the field. While it make sense on the code/configuration level, it is pretty weird visually for the admin or the user.

In the screenshot below, all the items are categorized (17) 2020
But they show on the list both category (the one from the tracker (16) 2019, the one from the item field category (17) 2020.
{img fileId="1446" thumb="box"}

...

Couldn’t reproduce

On a tracker if you don’t use the "Status" display option you cannot use the "Delete" action at the bottom of the tracker item list.

Curiously, if I enable the status display option I can delete __once__ items using the "Delete" action but then it is broken again.

''As I don't remember using it before I can't say if this is a regression''. Not possible to create an instance (waited...)

When I try to delete items using the de delete item action from a plugin ListExecute (https://doc.tiki.org/PluginListExecute#delete) I have the following error:

Call to undefined method TikiAccessLib::checkCsrfForm()

{mediaplayer src="display2074"}

On Tiki 22 in a tracker you can add an "Add item" option to an Item Link field.
It will create a new item in the linked tracker.

Since Tiki22, the object is created properly but the item is not displayed correctly in the item link field list making impossible to create more than one.

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

https://share.vidyard.com/watch/h4zhUXx4MU7YEwpwe4x7ak?

I tried to reproduce on Show2 but for some reason adding an item doesn’t open a modal but open a new item creation (which is really bad). Default settings changed or... ?

On Tiki 21.x not all items are displayed using list or customsearch with filter.

In the instance I created items that are filtered "May" are not found when filtering for it.
(the field that contain "May" is a mathematical field that extract the month from the date of the item)
It was working fine but after updating the Tiki 21.x it showed up.

My best guess is that it is because of the word length. (I experiment changing different fields and see what work and what doesn’t).

I know there is a php search limit for 3 char (ft_min_word_len=3) that too I experimented to see if it move something. But changing my.cnf settings and restarting innoDB didn’t help.

I tested on my local mamp, my clearOs server and in show instance. They show the same issue (so I believe it comes from Tiki and not some server settings)

I change the value of the min word length as explained at : https://dev.mysql.com/doc/refman/5.6/en/fulltext-fine-tuning.html#fulltext-word-length
(I did for both innoDB and MySIAM)

Changes were applied after a restart as Tiki check confirmed:
{img fileId="1410" thumb="box"}
{img fileId="1411" thumb="box"}

I checked I have in my index existing values for May
{img fileId="1412" thumb="box"}

I tested with May and June and the plugin list debug tool:
{img fileId="1413" thumb="box"}
{img fileId="1414" thumb="box"}

Same item filter (and field) was changed to "May2020" and it worked fine.
{img fileId="1415" thumb="box"}
Still this is not a solution to hardcode the year with the month (all templates should be edited each year and they may be other implications).

On a Tiki24 I set a tracker with "Restrict non admins to wiki page access only".

Doing so, the item content is visible through plugins (like list and customSearch) for users with corresponding permissions.

However if I use the Tiki search (tiki-searchindex.php) in the results and in the Search control panel, search Items to display in search results, Default where, Entire site is enable anywone can see parts of the trackeritem content for this tracker.

Tiki Search is not a Wiki page, therefore it shouldn't display the items in a tracker where Restrict non admins to wiki page access only" is enable

On a tracker item with category field (multiselect) the admin can assign during the item creation different category to an item.

User with "Can admin categories (tiki_p_admin_categories)" and field editable perm can’t even see the categories.

I created an instance that show the issue.

!!!Update (27/07/2020)
It turns out that when you modify "this" tracker permission, the global permissions on "Can change the categories of an object (tiki_p_modify_object_categories)" won’t be applied and will be then "saved" disabled even if you didn’t change anything for it.

This is a bug. If you don’t change a perm for an object (in this case a tracker but it may be valid for any object) the global should keep being applied.

There is an error after saving an item in the tracker 5 (whishlist).

"preg_quote(): Argument #1 ($str) must be of type string, Math_Formula_Element given"

The ticket is saved.
Editing a ticket is ok (seems it happend only when saving a new ticket for the first time).

On a Tiki24 the since last visit new display the database value (code) for a multilingual tracker instead of the value expected for the actual selected language. I suspect a regression introduce by recent work on the module.

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

Reproduced here: http://bsfez-11581-8140.show2.tiki.org

Using ((doc:PluginTracker)) (with specific fields or not) and setting a itemId should load on the wiki page the fields with the existing values for this item. It was working fine on Tiki25.

I couldn't create a 26x show instance so I tested at: https://next.tiki.org/Test
With the following code:
{CODE()}{tracker trackerId="22" fields="147:204:149:155" itemId="6597"}{CODE}
Please not this code will be wiped by the process that updates tiki.org to next.tiki.org periodically.

{img fileId="2124" thumb="box"}
{img fileId="2125" thumb="box"}

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)