Category: 21.x

When I configure Tiki with User Tracker, I can set «Tracker field IDs to sync the "real name" pref from» in tiki-admin.php?page=login

This is ignored. No synchronization happens.

The recent prefs menu on the Quick Admin module is always empty now

To reproduce:
* Admin registers a new user, with confirm email and change password checked (as is typical)
* User clicks on confirmation email link
** User sees change password form
* User closes password form
* User click links again and sees "you have already validated your email" message
* User doesn't know the previous password and isn't offered the change password form again

---
p.s. there is a similar issue if you fail to match the two passwords

{syntax type="tiki" editor="plain"}
In order to make show*.t.o servers more sustainable (in terms of disk-space consumed by show*.t.o instances), a suggestion was fired in the [https://tiki.org/Roundtable-Meeting-2020-09|TRM of September 2020]]: once a bug report is closed, then "the system" could delete the tiki file tree linked to that bug report. Mysql db could be kept, but the many hundreds of Mb in current tiki versions from the file tree on disk could be removed to respect disk resources & availability for new show*.t.o instances.

Example: show2.t.o currently consumes something like 10 new Gb per month, due to the instances being created by users.

Reordering of menu options is not working.
The menu entries can be dragged, but will not be rearranged.

This is happening with newly created and already existing menu items.

Here is documentation about emoticons / smileys: https://doc.tiki.org/Smileys

I suggest replacing current emoticons in tiki with the natively supported emoji. The emoticons currently displayed in tiki currently look dated. The menu may be best replaced by a basic emoji menu, and have the unicode inserted directly into tiki pages.

The feature that replaces text emoticon representations with the picture based emoticons could also be changed to output the unicode emoji.

Replacing with emoji not only brings a facelift to tiki, but also has the potential of reducing tiki parser reliance-time, allows people to use emoji they are use to, and will help to optimize page load time.

Emoji is now supported in every browser we support with the exception of IE 9. ( currently holding 0.3% of popular use) http://caniuse.com/usage-table

All modern browsers/ OS's support color emoji. Legacy browsers (like IE 10 @ 0.27% usage) support non-colour emoji.

Presuming we are talking about Emoji support as outlined in Unicode 6, excluding the flag implementation, support is very good.

There are libraries available that use js or php to replace the unicode emoji with a standard svg library, such as http://emojione.com/developers/, but with such good support already it may not be worth implementing this, as long as we stick to Unicode 6 emoji.

I furthermore suggest that the emoji button on the edit page be removed altogether on mobile devices in favor of the built in emoji support. Desktop emoji still requires a tiki emoji menu IMHO.

This all of course hinges on the emoji bug: https://dev.tiki.org/tiki-view_tracker_item.php?itemId=6189 being fixed.

I would like to have someone develop a resource checkout system. This could be for a small library of books, videos, etc. or other resource that people can check out (company van, etc.).

Admin Side:
* Category admin
* Resource admin
* Users admin
* Inventory status (what is checked out, what is in stock etc.)
* Users who currently have the item
* Checkout length admin (custom settings by item, or blanket timeframe, or no checkout length)

User Side:
* List of items available (categorized by type: videos, books, tapes, etc.)
* List of items you are on the waiting list for
* Your position in the list (You are 3rd in line for this item)

Automatic Pieces:
* User notification of an item coming due / past due
* User notification that the item they were waiting for has been checked back in.


This might also be able to be expanded to serve as a rental pool with just a little extra work.

Related:
((Marketplace))
((Shopping Cart))

After editing an item in this tracker, i’m not enable anymore to save a tracker item and a comment (Save and Comment) or to save and go back to the list (Save Returning to Item List) using the buttons in the dev Wish List using Safari on OSX. (may mean doesn’t work on Iphone too)

Work on Chrome.

It seems that the greater the number of users exist in the wiki, tied with a higher total score per user, generates very slow queries to the database, resulting in a very slow load time per page. I was experiencing 20 seconds + of load time per wiki page, as it was loading the scoring table every time.

Some samples from the database (not sure if useful).


# Time: 170131 16:54:54
# User@Host: giswikiadm[giswikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 334497
# Query_time: 28.076675 Lock_time: 0.000208 Rows_sent: 10 Rows_examined: 4229506
SET timestamp=1485899694;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344609
# Query_time: 21.994789 Lock_time: 0.000448 Rows_sent: 10 Rows_examined: 3325313
SET timestamp=1485955286;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:21:56
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344614
# Query_time: 22.215687 Lock_time: 0.000448 Rows_sent: 10 Rows_examined: 3325313
SET timestamp=1485955316;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:22:42
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344620
# Query_time: 21.846001 Lock_time: 0.000245 Rows_sent: 10 Rows_examined: 3325313
SET timestamp=1485955362;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:23:33
# User@Host: citypediaadm[citypediaadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344638
# Query_time: 12.665043 Lock_time: 0.000552 Rows_sent: 10 Rows_examined: 2035464
use citypediap1;
SET timestamp=1485955413;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:23:44
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344639
# Query_time: 22.066348 Lock_time: 0.000236 Rows_sent: 10 Rows_examined: 3325313
use eiadwikip1;
SET timestamp=1485955424;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:23:52
# User@Host: citypediaadm[citypediaadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344642
# Query_time: 13.027229 Lock_time: 0.000440 Rows_sent: 10 Rows_examined: 2035464
use citypediap1;
SET timestamp=1485955432;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;

Under TikiWIki 21(.2) only the page title is displayed in the search results list, but no longer text in the content section.
See also the forum post: https://tiki.org/forumthread75156-Search-content-section-is-empty

We tested once in the demo area on tiki.org.
There, pages with Lorem ipsum content were created and then we searched for Lorem.
All pages were listed as results but no content was displayed.

In the local test with newly created databases with TikiWiki 18.2 and TikiWiki 21.2, the text content appears under 18.2 but under 21.2 a number instead:

Even rebuilding the search index does not change this.

Example Link:
http://webclassix-12006-7532.show2.tikiwiki.org/tiki-searchindex.php?filter%7Econtent=lorem&sort_mode=score_ndesc
{img fileId="1447" thumb="box"}

Site with content:
http://webclassix-12006-7532.show2.tikiwiki.org/tiki-index.php?page=testpage&highlight=lorem
{img fileId="1448" thumb="box"}

At the File Gal UI, when you search for a file name (search string "foo", file name "my foo file") you get no results if the file is in a child file galery and not in the top one (file gal 1).

If you go to the child file gallery, and search again, you will find the file. But the problem is in production sites, with many files in many file galleries, and someone wants to replace a file with a new version of that file, you need to find where that file is, and most users look for file name strings in the search box to find files in the File Gallery UI (new users don't search for file id, which would work, but that is another story).

If you search the same string in the tiki search module (using unified search index) against object type "files", then you find that file with no problems.

So apparently, the search form in the file gallery when you are in th etop file gallery should include by default all child file galleries to get the expected results (oh well, this is just an educated guess)

FYI

P.S: We are not using elfinder since it was affected by other CSRF bugs, and afaik, you can't replace a file with a new version while keeping the same file id, throgh elfinder UI.

P.S.S: The CSRF bugs should be fixed now with {commit id="70908"}{sign user="lindon" datetime="2019-11-10T18:20:03+00:00"}

Share feature was enabled. Unified search index rebuilt (or at least intended to do so, through tiki control panel)
I attempted to share one page with myself to double check a report with Share feature when perspectives were used, and I saw that it seems to be a broken feature in t.o for unknown reasons.
Example:
https://tiki.org/tiki-share.php?url=%2F202002-TAG-Meeting%3Fpage_ref_id%3D1328
I typed one or several emails, selected the options
* "Share access rights"
* "Receive notifications when the link is accessed"
and set
* Token Access Limit: 5

Send email: yes
(all other action buttons set to "no"), and I get at the top: "undefined"
No email is received by recipients.

t.o seems to currently run on:
Last update from SVN (21.0vcs): Sunday 15 March 2020 17:41:50 CET - REV 75908 (MyISAM)

((doc:Share feature)) allows access 1 time less than value set in threshold.

Tested with sharing access 3 times to 2 users (sharing object perms), and it could only be viewed twice by each user.

Attempted to get it reproduced in a show2.t.o instance.

http://xavidp-1553-7326.show2.tikiwiki.org/
u: admin
p: 12345

Applied the company intranet profile. Enabled the share feature, and I was able to shaer a wiki page 5 times, and the email receiving the url with token was able to view that page 5 times. No more, no less.
No idea what happened the other day in the test we did Jyhem and myself on a Tiki 21 production site of myself.

Frequently here and on tiki.org the Since Your Last Visit module lists all changes since August (for me here at the moment {sign user="jonnybradley" datetime="2020-12-16T16:16:58+00:00"}) which added 10 to 20 seconds to every page load time.

Resetting the "to" date by going to [tiki-calendar.php?todate=0] clears it but when the session runs out it goes back to months ago (and slowness)

There is a problem in Slides in 21.x: Section about wiki page comments wrongly placed on top of all slide titles, when some setting is on related to comments.

This was not happening in previous LTS versions, with the former slideshow system (that's why I tagged it as regression; untested in 19.x, 20.x, etc).

Reproduced here:
http://xavi-9794-7332.show2.tikiwiki.org/tiki-slideshow.php?page=Tiki+Wiki+CMS+Groupware#s0
u: admin
p: 12345

Just after enabling the pref:
-+wiki_comments_displayed_default+-
and while keeping the default pref: -+wiki_comments_allow_per_page+- Disabled (which is the default setting).

You don't see the comment as Anonymous.
You'll see the comment if you log as admin.

In all cases, comments should NOT be displayed in a Wiki slideshow: https://doc.tiki.org/Slideshow

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

Slideshow system fails to work if there is no ((doc:PluginSlideshow)) call in wiki page but just automatic link at the page bottom.
It seems as if some library (or something) is missing to allow passing slides forward, because the first slide is shown, and it works to hiughlight bullet points, but when the time to move to the 2nd slide comes, nothing happens and slideshow stays in the first.

If you go to list slides, and attempt to click at any from that list, it seems as if the slideshow systems wants to take you there, but it comes back to the first slide very quickly.

Reproduced in this show2.t.o instance attached to another bug report:
http://xavi-9794-7332.show2.tikiwiki.org/tiki-index.php?page=Tiki%20Wiki%20CMS%20Groupware
u: admin
p: 12345

Once you edit that page, and add a simple call to plugin slideshow inside (no params needed), and tiki caches cleared (just in case), then it works as expected:
{CODE()}
{slideshow}
{CODE}

After updating a Tiki21 that is using SMTP Google server has sending email option, Google throw an error an email are not sent.

{CODE(caption="log to catch the previous Git version of a working Tiki")}
Bernard$ git log
commit d002513ebdbe3721cc701dd58a6b47da59233bed (HEAD -> 21.x, origin/21.x)
Merge: 34566b8ecf 4a68067e0b
Author: Bernard Sfez <me@xxxx.xxx>
Date: Sun Mar 22 16:29:39 2020 +0000
{CODE}

{CODE(caption="The error")}
Warning

Unable to send mail
Array ( [0] => 5.7.8 Username and Password not accepted. Learn more at 5.7.8 https://support.google.com/mail/?p=BadCredentials e5sm15280421wru.92 - gsmtp )
{CODE}

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

We are lacking some languages spoken by millions. I'm not asking for translations, but we don't even have them as languages to correctly flag user texts for i18n, they are missing in /lang/langmapping.php.

* Dari (Afghanistan)
* Pashto (Afghanistan) https://en.wikipedia.org/wiki/Afghanistan#Languages
* Persian (Iran). We do have Farsi, but to my understanding the official wording is Persian, an Farsi is rather the name used outside Iran (endonym). https://en.wikipedia.org/wiki/Iran#Languages and https://en.wikipedia.org/wiki/Persian_language

There is an ISO transliteration of Persian into latin alphabet ISO 233-3.

Hi,
Is there a way of sorting content by means of "sort" control block sorting by more than one value? for example I'd like to execute a first sorting based on column A value; than, for each column A value, I'd like the content to be further sorted by column B value (hope it'clear).

Currently I use something like

{CODE(theme="default")}
{LIST()}
{filter field="tracker_id" content="..."}
{sort mode="tracker_field_..._asc"}
...
{LIST}
{CODE}

I think it could be used something like
{CODE(theme="default")}
{sort mode="tracker_field_sortingField1_asc"}
{sort mode="tracker_field_sortingField2_desc}
{CODE}

Or alternatively
{CODE(theme="default")}
{sort mode="???" modes="tracker_field_sortingField1_asc, tracker_field_sortingField2_desc, ..."}
{CODE}
in a similar way w.r.t the already existing syntax
{CODE(theme="default")}
{sort mode="randommode" modes="title_asc,tracker_field_example_asc,tracker_field_ticketNumber_nasc, modification_date_nasc"}
{CODE}

Thank you for your attenction

As detailed in Support Forums ( https://tiki.org/forumthread68978-Can-I-reorder-the-forums ) the current Forum structure, while allowing to sort by most recent, alphabetic, etc. does not have the ability to sort individual forums arbitrarily.

Depending on the forum type, you want to have the forum owner to be able to sort by forum's importance. This may differ from most recent, alphabetic, etc., and may have to be set arbitrarily (e.g. by assigning a forum number to each forum, which is generally not visible in the Forum view but provides the sorting order).

This has been discussed with Marc Laporte and work should begin shortly.

Items displayed in/from a dynamic list field type are ordered (or unordered) by item id. It would be nice to be able to sort them alphabetically or by date.

I have a case here where parents have to select days and it is not user friendly (and not very nice).

{img fileId="1432" thumb="box"}
The 9/03 item should be displayed before the 10/03 but the item id of this item comes after the 10/03 one.

Sorting on field names in admin tracker view (tiki-view_tracker.php?trackerId=XX) displays an error message « Error
Requête de recherche invalide: Parsing search query failed: "Field created does not exist in the current index. If this is a tracker field, the proper syntax is tracker_field_created." »
Even though the sorting actually happens.

TW really should not be sending spoofed e-mails.

Wiki content watches, Structure Watches, Tracker Notifications etc use the system wide sender e-mail address as set on Control Panel -> General in the Mail sub section of that page to send their notification e-mails.

However, it seems as though e-mail notifications generated by the Inter User Messaging system don't use this system wide sender e-mail address. Rather it sends messages with a spoofed e-mail address of the user who is to receive the e-mail.

As Mail Service Providers rightly tighten their spam filtering techniques, Message notification e-mails sent by TW are getting impacted.

Might TW avoid this issue by providing admins with an option to also use the system wide e-mail sender address for Message notification e-mails, please?

This is demonstrated here:
http://user-11990-7501.show2.tikiwiki.org

With a wiki page this code
{CODE(theme="default")}Table of contents:{toc structId="1" shownum="1"} {CODE}
will produce this with a PDF generated:
{img fileId="1444" thumb="box"}

It does not matter if the wiki page is part of the structure or not.
On screen there are only numbers shown:
{img fileId="1445" thumb="box"}

With version 21 the wiki pages which are part of a structure seem to be displayed as if the CSS isn't working. It looks like a very simple html page. At first I thought the bandwidth is so low so that the page is presented with the minimum information.