Category: 22.x

On most of Tiki list/tables (if not all) when you have sorting tools you have first to click on the header to activate it.
It sort the items in ascendant order based on this column and you can see the ascendant arrow.

When the sorting is based on a text column, the order of the items based on subject col is really weird to the viewer. (see: https://dev.tiki.org/tiki-view_tracker.php?sort_mode=f_26_asc&trackerId=5)

Was hard to diagnose...

After upgrading a Tiki20 to Tiki21 I was able to rebuilt the index:

{CODE()}
[03-03-2020 12:05] Started rebuilding index... logging to file: /var/tmp/Search_Indexer_mysql_tsaharoniki_tiki21_console.log
Unified search engine: MySQL, version 5.7.26
error: The search index could not be rebuilt.
Expression #1 of ORDER BY clause is not in SELECT list, references column 'tsaharoniki_tiki21.ttif0.value' which is not in SELECT list; this is incompatible with DISTINCT
{CODE}

The log:
{CODE()}
2020-03-03T10:47:35+02:00 ERR (3): WARNING: PDOStatement::execute(): SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'tsaharoniki_tiki21.tti$
{CODE}

Checking the item (I had to find it!) I found out that having a sort parameter in an itemList field was responsible.

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

Once removed it worked.
This is very problematic when you have financial data as any report must be ordered (by date).

Update: {sign user="Bsfez" datetime="2020-03-08T17:20:40+00:00"}
Same same in Tiki 20
It may be related to the removal of the "split" function in PHP 7+;
https://whmcs.community/topic/290945-how-to-sort-smarty-variables-in-whmcs-76/

Update: {sign user="Bsfez" datetime="2021-03-02T14:41:19+00:00"}
It is now also on Tiki18.8 as it was signaled to me by another Tiki user (tested with him)
I tried to reproduce on the show instance but there is a bug with field list on the trackers and it is not possible to recreate the caches.
{img fileId="1514" thumb="box"}

Structure Menu does not update after page-name changes

# you have a page in a structure and the structure Menu is activated
# you change the page name
# in the breadcumb navigation the changed page name shows up
# but in the Structure menu the old name did not change, but when clicking on it the page shows up anyway.
# in the Structure page the correct name is shown anyway

e.g. changed page ITSystemFiltered to ITSystemActiveFiltered

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

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

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

I see we have now a "Suggestion box" in Tiki22.

While this is nice I couldn’t find any information at dev or doc about this addition based on "a list of rules" ?
I found a checkbox in feature to disable it.

#While I have no idea what/where it should go, I wonder if this is really a Tiki feature.

At https://tiki.org/tiki-admin_survey_questions.php?surveyId=8 over 25 questions the pagination turn on. Moving from page to page doesn’t help, you can see questions after the first page.

We have no syntax for expressing we want an unlimited number of LIST plugin results.

Using mysql Full-Text indexation, one can express the idea with a huge number like so :
{CODE()}{LIST()}
{filter field="object_type" content="trackeritem" }
{filter field="tracker_id" exact="1"}
{pagination max="99999999"}
{OUTPUT(template=)}
{LIST}{CODE}

It is ugly but it does the job in an expressive way (people will understand 99999999 does not mean exactly 99999999).

Using Elascticsearch, the above will fail with an obscure error message « all shards failed » because Elascticsearch has a hard limit which defaults to 10000 but it can be changed at the server level.
See ''Results Per Query'' in [https://www.elastic.co/guide/en/app-search/current/limits.html]
So I need to use:
{CODE()}{LIST()}
{filter field="object_type" content="trackeritem" }
{filter field="tracker_id" exact="1"}
{pagination max="9999"}
{OUTPUT(template=)}
{LIST}{CODE}
Because "10000" looks like I really want "10000" rather than unlimited.

__It is bad that the LIST plugins need to be rewritten when one changes the unified search indexation method.__ Also, it is not obvious why it fails.

__SUGGESTION__ I feel we should allow for a real syntax for unlimited results such as :
{CODE(caption="SUGGESTED SYNTAX" theme="default")}{pagination max="-1"}{CODE}

Then if Tiki uses Elascticsearch searches it could look up the ''Results Per Query'' value (or assume 10000 for starters) when "-1" is encountered.
If Tiki uses "Mysql Full-Text search" if should not have a limit (or it should have a very high one).

On a Tiki forum when it is enable Tablesorter is added to the table that list the forum to allow filtering and sorting. Work fine if you have only Forums.
When you use subforum discussions the table sorter is interfering as it is working on the subform list instead of continuing to filter/sort the discussion below.

The tablesorter filter row is placed above the subforums list instead of the discussion list it should be moved below to be applied on the discussions.

We have an issue with Tabular when a value of a field = "0"
And then how it is seen using : tiki-pluginlist_experiment.php

To reproduce.
I have a CSV with the following:
ID,NUMBER
111,1
112,1
113,0
114,0
115,0
116,5
117,4

Tabular import will create/update trackerItems as follow.

|| ID | NUMBER
111 | 1
112 | 1
113 |
114 |
115 |
116 | 5
117 | 4 ||

Which is wrong, empty is empty and 0 is 0. ;-)

Then when using the tiki-pluginlist_experiment.php here what I got.
Where they were a value for the field NUMBER I see:
tracker_field_trackerNUMBER => "1"
tracker_field_trackerNUMBER => "Vendu"

Where they were a 0 => that became an empty value the field is not displayed at all...

I created a fairly basic tiki setup using a brand new Tiki 21 instance (aimed to be used in production next week)

I applied the Collaborative_community_12x profile.

When attempting to edit the registered group to remove the homepage, or select anonymous in the inheritance field, I can't save because this errors blocks the process:

^ Template Group children cannot have permission: Editors ^

I didn't select anything with editors at that level. Nor I did attempt to do anything with templated groups yet, but I was aiming to change basic options yet.

What's going on? Is this "templated groups" feature ready for production?
How can I disable the templated groups and roles options, in order to avoid their issues with basic behavior and setup of a basic Tiki site not requiring that level of complexity?

It should be optional, shouldn't it?
---
Reproduced cleanly in a brand new site at show2.t.o (on trunk since 21.x is not available yet at show2.t.o), and it's clearer to me that this is candidate to release blocker: too serious of an issue with a basic setup and expected change by tiki site admins willing to tweak the basic groups to their needs.

Steps to reproduce:
(1) Log in as admin here:
http://xavi-9794-7325.show2.tikiwiki.org/tiki-admingroups.php?group=Registered
u: admin
p: 12345

(2) Remove the contents of the homepage field and attempt to save. Error message is triggered.

HTH

If the content of a issue in the wishlist is big it may hide the title link in the dev dashboard: https://dev.tiki.org/Developer-Dashboard

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

Should not be possible... (truncate ?)

Using the plugin groupList you should be able to see recursively the included group from a group.

They are not displayed when the option is set to yes.

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

Many features aren't working correctly. There's no delay on action popup display, menu dropdowns aren't showing their usual ease-in/-out, tabs aren't working in admin pages (I turn the feature on but the checkbox is unchecked again after the page refreshes), etc. I don't know if it's a JavaScript problem or if JavaScript weirdness is a result of something else, actually.

We have a way of synchronizing the RealName with fields in the ''user tracker''.

It would make a lot of sense to have a similar option for synchronizing the users avatars with a ''file type field'' in the ''user tracker''.

Currently, one can ask for an image of the user at registration or later in the user tracker but if the user's avatar needs to be provided by the user himself/herself.
That's cumbersome and not intuitive.

Example real life use case: The user tracker is used as a company directory, filled by the users' ''official'' photos. Lacking user avatars or asking the users to update their avatar makes no sense since all the work was done already.

Hello, Bitnami developer here,

We are working on supporting the latest Tiki 22.

First, we would like to know if this version is considered stable since it is not shown on https://info.tiki.org/Download (we detected it from https://sourceforge.net/projects/tikiwiki/files/Tiki_22.x_Corona_Borealis/).


Apart from that, we are trying to follow the command-line installation following the documentation from http://doc.tiki.org/Manual-Installation. However, this version shows us only a small list of commands:

{MARKDOWN()}
```
php console.php list
Tiki Console Tool

Usage:
command [options] [arguments]

Options:
-h, --help Display this help message
-q, --quiet Do not output any message
-V, --version Display this application version
--ansi Force ANSI output
--no-ansi Disable ANSI output
-n, --no-interaction Do not ask any interactive question
--site=SITE Multi-Tiki instance
--as-user=AS-USER Run the command as a different Tiki user
-v|vv|vvv, --verbose Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

Available commands:
help Displays help for a command
list Lists commands
database
database:configure Database: Configure (write local.php)
dev
dev:fixbom Fix BOM and line endings for all files
installer
installer:lock Disable the installer
scss
scss:compile Compile SCSS theme files into CSS
translation
translation:englishupdate Fix English strings after modifying them.
translation:getstrings Update language.php files with new strings
vcs
vcs:update Update SVN to latest version & perform tasks for a smooth update.
```
{MARKDOWN}

Could you please share with us the exact commands that the installer should run to pass the installation?

Thanks in advance,

The Changes Wizard shows no mention of Tiki 22.x
Instead the first thing it shows is "__New in Tiki 18 (LTS)__".
A bit embarrassing we have nothing new in Tiki 22.x to show there... (:redface:)

Release Blocker or not? You decide! (:wink:)

Text in a plugin alias body within ~np~~tc~~/np~tags ~np~~/tc~~/np~ appears in the page

Hi:

I wanted to test the new features coming along in BBB 2.3 & 2.4, so that I installed a new server with BBB 2.4. Everything from the BBB side did run smoothly, but the integration with tiki is not fully working as expected. I mean, after connectinng the tiki to bbb 2.4 server (providing the new url and bbb salt in the tiki control panel), I can see the recordings listed in the plugin bigbluebutton parsed content, but I'm never able to create a new meeting (when clicking to the create button shown by plugin bbb).

I had a look at the [https://docs.bigbluebutton.org/dev/api.html|bbb documentation], and I see that some changes are reported to the API in bbb 2.3 and 2.4.:
{CODE()}
Updated in 2.3:

create - Renamed keepEvents to meetingKeepEvents, removed joinViaHtml5, added endWhenNoModeratorDelayInMinutes
getDefaultConfigXML obsolete, not used in HTML5 client
setConfigXML obsolete, not used in HTML5 client

Updated in 2.4 (under development):

getDefaultConfigXML Removed, not used in HTML5 client
setConfigXML Removed, not used in HTML5 client
create - Added meetingLayout, activityReportTracking
{CODE}

I had a look i Tiki21 LTS, for instance, and I see that there are references to -+getDefaultConfigXML+- and -+setConfigXML+- in __lib/bigbluebuttonlib.php__

{CODE()}
(...)
173: $content = $this->performRequest('getDefaultConfigXML', ['random' => '1'], false);
(...)
192: $client = $tikilib->get_http_client($this->getBaseUrl('/api/setConfigXML.xml') . '?');
(...)
{CODE}

Could this be the reason why tiki is not creating the new room in the bbb-2.4-powered server?

If that hypothesis is confirmed, then we might hit a problem in the tiki community in the afew months whenever Fred Dixon and the BBB team upgrades the bbb instance we use in the "Tiki Roundtable Meetings" and TAG meetings, etc.

I can share the details of my bbb2.4 test server (url and salt) with any dev willing to debug and fix this issue.

The installer supports a hardcoded maximum of 16 characters for the database username, while the database name itself is unrestricted in length.

This causes trouble in some when not most environments, especially hosting.
Most panels use a prefix for database user & name so a restriction in length can fastly cause trouble.

For example my company uses plesk and we have resellers that set the prefix of database-name / -user to a string with more than 16 characters, leaving no place for the actual "name". Also some customers set their "name" part to some lengthy strings. This already causes troubles on installation with tikiwiki through the installer.

The first save of a new article or forum reply post on tiki.org community server never works and deletes all the content of the form (resets) at the first try. User must go back in browser history (I use Brave browser, luckily the content is still there if you did not do a preview) and re-try the save action. :(

It happened many times to me recently. I can provide video of the action if needed to reproduce.

Not sure it is a server setup issue made by @ohertel or Tiki regression?

Today in the https://tiki.org/Roundtable-Meeting-2020-09 we noticed that a plain registered user is not able to see the forum post "type" dropdown when starting a a new topic (the first message of a new forum thread). Reproduced with user @xavi . However, when listing the topics of a forum, the first column is shown for that same user (as well as anons) indicating the topic type: all say "normal" here:
https://tiki.org/forum4


However, a user with admin rights (for instance @xavidp ) is able to see the dropdown of topic type: Normal | Announce | Hot | Sticky | Deliberation.

Reproduced here:
https://tiki.org/tiki-view_forum.php?openpost=1&forumId=4&comments_threadId=0&comments_threshold=0&comments_offset=0&thread_sort_mode=lastPost_desc&comments_per_page=20

I've checked in the forum edition page, or forums control panel, or forum4 permissions, and I couldn't find anything to explain that behavior. Maybe some bug in some tpl or php code which control which permissions are needed to display that dropdown field?

We have attempted to setup some tracker events in dev.t.o/tracker5 (the Bug Tracker), following he discussion in the ((tw:TRM)) of September 2020, and the ((tw:TAG)) meeting of October 2020 (today)

After setting up the appropriated scheduler task in dev.t.o, with this job:
{CODE()}
cd /var/www/virtual/dev.tiki.org/html/; php tiki-batch_todo.php
{CODE}

And the cron job in the server behind dev.t.o (see [https://tiki.org/Infrastructure-Team#Scheduler_on_dev.t.o] ), this is the error message shown in the scheduler UI in dev.t.o ([https://dev.tiki.org/tiki-admin_schedulers.php?scheduler=1#contenttabs_admin_schedulers-3] ):

{CODE()}
PHP Parse error: syntax error, unexpected '?' in /path/dev.tiki.org/html/lib/init/initlib.php on line 77
{CODE}

On a tracker field item link I have a parameter "Preselect item based on value in this field" and if not blank it show a child parameter (option) that was hidden "Preselect based on the value in this remote field".

''So far I never had this parameter to work and do what I expect and it usually blank the field (no items are displayed in the dropdown) OR show them all but disabled (if you enable multiple select).''

However if you set back the PARENT parameter to blank un-touching the CHILD parameter that will be then hidden it will kill prevent the field to work normally as this option is still in effect.

That should be the case.
If you unset a parent parameter all children parameters should be considered as reset back also.

In a tracker I can use a rules for an item link. (to hide a different field if the item link field contain one of several value for exemple).

If I set the parameter "Select multiple values" to yes, the rule is not working anymore.

If I set a rule that check the content of a track field item link I can’t use the label of the option (displayed) and I need to indicate the value of the option (in the code).

IE :
<option value="5468">Paris</option>

Paris won’t work for the rules condition but "5468".

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.