Loading...
 
Skip to main content

Category: 22.x

22.x
Show subcategories objects

Name Type
PluginDiagram not showing diagram if file stored in file gallery
((doc:PluginDiagram)) in ((doc:Tiki20)) seems a very promising feature.
In my first test, I didnt' manage to make it work when choosing to save the diagram in a file gallery, I don't know why. It just doesn't display the diagram within the wiki page where the diagram was called.

If I choose to save the diagram within the wiki page, then everything works as expected.
If I manyally get the xml code from the diagram created in the file gallery, and place it inline within a new call of plugin diagram in the wiki page, the diagram displays as expected.
If I click at edit the diagram from the wiki page (even If I don't see the diagram displayed in the wiki page, I see the button to continue editing it), I can see it and edit it in the diagram ui editor, as expected.

Only issue is (apparently) to display in the wiki page the diagram stored in a file gallery.

HTH
tracker item
PluginDiagram works when saving in wiki page but fails when saving to file gallery
((doc:PluginDiagram)) works when saving in wiki page but fails when saving to file gallery
tracker item
Possible fundamental flaw in the language system's design
Please correct me if I misunderstood this: To me the language system just translates one string of source language into another string of target language, is that right? At least that is suggested by the data structure of language.php.

If that is the case, then there is a fundamental flaw in it: The system cannot (by design) take into account that no function f exists that translations a string of source language into target language.

Because language has a context, and different contexts can radically change to correct translation!

One issue I have only seen now that I have shopping cart activated on one of my Tiki Wikis. There is a button "checkout" to log you off the wiki.

And there is a button "checkout" in the shopping cart, but this will NOT log off the wiki, but close an order, meaning the user requests payment.

The first button "Checkout" is at the moment correctly translated with default values into "Abmelden" in German.

But the second buttons "Checkout" on the shop makes no sense being called "Abmelden" as well, because the user pressing this button does not want to log off, he/she wants to pay, so the only correct translation would be "Bezahlen" (pay).

I believe this contextual change of meaning cannot be dealt with by the current language system, it cannot even handle exceptions?
tracker item
Prevent breaking Tiki with invalid Smarty syntax in custom theme prefs
Add an AJAX service to check the syntax of custom look and feel prefs before saving to make sure you're not going to break your entire Tiki
tracker item
Prevent usability issue when more than 1 PluginTogether session to edit same page
Issue reproduced in live at this page today{sign user="xavi" datetime="2020-09-23T16:57:09+00:00"}:
https://tiki.org/Roundtable-Meeting-2020-09

(it can probably be seen reproduced in the recording of this TRM, whenever it's available)

First user clicks at the plugin together button in the side module, and go to edit the TRM page. Second user clicks also to the PluginTogether button, and click at the edit page button. We (6 users) ended up into something like one or the other session: lines added by user2 were not seen by user1 but by user 4, and some other users were in the same session as user1.

It seems as if the user1 started a together session, user2 started a together session somewhere else, and they both edited the same wiki page, staying in 2 different together sessions. The rest of the users entered one or the other (unclear what criteria made them enter 1 or the 2nd session)
tracker item
Problems with RTL title (anchor) when the string ends with a number (LTR)
On wiki page I have this title:
~np~!{TR()}Summer Holiday camps{TR} 2021{CODE}~/np~

In my custom.php translation file for Hebrew I have:
"Summer Holiday camps" => "קייטנות קיץ",

When I look at the page in english all is fine:
{img fileId="1548" thumb="box"}

But in Hebrew, because numbers are seen as LTR, it misplace the anchor.
{img fileId="1546" thumb="box"}
{img fileId="1547" thumb="box"}

That’s was the kind of issue I was talking about during the TikiFest Virtual 2021. ;-)
tracker item
Profile "Preview Changes" button brings up modal with fatal error in some cases
Some profiles bring up this fatal error when you try to preview the changes to be made:
{CODE()}
Fatal error: Uncaught TypeError: Argument 1 passed to Tiki_Profile_Installer::install() must be an instance of Tiki_Profile, boolean given, called in /var/www/clients/client1/web16/subdirs/tiki19x/admin/include_profiles.php on line 85 and defined in /var/www/clients/client1/web16/subdirs/tiki19x/lib/core/Tiki/Profile/Installer.php:409 Stack trace: #0 /var/www/clients/client1/web16/subdirs/tiki19x/admin/include_profiles.php(85): Tiki_Profile_Installer->install(false, 'all', true) #1 /var/www/clients/client1/web16/subdirs/tiki19x/tiki-admin.php(545): include_once('/var/www/client...') #2 {main} thrown in /var/www/clients/client1/web16/subdirs/tiki19x/lib/core/Tiki/Profile/Installer.php on line 409
{CODE}

__Update__
In 22.x it brings an Error alert dialog:
^__Error loading profile__
This message will move to the top of the page after a few seconds.^
tracker item
Proposition: REST API "adaptor" code
Hi,
TW newbie here, not sure if it's the right category and the right format. Please deal with humans willing to help :)
This post is to solve:
-+Add an Application Programming Interface (API) to improve Federation capabilities, and for BPMN, hopefully in Tiki22
Mainly add a REST API "adaptor" code to make all services available over REST +-
from https://dev.tiki.org/Tiki21

I needed a REST API now and really start to enjoy tikiwiki 21 in my docker container.
I successfully installed a PHP script to solve it for me:
https://github.com/mevdschee/php-crud-api
It serves the whole database with rest api endpoints, so you need to configure which tables you want to serve (trackers, pages, ...)

About integrating it in TW ... unfortunately I'm not a great coder and new to tikiwiki, so not of great help for now :(
If you share with me how you solve this, I might help to code directly in the future.

If any TW guru would like to test. I went through hurdles with docker:
https://github.com/mevdschee/php-crud-api/issues/669

Not sure if it's popular for other TW members but it was mandatory for me.
Easy to solve? Yes for working solution, I don't know for integration.

TW solves the IP thing so I guess it will a walk in the park for you :)
Have a great day!
tracker item
Race condition: Sessions stored in the database and Cypht
The Tiki preference "Session storage location" must not be set to "database"

{QUOTE(replyto="kroky6" date="2023-03-10")}Debugged for some hours and came up with this:
- no problem in cypht code itself - reply details are sent to the session to be written and requested from session on the compose page but there are not there when requested
- session Tiki-Cypht integration - no problem as well, session is written when request finishes
- data that is written to the mysql sessions table (this Tiki stores sessions in db) is correct (contains the reply details)
- however, the data is not in mysql database after write

Tried to debug more with manual query, tried to simplify with select and then update or insert instead of replace type of query but again the same result.

I think this is what happens - every time this bug happens, there are multiple AJAX requests executed in the background. I think they overlap in time which results in the following race condition:
1. get message content cypht ajax request begins and is processing.
2. another ajax request begins and opens the session (reads the current session and there are no reply details there).
3. get message content cypht ajax request writes the session when completing and writes the reply details
4. the other ajax request finishes after that and writes the session but it doesn't have the reply details (effectively overwriting another process's session).

I think we switched for non-locking mode of db sessions to speed up this Tiki but when we face overlapping ajax requests this has adverse side effects. Do you remember why did we switch to non-locking mode? I think we should either update cypht-Tiki integration to send one ajax request at a time or switch to session lock mode the whole site.{QUOTE}
tracker item
Index error on tiki tracker (built-in) fields and BLOB/TEXT error after recent update of Tiki22
As discussed in the devlist:
I can confirm now a nasty regression introduced in Tiki22.x at some point. (between 2 month ago and now)

It broke filters (item link and item list)

It may be related of tracker field "real" life as I saw the BLOB/TEXT error on a field that was added at some point and not all the items have been saved with it (math field).
(console.php recalc doesn’t seems to be in Tiki22)

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

List of the files reverted to have my Tiki back to work (updated, created, deleted):
{CODE()}
reverted:
.editorconfig
_htaccess
changelog.txt
copyright.txt
db/tiki-db.php
db/tiki.sql
doc/devtools/release.php
doc/devtools/satis.json
installer/composer-patches/jcbrand-conversejs_remove-native-javascript-for-bootstrap.patch
installer/schema/20101230_create_top_modules_tiki.php
installer/schema/20110115_create_bottom_modules_tiki.php
installer/schema/20110201_c_code_to_user_modules_tiki.php
lang/ar/language.php
lang/bg/language.php
lang/ca/language.php
lang/cn/language.php
lang/cs/language.js
lang/cs/language.php
lang/cy/language.php
lang/da/language.php
lang/de/language.php
lang/el/language.php
lang/en-uk/language.php
lang/en/language.php
lang/es/language.php
lang/fa/language.php
lang/fi/language.php
lang/fj/language.php
lang/fr/language.php
lang/fy-NL/language.php
lang/gl/language.php
lang/he/language.php
lang/hr/language.php
lang/hu/language.php
lang/id/language.php
lang/is/language.php
lang/it/language.php
lang/iu-iq/language.php
lang/iu-ro/language.php
lang/iu/language.php
lang/ja/language.php
lang/ko/language.php
lang/lt/language.php
lang/nds/language.php
lang/nl/language.php
lang/no/language.php
lang/pl/language.php
lang/pt-br/language.php
lang/pt/language.php
lang/rm/language.php
lang/ro/language.php
lang/ru/language.php
lang/sb/language.php
lang/si/language.php
lang/sk/language.php
lang/sl/language.php
lang/sq/language.php
lang/sr-latn/language.php
lang/sv/language.php
lang/sw/language.php
lang/th/language.php
lang/tr/language.php
lang/tv/language.php
lang/tw/language.php
lang/uk/language.php
lang/ur/language.php
lang/vi/language.php
lib/blogs/bloglib.php
lib/categories/categlib.php
lib/comments/commentslib.php
lib/core/H5P/editor.js
lib/core/Math/Formula/Function/ForEach.php
lib/core/Math/Formula/Function/Subtotal.php
lib/core/Perms.php
lib/core/Perms/ResolverFactory/CategoryFactory.php
lib/core/Perms/ResolverFactory/ObjectFactory.php
lib/core/Search/Formatter.php
lib/core/Search/Indexer.php
lib/core/Search/Query/WikiBuilder.php
lib/core/Services/Cypht/Controller.php
lib/core/Services/Edit/PluginController.php
lib/core/Services/H5P/Controller.php
lib/core/Services/Tracker/Controller.php
lib/core/Services/Tracker/TabularController.php
lib/core/Services/Tracker/Utilities.php
lib/core/Tiki/Command/GetStringsCommand.php
lib/core/Tiki/MailIn/Source/Imap.php
lib/core/Tiki/MailIn/Source/Pop3.php
lib/core/Tiki/MemoryLimit.php
lib/core/Tiki/Profile/InstallHandler/WikiPage.php
lib/core/Tiki/SabreDav/Utilities.php
lib/core/Tiki/Sitemap/AbstractType.php
lib/core/Tiki/Sitemap/Generator.php
lib/core/Tiki/Sitemap/Type/Articles.php
lib/core/Tiki/Sitemap/Type/Blog.php
lib/core/Tiki/Sitemap/Type/Forums.php
lib/core/Tiki/Sitemap/Type/Page.php
lib/core/Tracker/Field/GroupSelector.php
lib/core/Tracker/Field/ItemsList.php
lib/core/Tracker/Field/Math.php
lib/core/Tracker/Filter/Collection.php
lib/core/Tracker/Rule/Definition.php
lib/core/Tracker/Rule/Type/Collection.php
lib/core/Tracker/Rule/Type/Text.php
lib/cypht/integration/classes.php
lib/cypht/modules/tiki/general_modules.php
lib/cypht/modules/tiki/setup.php
lib/cypht/site.js
lib/filegals/filegallib.php
lib/filegals/h5plib.php
lib/gitlib.php
lib/headerlib.php
lib/jquery_tiki/elfinder/tiki-elfinder.js
lib/jquery_tiki/inline_edit.js
lib/jquery_tiki/pluginedit.js
lib/jquery_tiki/tiki-jquery.js
lib/jquery_tiki/wikiplugin-pivottable.js
lib/language/CollectFiles.php
lib/parser/parserlib.php
lib/prefs/feature.php
lib/setup/twversion.class.php
lib/smarty_tiki/modifier.sefurl.php
lib/smarty_tiki/modifier.slug.php
lib/structures/structlib.php
lib/test/rating/AggregationTest.php
lib/tiki-js.js
lib/tikilib.php
lib/toolbars/toolbarslib.php
lib/trackers/trackerlib.php
lib/userslib.php
lib/vue/duration/DurationPicker.vue
lib/vue/duration/DurationPickerEditor.vue
lib/vue/duration/DurationPickerModal.vue
lib/vue/duration/DurationPickerTitle.vue
lib/vue/duration/styles.css
lib/wiki-plugins/wikiplugin_customsearch.php
lib/wiki-plugins/wikiplugin_cypht.php
lib/wiki-plugins/wikiplugin_group.php
lib/wiki-plugins/wikiplugin_pivottable.php
lib/wiki/editlib.php
lib/xmpp/ConverseJS.php
lib/xmpp/css/conversejs.css
lib/xmpp/js/conversejs-tiki-oauth.js
lib/xmpp/js/conversejs-tiki.js
README
robots.txt
route.php
templates/admin/include_security.tpl
templates/admin/include_trackers.tpl
templates/categorize.tpl
templates/database_connection_error.html
templates/filter_control/drop_down.tpl
templates/freetag.tpl
templates/header.tpl
templates/tiki-admin_calendars.tpl
templates/tiki-admin_categories.tpl
templates/tiki-admin_orphaned.tpl
templates/tiki-admin_sitemap.tpl
templates/tiki-admin_tracker_fields.tpl
templates/tiki-admingroups.tpl
templates/tiki-calendar.tpl
templates/tiki-edit_article.tpl
templates/tiki-edit_blog.tpl
templates/tiki-forums.tpl
templates/tiki-list_trackers.tpl
templates/tiki-upload_file.tpl
templates/tiki-view_forum.tpl
templates/tracker/import.tpl
templates/tracker/remove_fields.tpl
templates/tracker_actions.tpl
templates/tracker_sync/clone_remote.tpl
templates/trackerinput/duration.tpl
templates/trackerinput/userpreference.tpl
templates/wiki-plugins/wikiplugin_files.tpl
templates/wiki-plugins/wikiplugin_pivottable.tpl
templates/wiki-plugins/wikiplugin_subscribenewsletter.tpl
templates/wizard/changes_doc_page_iframe.tpl
templates/wizard/changes_new_in_22.tpl
tiki-admin_categories.php
tiki-admin_modules.php
tiki-caldav.php
tiki-calendar_edit_item.php
tiki-check.php
tiki-forums.php
tiki-index.php
tiki-login.php
tiki-setup.php
tiki-upload_file.php
tiki-user_preferences.php
tiki-view_forum_thread.php
vendor_bundled/composer.json
vendor_bundled/composer.lock

db/tiki-secdb_22.0_mysql.sql

db/tiki-secdb_22.1_mysql.sql
installer/schema/20210115_add_trackerfields_sefurl_tiki.sql
lib/core/Math/Formula/Function/PregReplace.php
lib/core/Search/Formatter/ValueFormatter/Url.php
lib/core/Services/Edit/Utilities.php
lib/core/Tracker/Rule/Operator/CollectionContainsUsername.php
lib/core/Tracker/Rule/Operator/TextIsUsername.php
lib/validators/validator_smarty.php
templates/examples/search/h5p.tpl
templates/examples/search/simple_table.tpl
tiki-robots.php
{CODE}
tracker item
Search, List; Whish for a better random parameter for the pluginList
The plugin list need a real "random" sort option to display trackeritem randomly in a list.
It will help to use it in many place.

For example at https://tiki.org/consultants
We use {CODE()} {sort mode="randommode" modes="tracker_field_tikiConsultantsUsername_asc, tracker_field_tikiConsultantsItemID_ndesc, tracker_field_tikiConsultantsItemID_asc, tracker_field_tikiConsultantsSorting_asc,tracker_field_tikiConsultantsName_asc, modification_date_asc, tracker_field_tikiConsultantsName_desc"}{CODE}

With all this parameters it even couldn't get the illusion it is random. Refresh 4 or 5 times the page and you will see that the list is permutation of the same order.
tracker item
Remove tiki file-tree from show2.t.o instance when item is closed
{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.
tracker item
Saving a comment using the Save and Comment button on the whishlist creates 2 identical comments
It is the second time (and I see others having the same issue) that saving a comment using the "Save and Comment" button when completing a tracker item on tracker5 creates 2 identical comments instead of one.
tracker item
Score Feature - Slow Database Queries
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;

tracker item
Filtering a Multivalue does not work with MySQL search
Search (index) need sometimes to "Explode" a itemList field values as an array of string so each value can be filtered

For an exemple, in a tracker you have an itemList fields using this date field with such values:
* tracker_field_date: 2021-03-24, 2021-01-14, 2020-10-22

To filter per date (we need item that contain "2021-03-24" only) we can should be able to use multivalue.

{CODE(caption="filter set in a smarty template, work the same elsewhere")}
{filter field="tracker_field_date" multivalue="{/literal}{$row.tracker_field_holidayDay}{literal}"}
{CODE}

''Note: if you use content you may filter "2021-03-24 and 2021-01-14 because they both contain "2021"''

This is working fine if you use elasticSearch but doesn’t when you use Mysql.
tracker item
Search preferences should be smarter (and find a term plural or not)
The Search preferences at the top of the admin control panels pages should be clever and be able to display "alike" results like for "suggestion" or "suggestions".

Using plural or not, first letters of a term, etc...
tracker item
Setup.sh verbose need to be clarified and updated (php7.4)
Tiki22 require PHP 7.4.

After installing Tiki22 (git master) I ran setup.sh while running PHP7.2 and it thrown the following.

{CODE()}
Your choice [c]? c
Wrong PHP version: php54 < required PHP version. A version >= php72 is necessary.
Searching for typically named alternative PHP version ...
which: no php73 in (/usr/clearos/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin)
{CODE}

Not having 7.4 installed yet I tried 7.3 and got the following.

{CODE()}
Your choice [c]? c
Wrong PHP version: php54 < required PHP version. A version >= php72 is necessary.
Searching for typically named alternative PHP version ...
which: no php73 in (/usr/clearos/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin)
{CODE}

And then a lot of deprecation errors.

Tiki 22 work with 7.4 and it should verbose correctly and warn the users.
tracker item
Several items in a relation field may lead to problem with indexing
In a Tiki22 I have 2 trackers (orders, payments) with relation fields.

They may be one order with several payments (recurrent, monthly payment).
I have actually 4 payments per orders and that’s work ok but on a specific case I have more payment and Tiki throw errors.

{CODE()}
×
 Error
Indexing failed while processing "1268" (type trackeritem) with the error "Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1"
×
 Error
Malformed search query: Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1
×
 Error
The search index could not be updated. The site is misconfigured. Contact an administrator.
Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1
{CODE}

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

By nature relation shouldn’t be limited and able to handle many items.

~~#F00:__UPDATE__~~
It is plaguing and changing behaviour of other components.
In the screenshot below you can see many counter (plugin list count template) displaying a 0 instead of the real value even if the list plugin is set with a different tracker. There is a big chance the index become corrupted or not completed so I escalated.

The fields should be protected in a first place (avoiding using longer data than possible to use) and finally this field specific should be set to a relative high amount of data.

{img fileId="1486" thumb="box"}
tracker item
Severe problems to log into d.t.o
Hi,

in the past couple of days I had severe problems to log in to d.t.o. First, it kept complaining that cookie consent would be required. I have always had d.t.o. in my list of execeptions.
Therefore I entirely disabled the "improved activity tracking block" of my Firefox ( 84.0.2 running on Linux Mint 18.3. ), but it kept complaining.
After filing a note on tiki.org (where I could log in with no problems at all), and several days with no replies, I tried d.t.o. again. Then it complained about a mismatch of the security token with that on the server, with the remark "reloading might help". It did not. Not immediately. Upon the third reload, with a cache clear and a restart of Firefox, it finally worked...
tracker item
Since Your Last Visit wants to show changes from months ago
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)
tracker item
Slider doesn't work
Because this bug report supports -+~np~{SLIDER}~/np~+-, below is a demo that demonstrates the error. See the JS error this bug report page generates in developer console.

{CODE()}{SLIDER( width="80%" theme="mini-light" expand="n" resizecontents="n" buildarrows="y" buildnavigation="y" buildstartstop="n" togglearrows="y" togglecontrols="y" enablearrows="y" enablenavigation="y" enablekeyboard="y" autoplay="y" autoplaylocked="n" autoplaydelayed="y" pauseonhover="y" stopatend="n" delay="4000" animationtime="1000" hashtags="n")}{img fileId=1522}
{SLIDER}{CODE}

START OF DEMO

{SLIDER( width="80%" theme="mini-light" expand="n" resizecontents="y" buildarrows="y" buildnavigation="y" buildstartstop="n" togglearrows="y" togglecontrols="y" enablearrows="y" enablenavigation="y" enablekeyboard="y" autoplay="y" autoplaylocked="n" autoplaydelayed="y" pauseonhover="y" stopatend="n" delay="4000" animationtime="1000" hashtags="n")}{img fileId=1522}
{SLIDER}

END OF DEMO

This resulted in a working slider in 21. After upgrade I get the following JS error:

{CODE()}jquery.min.js:2 Uncaught TypeError: b.replace is not a function
at Function.ga.matchesSelector (jquery.min.js:2)
at Object.add (jquery.min.js:3)
at jquery.min.js:3
at Function.each (jquery.min.js:2)
at a.fn.init.each (jquery.min.js:2)
at ya (jquery.min.js:3)
at a.fn.init.on (jquery.min.js:3)
at a.fn.init.a.fn.<computed> (min_main_124e21a7d76a2835b01c446b47408413.js:formatted:194)
at a.fn.init.jQuery.fn.load (min_main_124e21a7d76a2835b01c446b47408413.js:formatted:63128)
at $.anythingSlider.base.updateSlider (min_main_bb326a0cdb1e9f74c977e7507c0fafb4.js:formatted:226){CODE}

Web page where this happens: https://kipinapartio.fi/

I debugged this a bit and tracked it down to git commit {CODE(theme="default")}70b0df71119d5592677ba37b1a801f5fb406bba6 which adds a new load jQuery method. This method calls element.tikiModal(tr('Loading...'));{CODE}In the case of slider element is Window object. Modal doesn't support window as it tries to modify or read z-index which doesn't exists for window. Maybe just add if statement around tikiModal line and not call it if the element is window?

__Update:__
Actually I (@luci) see this in Chrome console:
{CODE()}
Uncaught TypeError: Cannot read property 'defaultView' of undefined
at Ie (min_main_3da61fe09f318f29e486129fa2ff5e86.js:184)
at Be (min_main_3da61fe09f318f29e486129fa2ff5e86.js:184)
at Function.css (min_main_3da61fe09f318f29e486129fa2ff5e86.js:184)
at min_main_3da61fe09f318f29e486129fa2ff5e86.js:184
at $ (min_main_3da61fe09f318f29e486129fa2ff5e86.js:184)
at a.fn.init.css (min_main_3da61fe09f318f29e486129fa2ff5e86.js:184)
at min_main_3da61fe09f318f29e486129fa2ff5e86.js:5502
at Function.each (min_main_3da61fe09f318f29e486129fa2ff5e86.js:184)
at a.fn.init.each (min_main_3da61fe09f318f29e486129fa2ff5e86.js:184)
at a.fn.init.$.fn.tikiModal (min_main_3da61fe09f318f29e486129fa2ff5e86.js:5502)
{CODE}

__Weirdly demoing the SLIDER here prevents displaying of the comments below the tracker item?__ (not particularly weird, the comments are loaded by ajax so if the javascript in the page is broken it doesn't get to that call {sign user="jonnybradley" datetime="2021-03-24T11:37:08+00:00"})
tracker item
slideshow fails to work if no plugin slideshow call in wiki page but just automatic link at the page bottom
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}

tracker item
Some filters on date range are not working anymore
This:
{CODE()}
{filter range="creation_date" from="first day of previous month midnight" to="first day of midnight"}
{CODE}

Is not working anymore on fresh upgraded Tiki22.
It was working fine (a month++ ago) as explained in the doc: http://doc.tiki.org/PluginList-filter-control-block#Date_ranges
tracker item
Some widely spoken languages missing
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.
tracker item
Console cache:clear command creates files as the current user
Recently (since 21.x i think) the command -+php console.php c:c+- clears the cache files but then recreates several but using the current user (so -+root+- if using sudo to repair a previous issue).

Then when using the browser to clear all caches we get these sort of errors:
{CODE()} Cache file temp/templates_c/en_basic^c0a74c88a95913ac40aae6373020e7a6b2c0f1f9_0.file.cookie_consent.tpl.php is not writable
Error
Cache file temp/cache/1a11dae0a46d862cd81ddc7650f62cb8 is not writable
Error
Cache file temp/cache/container.php is not writable
Error
Cache file temp/cache/cd13e8c5df46647a6182a0cc858c8ed9 is not writable
{CODE}

Solution: console clear cache should not regenerate any cache files.
tracker item
Show PHP error messages