Category: 21.x

!!! 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.

Hello. Hope you're doing well.
I'm encountering an issue when i click on a tracker (from tracker list) and im getting a blank page. or whenever i click to view or edit tracker.

On inspect element (network) the GET request for the tracker have a 500 status every time i click on a tracker.

Among several, there is one very big limitation of the shopping cart:

It cannot handle currencies! I wonder why no one saw this before (and I have to add, when debugging the translation of Tiki, it did not occur to me either). Cart must store the currency linked to all products. The currency of the user must be user-selectable (Of course, at the admin's discretion, the set of available currencies must be limited). We need to modify the data structure. The currency MUST become a separate field, and with that the price becomes strictly numeric (It could and should be discussed if we make that integer in the small currency units, but display it with the decimal comman/point inserted) and the currency should be strictly the three-letter ISO code, but a representation of that could be selectable (€ for EUR for instance).

If user currency and currency of any stock item differ, currencies must be converted. Currency conversion isn't easy. The first and easiest solution is having fixed conversion rates. These MUST be prominently and transparently displayed to the user, as they become part of the contract between the user and the admin/owner of the Tiki. Also, some sort of fee for currency conversion must be selectable by the admin (0 of course being the default), and it, too, must be prominently and transparently displayed.

When fixed rates have been established, the next level of comfort might be automatically set/updated rates. For that, we would have to find a reliable provider. Also, since all providers might for some reasons fail to supply data at any given time in the future, a default minimum and maximum rate must be selectable by the admin.

At first, I thought this could have been overlooked because of a domination by the US, but then it crossed my mind that even Americans have the need for currency conversion, because they got US and Canadian dollars, and when they sell internationally, also Australian and New Zealand dollars...

In Europe it is much more complex. Most countries have the Euro, but not all. Great Britain does not, but now it's not even part of the EU anymore. In the German speaking countries we have Euros (Germany, Austria) and Swiss Francs. Even though Switzerland is also no member of the EU, the fact that a large portion of Switzerland speaks German leads to Swiss users using German Tikis, and vice versa.

When we check the option "Apply role permissions to sub-categories", it produces an error
{img fileId="1434" thumb="box"}

I have a site where saving (or cancelling editing) a wiki page wasn't working, you just get the same tiki-editpage.php back... After a lot of searching i found it was due to a php.ini setting called -+max_input_vars+- which defaults to 1000. And this site now has 1016 categories! (:eek:)

My proposal is to make a better category picker which can use a hidden input to contain a comma separated list of the category id's selected as on single input, instead of having 1016 individual checkboxes on the form.

So let's find a nice, hierarchical picker to do this, maybe a Vue JS one? Or maybe this should be an extension of -+object_selector_multi+-

When changing a name of custom module, a new module is being created with all the changes.
It should update the existing custom module and not create a new one.

A German court has ruled that websites that utilize Google fonts possibly violate the GDPR, and the owner of such a site is liable for that.

At first look, this sounds over the edge, but when looking deeper, the court's legal findings are stringent. If a website loads Google fonts, it makes the browser of users load the fonts from Google, thereby compromising personal data to Google.

If the user in question did not agree to this disclosure of personal data to Google (and the site owner can prove that), than it is a clear violation of the GDPR. The user then doesn't know about this disclosure of data, and cannot do anything to prevent this.

Therefore it is advisable that all demo Tiki stuff, including themes, be either stripped of Google fonts, or the fonts should be loaded directly from the site, or the users of such themes be told that the unaltered use of these themes comprises a GDPR violation, which can be fined (for companies) with up to 20 million Euro or 4% of a year's turnover (not profit!), whichever is higher...

When ''chosen'' is active, the ''Reset'' button does not reset dropdowns any more.

Simple input fields work fine (i.e. they are voided) but dropdowns just keep their values.

Without ''chosen'', all works as expected.

Let's spare time and resources and recycle a past existing show2 instance :-)
[http://jyhem-9952-7502.show2.tikiwiki.org/tiki-index.php]

If you enable "Offer to save passwords" and save your Tiki login and password on [https://wikisuite.chat], each time you reload a page with converse.js in a popup e.g. on [https://wikisuite.chat/About] or [https://wikisuite.chat/P%C3%A0d%C3%A9] Chrome pops up a blocking dialog saying "Sign in as (your username)" and then scrolls you to the bottom of the page, which is really quite annoying. It seems fine on the home page where converse.js is embedded in the page.

It also doesn't seem to happen on [https://conversejs.org] after the first page load, so seems to be specific to the Tiki implementation.

{CODE()}[root@ip-xxxxx html]# php console.php files:batchupload 5 --confirm
<feedback>feedback: Image was reduced: %s x %s -> %s x %s
</feedback>{CODE}

*HTML feedback is returned when using the console.php: It should be returned without tag.
*Un-needed or malformed feedback was returned: If no reduction it should return nothing or something like "Images where upload at original size".
*Expected message is missing: Should return something like "n files were successfully uploaded" (can be improved with the files, path and galleryId ?)

Is it returned only when all files are images or even if files are PDF (message is not relevant and erroneous)

---

*HTML feedback is returned also for tracker:import
{CODE()}
<feedback>feedback: 9 tracker(s) item(s) updated
</feedback>
{CODE}

See first the box saying "Even better" below.

"__PluginTogether should replace the url associated with the Edit page button so that co-editors are automagically offered to go to the session with collaborative edition instead of the warning of edition conflict__" (was --"Clicking on PluginTogether on a wiki page should provide a CoEdit button next to Edit with the right url for all."--)

This would be useful for taking meeting minutes collaboratively in the ((tw:TRM)) and ((tw:TAG)) meetings, both which take precious time from some active tiki community members but with little time to do things properly (wasting precious time in this note-taking task instead of being able to invest it in other areas requiring their help too). {sign user="xavi" datetime="2017-01-12T13:09:23+00:00"}


I've been trying to use tiki for many semester with my students at uni but I can't get them to use it with realtime collaboration with ease, so that they move to googledocs.

This minor usability change would be probably enough to convince teams to use tiki realtime collaboration feature with plugin togetherjs.
Like ourselves when taking notes on a roundtable meeting, or tiki admin group meeting, etc.
{BOX()}
__Even better__
Even easier for the end user would be to just offer a user that sees the concurrent edition warning box, a link to carry on and convert the session into a togetherJS session in which both users continue writing together. In the backend, tiki would probably:
# A new general preference should be added for this new behavior to be enabled
# when user A clicks at edit a wiki pageFoo, the url that would be created by PluginTogether is stored in tiki mysql tables somewhere, with a semaphore/flag or similar so that tiki knows that this page has been started edition and the url to allows others to go into the same edition session collaboratively.
# when user B clicks at the __Edit__ button of the same pageFoo, while still being edited by userA, userB sees the warning of edition conflict unless userB accepts to request to userA to enter into the collaborative session.
# If userB accepts to request that coedition to userA, then UserA would see some warning about that request from userB in some popup/modal/or similar, with the option to accept and get his edition saved and restarted as online collaboration among both, or reject the request, and keep writing himself alone in that page.
# therefore, save the edition in place by user A (the one that started editing the page first)
# reopen that page for edition for user A with te url adapted to the togetherjs session, and
# send user B to the edition session with togetherjs (or alternatively, show userB the same link to open the page for edition).
# if userA accepted userB to write together, they both are working with TogetherJS on that page. And in that case, when other users such as userC clicks at edit the wiki pageFoo again, userA gets the same message requesting to confirm to accept new users getting the collaborative session, and when accepted, since the TogetherJS is already on, there wouldn't be any need to restart the edition session with togetherJs since it would be already in that mode.
{BOX}

---
This is currently partly working in 21.x LTS {sign user="xavi" datetime="2020-04-01T10:32:07+00:00"}:
* user is sent automagically to open the session without "Warn on edit conflict"
* ... __BUT the together session fails to display the other users being there editing the page concurrently__:
** therefore, a new version is saved, without noticing that the versions will not be seen by each other: -+Edit Conflict triggered+-.

To reproduce the updated problem info:
Come here with two different browser engines (or one in provate browsing and hte other in normal, as usual to test this feature):
http://xavi-9794-6160.show2.tikiwiki.org/tiki-index.php?page=HomePage
user1:
u: admin
p: 12345

user2:
u: user
p: 54321

# Click on button of the side module "Co-Write with TogetherJS"
# Edit homepage as user1 (admin) in browser engine1 (e.g. firefox)
# Edit homepage as user2 (user in browser engine2 (e.g. chromium)
** accept the popup asking to join session

problem triggered: none can see that the other user is editing the page, saving, moving elsewhere, etc.

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

Cliking on marker of any geolocated wiki page on a map produces no popup box anymore (it shows "loading...")
Other geolocated items work as expected regarding this feature, afaik
Reproduced with "GeoCMS Maps_18" profile o 18.x, 20.x, 21.x and trunk. as of today {sign user="xavi" datetime="2020-02-22T13:18:46+00:00"}
See it reproduced here:
http://xavi-9794-7275.show2.tikiwiki.org/tiki-index.php?page=Map-of-Wiki-pages
u: admin
p: 12345
(using trunk)

Otherwise it prevents the page to be scrolled or doing anything one would expect to normally do. Reproducible while editing the tracker items here on dev.tiki.org too.