Category: 21.x

Creating a new page (e.g. -+Foo+- through the form in the wiki structure top bar produces a missleading error message:
{CODE()}
Error. TikiLib::create_page: Cannot create page "Foo", it already exists.)
{CODE}

In addition, another remarksbox is shown below saying:
{CODE()}
Success
Page Foo saved (version 1).
{CODE}

However, the page is created indeed, and within the structure also.

You can reproduce it here:
http://xavi-9794-7136.show2.tikiwiki.org/tiki-index.php?page=D1+Cover
u: admin
p: 12345

Create a page called foobar (or any other name for a new page inside the structure) and you will see the issue reproduced.
{img fileId="1314" thumb="box"}

Wildcard items feature was added in ((doc:Tii17)), using some new functionality added in "item link/items list" tracker fields.

You can see it reproduced in the show2 instance linked to this tracker item, setup with
https://profiles.tiki.org/Wildcard_items

Once you link trakcer items from tracker2 "projext tasks" with an item from tracker1 "projects" and save the item in tracker1, the pId is lost from the linked items in tracker2.

Reproduced here:
http://xavi-9794-7119.show2.tikiwiki.org/tiki-ajax_services.php?controller=tracker&action=update_item&trackerId=2&itemId=18&modal=1
u: admin
p: 12345

Once you clik at the "update" button, the numbers selected in the pID from tab 2 "2) Tasks and resources": Checklist of Project Tasks, get lost. And instead, they should be kept, and the selected items with wildcard should be converted (afair) to the pID from that item.


And when you create a new project, and select some wildcard-item project tasks from the list, after saving their pID don't get converted from wildcard to the project number (as they should), but they stay as asterisk.

A tracker has been categorized (using admin category add cat to the tracker). (16 = 2019)
The same tracker has a category field for the same category selection. (16 =2019 or 17 = 2020, radio button or dropdown)

On the item level, in the field category the tracker category is forced ''displayed'' even if it is not select in the field. While it make sense on the code/configuration level, it is pretty weird visually for the admin or the user.

In the screenshot below, all the items are categorized (17) 2020
But they show on the list both category (the one from the tracker (16) 2019, the one from the item field category (17) 2020.
{img fileId="1446" thumb="box"}

Once you have selected a language for a page (Editing => Properties or on page creation) other than "unknown" you can’t select back "unknown".

Sometimes it is better to keep a wiki page language as unknown and use the TR tags (plugins) to have a page adapting to different language. Therefor it is important to keep the option to have language=unknown pages.

!!How to reproduce
#Go to the instance
#Login as admin
#Edit the homePage
#Set the properties=>languages to "unknown" save
#Check again it is back to English

#Go to the instance
#Login as admin
#Create a new page
#Keep the properties=>languages to "unknown" save
#Check again language = Unknow.
#Change language to en and save
#Try to change it back to "unknown" and save, it is not possible anymore

On Tiki 21.x not all items are displayed using list or customsearch with filter.

In the instance I created items that are filtered "May" are not found when filtering for it.
(the field that contain "May" is a mathematical field that extract the month from the date of the item)
It was working fine but after updating the Tiki 21.x it showed up.

My best guess is that it is because of the word length. (I experiment changing different fields and see what work and what doesn’t).

I know there is a php search limit for 3 char (ft_min_word_len=3) that too I experimented to see if it move something. But changing my.cnf settings and restarting innoDB didn’t help.

I tested on my local mamp, my clearOs server and in show instance. They show the same issue (so I believe it comes from Tiki and not some server settings)

I change the value of the min word length as explained at : https://dev.mysql.com/doc/refman/5.6/en/fulltext-fine-tuning.html#fulltext-word-length
(I did for both innoDB and MySIAM)

Changes were applied after a restart as Tiki check confirmed:
{img fileId="1410" thumb="box"}
{img fileId="1411" thumb="box"}

I checked I have in my index existing values for May
{img fileId="1412" thumb="box"}

I tested with May and June and the plugin list debug tool:
{img fileId="1413" thumb="box"}
{img fileId="1414" thumb="box"}

Same item filter (and field) was changed to "May2020" and it worked fine.
{img fileId="1415" thumb="box"}
Still this is not a solution to hardcode the year with the month (all templates should be edited each year and they may be other implications).

On a tracker item with category field (multiselect) the admin can assign during the item creation different category to an item.

User with "Can admin categories (tiki_p_admin_categories)" and field editable perm can’t even see the categories.

I created an instance that show the issue.

!!!Update (27/07/2020)
It turns out that when you modify "this" tracker permission, the global permissions on "Can change the categories of an object (tiki_p_modify_object_categories)" won’t be applied and will be then "saved" disabled even if you didn’t change anything for it.

This is a bug. If you don’t change a perm for an object (in this case a tracker but it may be valid for any object) the global should keep being applied.

All of the wizards use icons that are hardcoded, and this results in them being un-influenced by the choice of iconsets, so they can look out of place.

This should be switched to the way almost all other icons are used (declaration by a given name, and redirection in /themes/basefiles/iconsets.

Almost, because tiki-sheet also uses hardcoded icons (should also be switched one day).

While importing for WordPress 5.7, process reported all extracted data from XML file as expected. After reporting 49 posts as successfully imported, stops with message:

Out of range value for column 'activity' at row 1
The query was:
update `tiki_blogs` set `activity`=? where `blogId`=?
Values:
1. 100
2. 1
The built query was likely:
update `tiki_blogs` set `activity`='100' where `blogId`='1'

To verify that this was not caused by a specific post, I deleted the first 50 posts from de XML file and reran the import. Exact same scenario repeated (with blogId value incremented by 1).

Looking at the table tiki_blogs I thought that the field 'activity' may not allow for a value of 100 so modified to increase length by 1 digit and reran. It now works. Successfully imported all 393 posts.

I do not know if the error is caused by the data definition (field to short?) or the importer (value should not reach 100?) as I am not clear on what the "activity" column represents.

Any idea why this page: https://info.tiki.org/Add-Consultant
has a wrong browser title: "File Upload | Tiki Wiki CMS Groupware :: Community"
???
It should be: "Add Consultant | Tiki Wiki CMS Groupware :: Community"

In the file gallery you can set how many results you want displayed, but this setting is called (in find.tpl, line 261) ...

{CODE(Colors="Tiki")}
{tr}Displayed rows{/tr}
{CODE}

... "Displayed rows".

The default setting is 25, but not 25 rows are displayed, but just five. With five results per row, that makes 25 results, and not 25 rows.

Maybe this is a leftover from old days with line listings? Either change the label or the logic behind the setting, the former possibly easier to achieve :-)

Thanks
hman

In a Tiki 21.4 I get a WSOD (white screen of death / blank page) when I save a newly created page.

The page is created anyway and usable. The WSOD disappears when the browser is sent one page back or the site/page is loaded manually.

The bug __only__ occurs while __saving__ a newly created page for the __first time__.

After editing a previously existing wiki page, there is no WSOD after saving.

I did not yet test the behaviour for other versions, but I will add versions accordingly.

Tested in show instances:

Tiki 23.1vcs
http://bsfez-11581-7912.show2.tikiwiki.org
success - could not reproduce

Tiki 21.5vcs
http://torsten-11143-7928.show2.tikiwiki.org
success - could not reproduce

The WYSIWYG doesn't load the bars with size and font into the post (''and several other tools in the toolbar'') .
Please see this short video recording which explains and shows the issue:
[https://drive.google.com/file/d/1-kZWIMVLvu-Z9AO_C0nsPKupW194NYQ_/view|https://drive.google.com/file/d/1-kZWIMVLvu-Z9AO_C0nsPKupW194NYQ_/view]

Kind regards
PowerQuest

!!! Description
* I created a simple tracker with one text field.
* When I click on the ''View'' action link, the page ''tiki-view_tracker.php'' opens but stays blank.
* I tested again after having cleared my browser cache with the same error.

!!! Context
* Newbie
* First install of Tiki Wiki

!!! Environment
* Fresh install of version 21.2 (MyISAM) from last [https://www.softaculous.com/apps/cms/Tiki_Wiki_CMS_Groupware|softaculous script]
* Just activated the ''Tracker'' feature without changing anything else
* I use Firefox version 83.0 (64 bits)

!!! Errors and Warnings

{CODE( caption="From browser web console" wrap="0" theme="default")}

GET http://tiki-xxxxxx.myeu.cloud/tiki-view_tracker.php?trackerId=2 [HTTP/1.1 500 Internal Server Error 200ms]

Le cookie « javascript_enabled_detect » sera bientôt rejeté car son attribut « SameSite » est défini sur « None » ou une valeur invalide et il n’a pas l’attribut « secure ». Pour en savoir plus sur l’attribut « SameSite », consultez https://developer.mozilla.org/docs/Web/HTTP/Headers/Set-Cookie/SameSite

Le cookie « local_tz » sera bientôt traité comme un cookie intersite vis-à-vis de « http://tiki-xxxxxx.myeu.cloud/tiki-view_tracker.php?trackerId=2 » car le schéma ne correspond pas.

Le cookie « javascript_enabled » sera bientôt traité comme un cookie intersite vis-à-vis de « http://tiki-xxxxxx.myeu.cloud/tiki-view_tracker.php?trackerId=2 » car le schéma ne correspond pas.

Le cookie « javascript_enabled_detect » a été rejeté car il a déjà expiré.

Le cookie « local_tz » sera bientôt traité comme un cookie intersite vis-à-vis de « http://tiki-xxxxxx.myeu.cloud/tiki-view_tracker.php?trackerId=2 » car le schéma ne correspond pas.

Le cookie « javascript_enabled » sera bientôt traité comme un cookie intersite vis-à-vis de « http://tiki-xxxxxx.myeu.cloud/tiki-view_tracker.php?trackerId=2 » car le schéma ne correspond pas.

Sending APH request... antiphishing.js:9377:21

GEThttp://tiki-xxxxxx.myeu.cloud/favicon.ico [HTTP/1.1 404 Not Found 278ms]

Erreur dans les liens source : Error: NetworkError when attempting to fetch resource.
URL de la ressource : moz-extension://fd8f589c-0f5d-4619-b121-d40767cfb187/content/antiphishing.js
URL du lien source : syncpromise.js.map

Le cookie « local_tz » sera bientôt traité comme un cookie intersite vis-à-vis de « http://tiki-xxxxxx.myeu.cloud/favicon.ico » car le schéma ne correspond pas. favicon.ico

Le cookie « javascript_enabled » sera bientôt traité comme un cookie intersite vis-à-vis de « http://tiki-xxxxxx.myeu.cloud/favicon.ico » car le schéma ne correspond pas. favicon.ico

{CODE}

Hello everyone. Right now i am experiencing an issue while trying to upload a file using the the {FILES} plugin.

__What i did__
# I created a page and added the {FILES} plugin inside of it.

{CODE(wrap="1" theme="default")} {files galleryId="9" sort="name_desc" showtitle="n" showicon="y" showname="y" showfilename="n" showdescription="y" showmodified="n" showmodtimedate="n" showthumb="n" showupload="y" showaction="y" showid="n" showcreated="y"}{CODE}

# Then i added a simple .txt file by clicking the "browse.. " button.

# By click the "Upload" button i receive a blank page with url -+/tiki-upload_file.php+-


__tiki-syslog.php output__
# For my upload attempt i get this message
-+Request to /tiki-ajax_services.php failed CSRF check. Ticket does not match or is missing.+-

# When i try to enter into tiki-syslog.php i receive this log message
-+Request to /tiki-syslog.php failed CSRF check. Requesting site could not be identified because HTTP_ORIGIN and HTTP_REFERER were empty.+-

To be honest i don't know if those 2 messages are connected somehow

__Server Info__
* Release: Debian GNU/Linux 10 (buster)
* Database Version: 10.3.23-MariaDB-0+deb10u1
* PHP version: 7.3.19-1
*upload_max_filesize : 64M
*upload_tmp_dir: Unknown

Currently, the blog feature features only limited information, both for users and for admins.

For users, new blog entries should IMHO be listed in the since last visit module, currently they aren't.

For admins, blogs AND blog entries should be part of the statistics page, currently both aren't, so as admin, you only see the total number of blog page views, and have no clue, which of your blogs is more popular, and inside blogs, which entries generated the biggest audience...

When the site layout is set to "Classic Bootstrap (fixed top navbar)", and a site's title and subtitle is given, then the those will be shown twice.


Screenshot:
https://i.postimg.cc/RqrgKmXy/Tiki21-site-title.jpg


Steps for reproduction:
* Fresh install of Tiki21
* Look&Feel: Switched to site layout "Classic Bootstrap (fixed top navbar)"
* Removed the logo link
* Added title and subtitle

That's it.
Then you should get, what is shown on the screenshot.

This bug is also present in Tiki20.1.

There is a link from the installer (step 8) which is broken:
https://tiki.org/tiki-newsletters.php?nlId=8&info=1

Result is:
---
!An error occurred while performing the request.
Things to check:

* Did you complete the Tiki Installer?
* Is your database corrupt? Please see how to repair your database
* Are your database settings accurate? (username, schema name, etc in db/local.php)

Please see the documentation for more information.
---

Sheds bad light on Tiki if people cannot subscribe to "__Subscribe to Tiki Releases newsletter - Critical & Security update__" as advertised.

Hello,
Updating an article, there is a problem of images not saved when the Tiki interface is in French, image disappear from the article.

The problem do not occur when the interface is in English or other language.

I have fixed the problem and the solution I found is on your forum, ((https://tiki.org/tiki-view_forum_thread.php?forumId=6&threadId=76791&comzone=show|here))
https://tiki.org/tiki-view_forum_thread.php?forumId=6&threadId=76791&comzone=show

Sincerely
Patrice

At the last step in the tiki installer, site admin is offered to enter tiki with or without locking it . The two buttons to choose those actions overlap, and not all text from the second button can be read. Even in standard computer screens (not narrow)

Due to (I guess) change in the calculation field, the if condition or the way the index is rebuilt a previous condition to perform a calculation stopped to work and interfere with the rebuild index operation.

{CODE(caption="calculation that doesn't work")}
(if timeworkDateIn (round (div (sub timeworkDateOut timeworkDateIn) 3600)1))
{CODE}

The "if" here was checking if there is a value in the field "timeworkDateIn" to avoid a different error (Divide by zero on "0") that was displayed to the visitor of the site. After I upgrade this Tiki20 to Tiki21 I got an error on rebuild index:
{CODE()}
[root@server html]# php console.php i:r --log
[04-03-2020 09:48] Started rebuilding index... logging to file: /tmp/Search_Indexer_mysql_tsaharoniki_tiki21_console.log
Unified search engine: MySQL, version 10.1.44-MariaDB
error: The search index could not be rebuilt.
Variable not found "timeworkDateIn".
.../...
2020-03-04T09:48:36+02:00 INFO (6): addDocument trackeritem 53 {"memoryUsage":"22.3 MiB"}
(where it stopped)
{CODE}

I found a workaround see below, but we should have a way to keep it as is or to better verbose so the admin knows what to do.

{FADE(label="Long story" icon="y")}
I have a field that calculate time from 2 dates field to set a work clock.
Worker enter when he come to work and when he get out.
The calculation is done on save so data are updated constantly and the user can see results in real time.

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

It was working fine on Tiki20.

Since I upgraded to Tiki21 it has stopped to work.
(on the sample a new employee entered 3 row after the Tiki was upgraded)
{img fileId="1375" thumb="box"}

@Roberto: I think we have similar case setup as we worked together on some solution for a "Tiki" company :-) but else I can provide playground to help.

!!!Update1
I got an error on rebuild index:
{CODE()}
[root@server html]# php console.php i:r --log
[04-03-2020 09:48] Started rebuilding index... logging to file: /tmp/Search_Indexer_mysql_tsaharoniki_tiki21_console.log
Unified search engine: MySQL, version 10.1.44-MariaDB
error: The search index could not be rebuilt.
Variable not found "timeworkDateIn".
.../...
2020-03-04T09:48:36+02:00 INFO (6): addDocument trackeritem 53 {"memoryUsage":"22.3 MiB"}
(where it stopped)
{CODE}

trackeritem 53 is an old work clock item (closed).
The calculation was ok and all field looked ok.
I edited and saved and had the following error:
{CODE()}
The search index could not be updated. The site is misconfigured. Contact an administrator.
Variable not found "timeworkDateIn".
{CODE}

The field is here and the permaname is correct:
{img fileId="1376" thumb="box"}

Retested on the same Tiki still on version 20 (I kept for test) and there it is working fine.
(calculaltion are made, indexing is ok)

I escalated the bug to upgrade blocker.
If something corrupt a working index or block Tiki from indexing then it just kill the website (IMO).

!!!Update2
Above I see that the operation stopped very early, trackeritem 53 (I have more than 1500 trackeritems).
It stopped because it couldn’t find the field "timeworkDateIn" during a calculation.

I have 2 calculation field that use the same field "timeworkDateIn"
If I keep the first one and remove the second it work:
{CODE(caption="First calculation")}
(concat (date (str F) (str-to-time (str +0 day) timeworkDateIn)) (str |) timeworkName)
{CODE}

{CODE(caption="second calculation that doesn't work")}
(if timeworkDateIn (round (div (sub timeworkDateOut timeworkDateIn) 3600)1))
{CODE}

I reworked the code starting by the smallest value and up till the complete formula;
From: (sub timeworkDateOut timeworkDateIn)
To: (if (IsEmpty timeworkDateIn) NA (round (div (sub timeworkDateOut timeworkDateIn) 3600)1))
{FADE}

The class 'opaque calBox' from the calendar is broken. It is supposed to show the details of a calendar event, insted it shows raw Tiki syntax, in the case of a test event from admin on my site it is this that gets presented as text (!) to all users:
{CODE(Colors="Tiki")}
<div class=\'opaque calBox\' style=\"width:200px\"><a href=\"tiki-calendar_edit_item.php?viewcalitemId=323\" title=\"Details\">Testevent #3<\/a><p class=\"text-muted\"><strong>Erstellt von:admin<\/strong><\/p><br><\/div>
{CODE}

No matter what I search for, I can't find any profiles to apply, at all. When I attempted to "Refresh" the registries, I had a tcpdump running, which showed a 404 error from http://profiles.tiki.org/profiles

Hi,
Following a doc example, on a fresh TW21 docker install from tiki, I create 2 trackers:
1st has fields: name, sports (linked, multiple values)
2nd has fields: sport
entering 2 sports and 1 name with 2 practiced sports for the dude.

Now go to tiki-ajax_services.php?controller=tabular&action=create
and if you click "Initialize this format with the current tracker fields" (http://127.0.0.1/tiki-ajax_services.php?controller=tabular&action=edit&tabularId=4&prefill=1)
you get an error 382 according to Apache:

Fatal error: Uncaught Error: Call to a member function getMode() on null in /var/www/html/lib/core/Services/Tracker/TabularController.php:700 Stack trace: #0 /var/www/html/lib/core/Services/Tracker/TabularController.php(104): Services_Tracker_TabularController->getSchema(Array, true) #1 /var/www/html/lib/core/Services/Broker.php(108): Services_Tracker_TabularController->action_edit(Object(JitFilter)) #2 /var/www/html/lib/core/Services/Broker.php(28): Services_Broker->attemptProcess('tabular', 'edit', Object(JitFilter)) #3 /var/www/html/tiki-ajax_services.php(51): Services_Broker->process('tabular', 'edit', Object(JitFilter)) #4 {main} thrown in /var/www/html/lib/core/Services/Tracker/TabularController.php on line 700

I tried using old export function and, instead of flattening the values to a comma list, it exports to CSV with "Array" in place of the linked values.

I also tried to make a tabular, then manually change field definition to "multiple values" and it threw an error about "Field mode" and it removes the field.

Maybe I do it wrong, how to export (and import) linked fields with multiple values?

It looks like mode is in working for item_list relating to a item_link field, but it only shows the first value

Best fix qould be with option like item_list field where you can specify format like %0,%1 or [%0,%1] or else, to choose the way to export and import nested values.

Thank you!

EDIT: Visit
http://philmzo-11996-7378.show2.tikiwiki.org/tiki-ajax_services.php?controller=tabular&action=edit&tabularId=1&prefill=1
for the problem on TW21

At https://nextdev.tiki.org/tiki-admin_menu_options.php?menuId=47
I can't change the ordering of the menu options by ''drag and drop''. They just stay at the original place after mouse up.

Moving them as sub options by moving them to the right also gives weird results. They do move but not at the appropriate place.

When you click on an event in the calendar in calendar view, you cannot open the event to see details. In list view this works, in calendar view it doesn't...

It doesn't matter whether you click on the title of the event or the info-"i". Both are non-responding.

Furthermore, if the event has start and end times, the beginning time is displayed with broken formatting. Settings are "%H:%M:%S %Z" for long format, "%H:%M" for short format. Everywhere else Tiki shows the time correct. The mouseover of calendar parses incorrectly and displays a stray "%" between time and time zone.

Furthermore, the wrench symbol is non-responsive in list mode.