Category: 21.x

When filing a new wish, two errors are thrown, concerning trackers:
Error

Indexing failed while processing "26116" (type activity) with the error "normalizer [sortable] not found for field [sort]"

Error

Indexing failed while processing "7480" (type trackeritem) with the error "analyzer [sortable] not found for field [tracker_field_submitted_by_unstemmed]"

Despite the errors, the wish gets stored.

Thanks for looking after the server (again...)
hman

https://tiki.org/forum26 = a white screen.
Seems to be stuck 6 month ago
{img fileId="1430" thumb="box"}

When generating a PDF from a wiki page diagrams are not shown in the PDF.

We have been experiencing in our team at work several issues while attempting to use Tiki Diagrams in production in Tiki 21.x LTS

There might be 2 related (for the end user) issues. It seems as if some ticket expires too soon and some error related to CSRF is shown. Maybe after editing the diagram for more than 20 minutes or so (even if Tiki is set to remember the login for days or weeks, which seems to work when we are not using the diagram feature).

Diagrams are created to store their contents in a wiki page (because in file gallery we face some other issue still, as reported in [item7192|another bug report])

2 error messages are shown in similar conditions (unclear yet the exact difference; these reports were sent by work colleagues of mine, so far)
Error message 1:
{QUOTE()}
"An error occurred, please try again.
Potential cross-site request forgery (CSRF) detected. Operation blocked. Reloading the page may help."
{QUOTE}

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

Error message 2:
{QUOTE()}
"An error occurred, please try again.
Potential cross-site request forgery (CSRF) detected. Operation blocked. Ticket has expired. Reload the page"
{QUOTE}

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

In case it matters: the https certificate seems to be not recognized (by the browser used to reproduce the issue) as valid.

It is possible in Tiki 21 using the release package (https://sourceforge.net/projects/tikiwiki/files/Tiki_21.x_UY_Scuti/) to upgrade the composer packages using ~pp~sh setup.sh~/pp~. It breaking the Tiki.

It should not be possible to use it if official release package is detected.

When Tiki is not completely set up and composer (vendor_bundled libs) not ready, Tiki shows only raw plain-text message when you access pages like tiki-admin.php or tiki-listpages.php

It shows only:
"Your Tiki is not completely installed because Composer has not been run to fetch package dependencies. You need to run 'sh setup.sh' from the command line. See https://doc.tiki.org/Composer for details."

It would be better if it used --default Tiki UI / theme-- some HTML + CSS UI displaying the message in a nicer way.

Tested in my Chrome browser all edit plugin helper icons do nothing currently on tiki.org
E.g. clicking the jigsaw puzzle icon on https://tiki.org/Roundtable+Meeting+2020+01 (with javascript:void() link) does nothing. Same on doc.tiki.org

No errors in Google chrome Console appearing.

Can anybody confirm/reproduce?

Google Chrome is up to date
Version 79.0.3945.130 (Official Build) (64-bit)

There might be some sharp edge somewhere with the new ((doc:PluginGanttChart)) or with the profile to showcase it.

Editing a Gantt Chart through its own UI shows missleading messages after resizing some bars: some success message in a remarksbox, as well as another remarksbox reporting some sort of error:
-+Error: The following mandatory fields are missing: Dependencies+-
---

Reproduced here:
http://xavi-9794-7119.show2.tikiwiki.org/tiki-index.php?page=Sample-Gantt-Chart
u: admin
p: 12345

See also:
{img fileId="1309" thumb="box"}

---
The error message is legitimate: field dependencies was set to be "mandatory", and it seems as if that the jquery gantt editor ui doesn't expose this field to Tiki, therefore tiki complains that this mandatory field is missing. Or well, this is my own "educated guess" on what might be happening. I've removed the "mandatory" value in that field in the profile at profiles.t.o (but not in the show2.t.o linked to this bug report).

So that the problem here might be that the success message is fake? (just another educated guess) {sign user="xavi" datetime="2019-08-14T22:04:34+00:00"}

On Tiki 21.
To reproduce, go at : https://next.tiki.org/tracker22
Edit an item from the actions (wrench) menu on the right of the table.

The design is broken.

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

Tested on one of my Tikis from a plugin list, on save it also goes to the page "undefined" instead of staying on the page (refresh ?) (I tried updating a value and without updating a value)
https://share.vidyard.com/watch/XivK6CHsiD5MKVxLdnFX76?

Works on Tiki 20 with the same database and it works as previously:
https://secure.vidyard.com/organizations/230727/players/4Xs7Tyhok7peWDZUFLB8uv

Same if I want to delete an item from the wiki pages (tiki-listpages.php):
{img fileId="1367" thumb="box"}

But erasing it from the page itself work.

While trying to insert a file or image into a tiki page, the editor user interface will not load that image using "Browse Gallery" when that file is clicked on.
Please see show instance for 19.x and the same issue is present in tiki 20.x

If I want to look up all users which are waiting for the admin to validate them, I can do this LIST plugin:
{CODE(theme="default")}{LIST()}
{filter field="object_type" exact="user" }
{filter field="waiting" exact="a" }
{pagination max="9999"}
{LIST}{CODE}

This works fine using unified search with option ''mysql fulltext search''.

Using option ''Elastic search'' nothing is returned because "a" is in the stopwords list. Removing "a" from the stopwords list fixes the issue.

I can understand why stopwords are stripped from searches such as content="something". That's the idea of stopwords.
__But on exact searches stopwords should not be stripped__. Because, by the definition of "exact search", one knows exactly what one is searching for.

Also, we should not get different results depending on the unified search option.

As of 21.x and 22.x the elFinder gallery url's have changed. This has created issues with existing menu items that were pointing to a file gallery. The url's used before would have a trailing /file1 for a gallery.
Now using elFinder their is an extra trailing url attached that looks like this:

/file1#elf_f1_MQ

A show instance will be created, at the show instance you can turn elFinder on and off, and view the gallery url's change.

If the forum feature is enable, the Tiki stats are broken.

__~~#F00:UPDATE~~__: It may happen if there is no forum or topic or thread yet.
I created a forum, a topic and a few threads, refresh index, caches several times and I played with the code at lib/stats/statslib.php I got it to work. After 20mn the page was displayed without the error.

{CODE()}
Erreur système.
Le message d'erreur suivant a été renvoyé:

Column 'parentId' in where clause is ambiguous
La requête était:

select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`=? and `parentId`=?
Valeurs:

forum
0
La requête construite était probablement:

select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`='forum' and `parentId`='0'
{CODE}

You can see the error right on the tiki edu site: https://edu.tiki.org/tiki-stats.php
The error occurs, when forum feature is activated and stats page is being browsed within administration.
This error also happens, with a fresh install.

Second: The count of a wiki page visit is counting 2 instead of 1 visit!!

When using a mathematical field I created several times in the past a field to calculate the age of someone using:
{CODE()}(round (div (sub (date) childrenBirthDate) 31536000 ) 1){CODE}

In Tiki 20.1 (from Git; no revision number found) it thrown an error:
~pp~Divide by zero on "0"~/pp~

{CODE()}(sub (date) childrenBirthDate){CODE}
is not throwing the error.

The error is coming from a test at "lib/core/Math/Formula/Function/Div.php".

Updated 04/04/2020 {sign user="Bsfez" datetime="2020-03-04T19:59:04+00:00"}
After upgrading to Tiki21 the workaround is not useable anymore.
It forbid the index rebuilt operation to complete and therefore the Tiki is broken.
See: https://dev.tiki.org/item7304-Change-in-condition-inside-a-calculation-field-breaks-rebuilt-index-operation-and-calculation

---
Update 20/05/2020 {sign user="Bsfez" datetime="2020-05-20T09:07:12+00:00"}
Found the culprit ! (and it is not directly related to calculation ?)
I have in this tracker an item list field that get info from another tracker so I need to use trackerrender to display the original value and not the value of the dropdown item.
__It is not used for any calculation, it is the employee ID__
To display it I use:
{CODE()}
{FORMAT(name="id")}{display name="tracker_field_timeworkEmployeeId" format="trackerrender" default=""}{FORMAT}
{CODE}
Used that way I got the error:
~pp~Divide by zero on "0" ~/pp~

If I change the format for:
{CODE()}
{FORMAT(name="id")}{display name="tracker_field_timeworkEmployeeId_text" default=""}{FORMAT}
{CODE}

The error is gone.

This error message is from Tracker Mathematical Calculations.

This warning keeps popping up - can the warning be eliminated? Or, if I am incorrect and my mathematical calculation should instead be corrected, please advise.

{CODE(colors="tiki")}(round(div(div(date (sub futureDate (date)))60)60)1){CODE}

See more notes I added in the 'Forums' here - https://tiki.org/forumthread75298--Divide-by-Zero-warning

This is important because Tiki 21x is the latest LTS.

Adding Jonny and Victor as it seems you both tried to correct the issue.

thanks,
Mike

Symptoms:
- Website webdav "interface" (in web browser https://mydomain/tiki-webdav.php) is available, no issues
- when I try to open webdav in Mac Finder client (same address, same authorisation with username and password) I get following error:
"There was a problem connecting to the server "mydomain"
Check your server name or IP address, and then try again. If you continue to have problems, contact your system administrator."

TikiLogs says something strange:
TYPE TIME USER MESSAGE IP CLIENT
1214 system 4 minutes ago Anonymous 195.136.10.138 WebDAVFS/3.0.0 (03008000)...

Some extra notes:
- I'm using web server over SSL (with Let's Encrypt cert), but I was also trying to connect over regular http, same result
- TikiWiki 21.2
- regular installation on shared hosting
- I'm using _htaccess linked to .htaccess (ln -s)
- File Gallery on, WebDAV on

How can I help you finding the problem/solution?

In a new installation of branch 21.2, I get the error "H5P directory is not writable: storage/public/h5p". This is on a Windows laptop in a WAMP stack. After I manually make the storage/public/h5p directory, then the error no longer displays. I'm not sure if this happens only on Windows installations.

(Note: When creating an event in the calendar as an "All Day" event, it works as expected.)

When creating an event with a start and end time, the start time moves itself to the current time. Events appear on the calendar to span days. The end time looks correct.

When attempting to correct the start time, the clock now shows 7pm, December 31st, 1969 as the start. Changing the start time and saving it has no effect.

OS: OpenSUSE 15.1
Apache: 2.4.33
PHP: 7.2.5

Timezone is set to America/New York, system clock set to UTC. Clock appears correct in TikiWiki.

Expose ((doc:Action log)) data to the pivottable plugin. Some data can be seen through ((doc:Activity Stream)) feature, but it seems it only allows to display tracker item events, and something related to socialnetworking.

I don't know whether this means exposing the action log data to the unified search index or not, but exposing the activity in the site to admins to easily review and visualize with some charts and summary tables what's going on would be very helpful.

((doc:PluginGanttChart)) is a very promising feature in Tiki for real-world uses cases of project management

We lack the ability to filter results provided to the plugin gantt chart by means of filtering content from the unified search index, in an equivalent way to what it's possible in other ((doc:PluginList))-based plugins using [https://doc.tiki.org/PluginList-filter-control-block|the -+filter+- control block]. See examples:
* Filtering displayed tracker items based on values in a field (without user intervention)
+ https://doc.tiki.org/PluginPivotTable#Advanced_example_2
* Allow users to filter displayed tracker items based user input in a search form:
+ https://doc.tiki.org/PluginPivotTable#Advanced_example_3

What would be needed to get this GanttChart extended this way?

Thanks in advanced

You can reproduce this issue by means of applying the ((pr:GanttChart)) profile.

Example of coded shown in that profile:
{CODE()}
{GANTTCHART(trackerId="1" name="trackerganttTaskName" begin="trackerganttStartDate" end="trackerganttEndDate" roleId="trackerganttRole" status="trackerganttStatus" progress="trackerganttProgress" canWrite="true" canDelete="true" canWriteOnParent="true" description="trackerganttDescription" code="trackerganttCode" effort="trackerganttEffort" resourceId="trackerganttResourceId" order="trackerganttOrder" level="trackerganttLevel" depends="trackerganttDependencies" startIsMilestone=="trackerganttStartIsMilestone" endIsMilestone=="trackerganttEndIsMilestone")}
{filter field="tracker_field_trackerganttTaskName" editable="content"}
{filter field="tracker_field_trackerganttDescription" editable="content"}
{filter field="tracker_field_trackerganttResponsible" editable="content"}
{filter field="tracker_field_trackerganttEndDate" editable="content"}
{GANTTCHART}

{CODE}

The profile feature of Tiki is a really powerful tool, but it could be more flexible in processing user input before applying profiles.
Right now, it is only possible to request string (Input Text) data from the user during applying a profile .
I'm planning to do a really customizable profile, that can be configured via the user request form.
It should be possible to have more supported controls like checkboxes, radio buttons and (single/multi) dropdown selections.
Then these input data should also be used within a condition (IF/ELSE statements) to react on these user input during processing the profile apply.

__Example:__

Show a list of predefined groups an a offer to the admin user.
He can select, what groups are needed and which are then automatically set up by the profile:

[[ ] Group Sales
[[ ] Group Marketing
[[ ] Group Administration

Visuals possibly like:
* list of checkbox (multiple selection)
* radio button group (single selection)
* dropdown (Bootstrap) which can be used with single and multi selection

__Important:__
By having such controls available it is mandatory to be able to use them with conditions (IF/ELSE IF/ELSE) within the YAML code to be able to switch processing on the given selection.

__Further profile related ideas:__
* Secured profile repositories (password required, profile user which can be permitted)
>> Option to hide profile content to public and registered users

There are Fatal errors when applying "Random Header Images" profile in 20.x (using with php 7.2, in case it matters). However, in 19.x on the same machine it worked as usual with no errors.

Error message in apache:

{CODE(ln="1")}
[Sat Aug 17 17:46:56.382532 2019] [php7:notice] [pid 19032] [client ::1:44448] PHP Fatal error: Uncaught ArgumentCountError: Too few arguments to function Services_Tracker_Utilities::cloneItem(), 2 passed in /opt/html/20.x/lib/core/Services/Tracker/Controller.php on line 1479 and exactly 3 expected in /opt/html/20.x/lib/core/Services/Tracker/Utilities.php:585\nStack trace:\n#0 /opt/html/20.x/lib/core/Services/Tracker/Controller.php(1479): Services_Tracker_Utilities->cloneItem(Object(Tracker_Definition), Array)\n#1 /opt/html/20.x/lib/core/Services/Broker.php(108): Services_Tracker_Controller->action_link_items(Object(JitFilter))\n#2 /opt/html/20.x/lib/core/Services/Broker.php(28): Services_Broker->attemptProcess('tracker', 'link_items', Object(JitFilter))\n#3 /opt/html/20.x/tiki-ajax_services.php(51): Services_Broker->process('tracker', 'link_items', Object(JitFilter))\n#4 {main}\n thrown in /opt/html/20.x/lib/core/Services/Tracker/Utilities.php on line 585, referer: http://localhost/20.x/tiki-index.php?page=HomePage
[Sat Aug 17 17:47:08.779477 2019] [php7:notice] [pid 18804] [client ::1:44460] PHP Fatal error: Uncaught ArgumentCountError: Too few arguments to function Services_Tracker_Utilities::cloneItem(), 2 passed in /opt/html/20.x/lib/core/Services/Tracker/Controller.php on line 1479 and exactly 3 expected in /opt/html/20.x/lib/core/Services/Tracker/Utilities.php:585\nStack trace:\n#0 /opt/html/20.x/lib/core/Services/Tracker/Controller.php(1479): Services_Tracker_Utilities->cloneItem(Object(Tracker_Definition), Array)\n#1 /opt/html/20.x/lib/core/Services/Broker.php(108): Services_Tracker_Controller->action_link_items(Object(JitFilter))\n#2 /opt/html/20.x/lib/core/Services/Broker.php(28): Services_Broker->attemptProcess('tracker', 'link_items', Object(JitFilter))\n#3 /opt/html/20.x/tiki-ajax_services.php(51): Services_Broker->process('tracker', 'link_items', Object(JitFilter))\n#4 {main}\n thrown in /opt/html/20.x/lib/core/Services/Tracker/Utilities.php on line 585, referer: http://localhost/20.x/tiki-index.php?page=HomePage
[Sat Aug 17 17:52:25.749435 2019] [php7:notice] [pid 18795] [client ::1:45656] PHP Fatal error: Uncaught Error: Cannot use string offset as an array in /opt/html/20.x/lib/metadata/datatypes/exif.php:776\nStack trace:\n#0 /opt/html/20.x/lib/metadata/filetypes/jpeg.php(53): Exif->processRawData(Array)\n#1 /opt/html/20.x/lib/metadata/metadatalib.php(125): Jpeg->getExtendedData(Object(FileMetadata))\n#2 /opt/html/20.x/lib/filegals/filegallib.php(3857): FileMetadata->getMetadata('/tmp/wiki_MARur...', true, true)\n#3 /opt/html/20.x/lib/core/Tiki/FileGallery/Manipulator/MetadataExtractor.php(21): FileGalLib->extractMetadataJson('/tmp/wiki_MARur...')\n#4 /opt/html/20.x/lib/core/Tiki/FileGallery/File.php(215): Tiki\\FileGallery\\Manipulator\\MetadataExtractor->run(Array)\n#5 /opt/html/20.x/lib/filegals/filegallib.php(3321): Tiki\\FileGallery\\File->replace('\\xFF\\xD8\\xFF\\xE0\\x00\\x10JFIF\\x00\\x01\\x01\\x01\\x00...', 'image/jpeg', '2010_Barcelona_...', '2010_Barcelona_...', NULL, NULL)\n#6 /opt/html/20.x/lib/core/Tiki/Profile/InstallHandler/FileGallery.php(191): FileGalLib->upload_single_file(Array, '2010_Barcelona_...', 79046, 'im in /opt/html/20.x/lib/metadata/datatypes/exif.php on line 776, referer: http://localhost/20.x/tiki-admin.php?profile=Random_header_images_14&categories%5B%5D=20.x&repository=http%3A%2F%2Fprofiles.tiki.org%2Fprofiles&page=profiles&redirect=0&list=Find
{CODE}

Currently, Tiki does not have a feature to lock a specific user account.

Such locks can be essential. E.g. when you created a user account, but the user doesn't use it. For security reasons, you must lock it after a certain grace period. Either automatically or, as a fallback, manually.

Deleting is not a way to do this, because then you delete all preferences, so in order to preserve user preferences, but secure the site, a lock feature is IMHO essential. Admins should have the ability to lock user accounts. Actually this should be a perm of its own "Can lock user accounts", given by default only to members of the Admin group.

As a workaround, an Admin can create a new password (only known by him/her), but I believe a locking mechanism is more elegant. Also it removes the necessity for the user to re-establish his/her password after the lock gets lifted.

In a more sophisticated version, Tiki could inform members of the Admin group if a user that has a lock imposed on his/her account tries to login, that a login attempt was made.

I upgraded to 18.0 and got this error, then I upgraded to 18.1 and still got this error.

I erase the website, built a new database, and I still get this error.

When I try to upload a file to file gallery
MetArt01s.jpg
File upload failed: SyntaxError: Unexpected token < in JSON at position 0