Category: 12.x

Records are not found when using the trackerfilter plugin where the filter field is an ItemLink field where the contents are 'created' from multiple fields in the source tracker.

A 12.x 'show' has been set up to demo this bug - but it is also a problem in 13.x as well

---

Added quote below ({sign user="xavi" datetime="2014-04-30T09:30:43+00:00"}) as extra info was provided in the devel list:
{QUOTE()}
(...) definitely a regression as I have a production site where it used to work. I can't be sure when it stopped working but the site was built with 10.x so it was OK then and the site is now on a 11.x daily build from 4Sep'13 and it doesn't work anymore - only realised it when I used the site data to test the latest 12.x
{QUOTE}

{syntax type="tiki" editor="plain"}
The trackerfilter plugin has a 'filters' parameter with a /d option that allows a value to be selected from a drop down list so that all records with that value in the field are filtered out for presentation e.g a typical plugin might look like

~np~{trackerfilter filters="238/d" action="Create share holding report" noflipflop="y" trackerId="23" fields="238:244:240:241:242" compute="240/sum:242/sum" sort="y"}~/np~

But if field 238, as used in the example above, is an Item Link field the trackerfilter process does not find any records

This is a regression in both 11.x and 12.x but did work previously.


Other field types seem OK (although not tested them all !!!!)

{syntax type="tiki" editor="plain"}
I originally stated the popup did not display correctly. Now it does not display at all.

In the show.tiki instance there are 5 fields in the tracker.
Only the first is listed using PluginTrackerFilter. The remainder are set to be displayed in a popup. But the popup does not appear.

I added the show.tiki instance before discovering a similar item. I've set that item in the "related to" field. It states that if the fields to be popped up are already listed, then the popup works. I tested this by adding the fields in the tracker filter. It did not help, so I rolled back the change.

It was mentioned that there is no point in displaying something in a popup that is already listed. So I tested including all the fields in the listing and using a pretty tracker to only display one. It did work this way either. This is the page that uses a pretty tracker:
http://hrsms-11204-3728.show.tikiwiki.org/tiki-ndex.php?page=ListWithPrettyTracker

We can now have filters for content of fields, but list of columns is not dynamic

Suggested by Abdelhak Fareh (INESSS)

When using TrackerList compute function (sum of a column), sometimes it returns the number: 7.105427357601E-015

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

This is reported on several php forums and is not a bug but: "its the acceptable precision of floating point numbers" or also described as "Subtracting 2 floats returns incorrect results".

Seems that a workaround patch may be necessary as one post suggests:
"so I guess you need to hack it: if ($resultB < 0.000) $resultB = 0;"

Here are links:
http://forums.oscommerce.com/topic/199647-php-math-bug-big-problem/

https://bugs.php.net/bug.php?id=41213&edit=1

http://grokbase.com/t/php/php-bugs/074v5dv79q/41213-new-subtracting-2-floats-returns-incorrect-results

br,
Mike

If the field used for sort_mode is an item link, any initial selected results in zero items returned.

Steps to reproduce:

1) Create trackers:

Tracker "Names", id=1
Text Field "Name", id=1
Values:
"Fitzgerald,F. Scott" id=4
"Follett,Ken" id=5
"Grisham,John" id=6

Tracker "Titles", id=2
Text Field "Title", id=2
Values:
"Great Gatsby, The" id=1
"Dangerous Fortune,A" id=2
"Painted House, A" id=3

Tracker "Books", id=3
Item Link Field (2,2) "Title", id=3
Item Link Field (1,1) "Author", id=4
Values:
"Great Gatsby, The","Fitzgerald,F. Scott" id=7
"Dangerous Fortune,A","Follett,Ken" id=8
"Painted House, A","Grisham,John" id=9

2) Add trackerlist plugins to wiki

{CODE()}{trackerlist (trackerId=1, fields=1, showinitials=y, sort_mode=f_1_asc) /}

{trackerlist (trackerId=2, fields=2, showinitials=y, sort_mode=f_2_asc) /}

{trackerlist (trackerId=3, fields=3:4, showinitials=y, sort_mode=f_3_asc) /}{CODE}

3) Filter on "F" - you will see two authors and no titles or books (expected)
4) Filter on "G" - you will see one author, and one title, but no books. The book should have been listed also.

I did step (2) above on the home page of the show.tiki instance. To rule out interference between the 3 plugin instances on the same page, I also create separate wiki pages "Names", "Titles", and "Books" on the show.tiki instance. The behavior was the same.

You can see another example on our site:
http://www.hrsms.org/home/References

When trying to find a workaround, unexpected behavior was found in TrackerFilter. When the filter is 3/i (intials for title), clicking on a letter results in all titles with the letter anywhere in the string being returned. I would expect only those beginning with that letter. This has been added to the show instance to demonstrate.

Followed the steps described in : https://doc.tiki.org/PluginTrackerCalendar‎

However, the events (tracker items) do not get displayed on the Calendar, which is displayed by calling the TrackerCalendar plugin on a wiki page.

Tried the same thing on demo.tiki.org/tiki12 but got the same result.

{syntax type="tiki" editor="plain"}
Here is an example:
http://dev.tiki.org/Monitoring#Wishes

*Changing from empty to something doesn't go to the history
*Changing from something to something else does go to the history

Applying the profile "Tracker_as_calendar_12" with php 5.6 or php7.0 (on ubuntu 16.04 64 bits with mysql 5.7) produces this type of error:

{CODE()}
System error.

The following error message was returned:

Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tiki12svn_trackercalendar.ttif.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The query was:
SELECT tti.*, ttif.`value`, ttf.`type`, `lastModif` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=?) AND `ttif`.`fieldId` IN( ?,?,?,?,?,? ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc

Values:

1
o
p
1
2
3
4
5
6

The built query was likely:
SELECT tti.*, ttif.`value`, ttf.`type`, `lastModif` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) WHERE tti.`trackerId` = '1' and (`status`='o' or `status`='p') AND `ttif`.`fieldId` IN( '1','2','3','4','5','6' ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc

Stacktrace:
* /var/www/html/12.x/tiki-index.php : 0 -> {main}(array ( ))
* /var/www/html/12.x/tiki-index.php : 686 -> __toString(array ( ))
* /var/www/html/12.x/lib/core/Tiki/Render/Lazy.php : 22 -> call_user_func:{/var/www/html/12.x/lib/core/Tiki/Render/Lazy.php:22}(array ( ))
* /var/www/html/12.x/lib/core/Tiki/Render/Lazy.php : 22 -> {closure:/var/www/html/12.x/lib/wiki/renderlib.php:331-341}(array ( ))
* /var/www/html/12.x/lib/wiki/renderlib.php : 334 -> get_parse(array ( ))
* /var/www/html/12.x/lib/wiki/wikilib.php : 488 -> parse_data(array ( ))
* /var/www/html/12.x/lib/tikilib.php : 386 -> parse_data(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1589 -> parse_first(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 476 -> plugin_execute(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1018 -> wikiplugin_tabs(array ( ))
* /var/www/html/12.x/lib/wiki-plugins/wikiplugin_tabs.php : 84 -> parse_data(array ( ))
* /var/www/html/12.x/lib/tikilib.php : 386 -> parse_data(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1589 -> parse_first(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 476 -> plugin_execute(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1018 -> wikiplugin_trackerlist(array ( ))
* /var/www/html/12.x/lib/wiki-plugins/wikiplugin_trackerlist.php : 1692 -> list_items(array ( ))
* /var/www/html/12.x/lib/trackers/trackerlib.php : 1274 -> fetchAll(array ( ))
* /var/www/html/12.x/lib/core/TikiDb/Bridge.php : 32 -> fetchAll(array ( ))
* /var/www/html/12.x/lib/core/TikiDb/Pdo.php : 109 -> handleQueryError(array ( ))
* /var/www/html/12.x/lib/core/TikiDb.php : 148 -> handle(array ( ))

{CODE}

Same profile applied on older mysql (5.6) and older svn revision works as expected. Reproduced here:
https://demo.tiki.org/12x/tiki-index.php?page=Tracker_as_Calendar_12
u: admin
p: 12345

Just try to log in.

I made a video in case...

There was a typo introduced in a commit made on Aug. 15, 2014 to the file ~/lib/trackers/trackerlib.php
I noticed that the latest commit had broken our Tracker plugin on a couple of our pages, and after doing some digging, found that a typo in a variable had been introduced.

In the code:

if (! $skip_permission_check) {
$itemObject = Tracker_item::fromInfo($res);
if (! $itemObject->canView()) {
$cant--;
continue;
}
}

On line 1291, the variable 'Tracker_item' should in fact be 'Tracker_Item' , with a capital I in Item.

Star name was forgotten in code at the last release:
http://sourceforge.net/p/tikiwiki/code/HEAD/tree/branches/11.x/lib/setup/twversion.class.php#l31

If this is useful, it should be indicated in ((Releasing)). If not useful, it should be removed from the code.

Update email in mail notifications list when email replaced in user account

I did change my email in my account settings at t.o. That email was transfered to dev.t.o properly.
And my mail notifications in t.o where updated properly. __However, the mail notifications in the slave sites (from the same intertiki network) did not get updated__

{CODE()}Version 12.0svn is no longer supported. A minor upgrade to 12.0 is required.{CODE}

{img fileId="691"}

upgrade all databases in a multitiki installation in a single go with console.php

with some param like "--site=all":
{CODE()}
php console.php d:u --site=all
{CODE}

We are still at 2.25:
http://sourceforge.net/p/tikiwiki/code/46914/tree/trunk/composer.json#l14

The updated zip is at:
http://codemirror.net/codemirror-3.16.zip

Check http://branding.tiki.org/ vs http://nextbranding.tiki.org/

{img fileId="855"}

https://nextbranding.tiki.org/tiki-admin.php reports
{img fileId="856"}

{kaltura id="1_5ahsbgoc"}

While navigating galleries in Finder View the URL does not change. The impact of this is selecting "Edit Gallery" will result in editing the gallery identified by the out-of-date URL, and not the currently view gallery. Easily missed, resulting in editing the wrong gallery.

{syntax type="tiki" editor="plain"}
When we create a new wiki page we write {CODE()}((My New Page)){CODE} and get the URL http://example.com/My+New+Page

Is it possible to get the following URL structure

http://example.com/my-new-page

i.e. all lower case and hyphens "-" instead of plus sign "+" ?
Thank you

At this condition,
* Enabled Time Sheet feature
* Apply Time Sheet profile
* Add tracker fields of URL or Items List to the Time Sheet tracker.

And I click the TimeSheet link, I got the following pattern of error messages;

{CODE(caption="System error" wrap="1")}The following error message was returned:

Incorrect integer value: '{"linkToURL":1' for column 'trackerIdThere' at row 1
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';
{CODE}

{syntax type="tiki" editor="plain"}
New users are kind of lost in the process of creating a new tracker from scratch.
After they hit on save the form of the new tracker details, they are shown:
tiki-admin_trackers.php?trackerId=N

(being N the new tracker Id)

Instead, it would be much easier for tiki newbies (or even for everybody?) if they were autoomagically sent to
tiki-admin_tracker_fields.php?trackerId=N

Because it's not intuitive (from the newbie point f view) to know what to do from that interface with so many links at the moment when the new tracker has been created.
---
UPDATE: Still desirable in Tiki 12 LTS for usability for new users. {sign user="xavi" datetime="2013-11-17T09:43:36+00:00"}

A lot of work done here:
http://framework.zend.com/manual/1.12/en/zend.currency.html

Global permissions:

tiki_p_assign_perm_file_gallery
tiki_p_admin_file_galleries
all groups = OFF

Created users "A" and "B"
Created group "GroupA" of which "A" is a member
Created group "GroupB" of which "B" is a member

Created category "UserACat"
Permissions for category "UserACat":

tiki_p_add_object
GroupA = [ON]
GroupB = [OFF]
tiki_p_remove_object
GroupA = [ON]
GroupB = [OFF]
tiki_p_modify_object_categories
GroupA = [ON]
GroupB = [OFF]

With these settings, "A cannot set the category of the gallery because that is done by selecting the "Edit Gallery" button, which is not activated. To activate this:

tiki_p_admin_file_galleries
GroupA = [ON]
GroupB = [OFF]

Now the "Edit Gallery" is activated, but so is the "Permissions" button, despite the fact that tiki_p_assign_perm_file_gallery is [OFF]

Update:
In the tiki show instance, when the user clicks the Permission button, it says the user does not have permission to set permissions. I do not get this message in my actual tiki installation - the user can set permissions. I'll investigate further. However, if they don't have permission, I think the button should not be there.

Update:
Attempted workaround by setting "GroupACat" for the "Default category assigned to uncategorized objects edited by a user with this default group" option for "GroupA".

I presumed that every forum post, every file uploaded, every "everything else" would be categorized. That seems excessive, and would create a lot of garbage in the database. I do what this for new file galleries created by user "A". However, when the user creates a new file gallery, it is not assigned "UserACat". So this approach will not work.

You can set a tracker to hold more user information.
On the tiki preferences (tiki-user_preferences.php) it will set a link "User's personal tracker information: View extra information".

With tiki in english the link will go to the user (latin-char or non-latin-char) i'm look at.
If the Tiki is set to multilingual the link is broken and will show my own (admin for example) information.