Category: 18.x

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;

There is no search option on Tiki Webmail.
This is not really an option for real life usage and a search feature is much needed.

At https://doc.tiki.org/tiki-searchindex.php?filter~content=wiki+syntax&search=Search

Part of the results are not accessible (clickable): results 5, 7, 8, etc.

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

I'm using the last LTS Tikiwiki version (18.1) on Apache 2.2/PHP 5.6/Mysql 5.5.

I configured Tikiwiki with "Web server" authentication method.
Using Firefox (no problems with Chrome), when I logout from Tikiwiki, the browser alert me with this popup:
"You are about to log in to the site "ww.example.com" with the username "admin", but the website does not require authentication. This may be an attempt to trick you.
Is "www.example.com" the site you want to visit?"

Looking at code, I found this suspect line (336) of "lib/userslib.php" :
header('Location: ' . str_replace('//', '//admin:@', $url)); // simulate a fake login to logout the user

Semantic links are creating dead links when a "-" is in the name and under some other unknown conditions. I suspect it may in part be a regression caused by the recent way links are named.

You can see one example here: https://dev.tiki.org/Visual-Programming

At the bottom of the page, the aliases are listed. One of them is "End-user Programming" which creates a link of https://dev.tiki.org/End-user-Programming. The issue is, that does not redirect to the Visual Programming page. It is a 404-not found page. There are also 2 examples at the bottom of this page: https://dev.tiki.org/Browser-Compatibility that behave in the same way.

I also see alias is not working here as well: https://dev.tiki.org/Update. In this case, all of the alias links are dead, but there are no dashes used within the links. Perhaps a separate issue?

The Shop profile does create two new groups: Customers and Managers. Managers get some permissions in regard to payments, but none for trackers. This means Managers aren't allowed to populate the products tracker with items, only admin can do that. Also, they aren't allowed to remove tracker items. The entire permissions roster should be checked for consistency.

Also, it should be checked whether or not tiki_p_view_category should be granted to anonymous, otherwise the category won't be output in the shop. Another story is tiki_p_list_trackers. In the default shop profile, this is granted to anonymous, but still for some reason only the admin can list the products tracker?

Thanks
hman

Show.tiki.org is not working (connect db error)

Update 10/05/18: https://show.tiki.org/tiki-check.php
{img fileId="1205" thumb="box"}

Update 2018-09-16
Down again: The connection has timed out {sign user="luci" datetime="2018-09-16T17:08:09+00:00"}

To differentiate pages which use the redirect plugin from true orphan pages we long ago adopted a convention of adding ~np~{Redirect}~/np~ to the page description of such pages. This makes hunting true orphans much easier for us.

Show Pages attempts to wiki parse the page description resulting in

Test2-Page1 - Page 1
Test2-Page2 - Page 2 REDIRECT plugin: No page specified!
REDIRECT plugin: No url specified!
REDIRECT plugin: No perspective specified!

Neither TOC nor LISTPAGES fail in this way.

This __''may''__ be a regression issue somewhere between v6.7 and 15.5

Actually the site close page and message are partially custom, not translatable and use discutable mechanism (URL parameters).

See: https://tiki.org/forumthread77173-Translation-for-tiki-site-close-page-tiki-error_simple-php

And : https://tiki.org/Roundtable-Meeting-2021-07

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

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

---
We need a mechanism to assure:
* Message customisation
* Translation
* ...

Even if everything is down (php and database).
---

We don’t have a lot to do to achieve customisation and translation.
We need to have fields for:
* Retry (refresh ?)
* User
* Password
* Login (button)

I suggest as first step having those field for easy customisation translation (one language). Adding a link to the "page" displayed so it easy to integrate one from a theme.


Related:
* https://www.wpexplorer.com/wordpress-maintenance-mode-coming-soon/
* https://wordpress.org/plugins/coming-soon
* https://wordpress.org/plugins/disable-site/
* https://www.drupal.org/docs/user_guide/en/extend-maintenance.html

Today I solved a longstanding issue, that I could not (for several years and many Tiki versions) load a site logo other than HTML-pointing to an image file, which thus had to be FTP-uploaded, and would not be as easily changeable as an image from an image or file gallery.

My error lies in the documentation of the Look & Feel page, where the blue info text clearly says " or the syntax to display an image in a Tiki gallery". That is not quite correct. It's not entirely wrong, but misleading.

The solution: Enter
tiki-download_file.php?fileId=nn

That works. The syntax to display Images from a gallery would have brackets around, so I would like to ask that this info text include the advice to leave out the brackets.

I have seen twice in the last 2 weeks the same bug pattern involving the Smarty icon function. When the global $iconset variable read by the function is not defined as expected, the function may fallback to ~np~$params['_id'] = 'green_question';~/np~ even if the name parameter was specified, so a green question mark displays instead of the icon supposed to show.

I have seen this:
# On tiki.org, following [https://tiki.org/forumthread69171-Strange-question-marks-on-tiki-org|a report on tikiwiki-devel]
# On [http://erikqvam-11905-6586.show.tikiwiki.org/tiki-index.php|this show instance], for at least 3 icons (those for the Modules, Permissions and Plugin approval entries of the Quick admin menu)

This persists until the server cache is cleared. I do not know how to reproduce after.

The impact is amplified by improper handling of smarty_function_icon() when it fails to find the requested icon. There should at the minimum be a PHP notice logged, and the question mark image should have a clear label such as "Unknown icon", not "Question".

While we have very effective tags and social network tools they are not working as expected at Tiki.org.

When I look at : https://developers.facebook.com/tools/debug/og/object/?q=https%3A%2F%2Ftiki.org%2Farticle455-Happy-16th-Birthday-Tiki

Everything seems ok but at https://www.facebook.com/groups/6607687318 look at the way the article from tiki.org look like and how the article from my own Tiki look like:

{img type="fileId" fileId="1231" thumb="box"}

In a wiki page I set the plugin img (image) to use an image from "anywhere on the internet".
Several options are not working:
* Thumbnail (no matter what I choose I see the image full-size)
* Image size (no change or image not displayed, Setting width to 50% won’t change anything)
* ...

If I change to use an image from the file gallery it work just fine.

Please check the instance: http://bsfez-11581-6081.show.tikiwiki.org/

Doing some search on duck duck and google about upgrading Tiki to 18.1 i got the following results;

https://tiki.org/tiki-view_forum_thread.php?forumId=26&threadId=68561&comzone=show
https://tiki.org/forumthread68555-Fatal-error-upgrading-from-17-1-to-18

"This page isn’t working
tiki.org is currently unable to handle this request.
HTTP ERROR 500"

If I search for i.e. "groups" I will receive results I cannot open. No link is behind the entry. This happens on doc.tiki.org. See: [https://doc.tiki.org/tiki-searchindex.php?filter%7Econtent=groups&storeAs=]

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.

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"}

Tikis spreadsheet readily divides by zero - I expected to get an error message (which I wanted to translate), but I got none. And even more curious: Tiki presents a numerical result from the division by zero, also "0"... !

The correct result would be infinity, but infinity is not a number, it is a behaviour (lim, limes rising above ALL existing numbers) - therefore ALL calculators and calculating spread sheets display an error message upon any division by zero.

When you extend one of the two drop down menus ("View" and "Style") two things can be observed (besides the fact that View and Style do not translate): The menus are in the background, i.e. ''behind'' the icons... They should extend in the foreground, thus be painted over the icons, partially obscuring them...
Thanks
hman

Clicking on fullscreen view doesn't do anything. No matter wheter you take the small icon in the upper right corner, or the menu item under "View". Nothing happens.

The same goes for comparing two sheets. I have six revisions at the moment, no matter which two I select and click on compare, the page simply reloads, but doesn't do anything else. No comparison visible...

The history of Spreadsheet completely ignores all date und time rendering prefs, and renders timestamps in US format, see screenshot (attachment).

Also note that the "compare" button doesn't translate due to a missing tra().

Spreadsheet has many options. But I wondered why two of the "add" features translated the same, even though they are different. "insert before" and "after".

The reason lies in a logic error in the template (/templates/tiki-view_sheets_menu.tpl), most likely a copy&paste error.

{CODE(Colors="Tiki")}
<li><a onclick="sheetInstance.controlFactory.addRow(null, true); return false;" title="{tr}Inserts an additional row after currently selected row.{/tr}">{tr}Insert Row Before{/tr}</a></li>
<li><a onclick="sheetInstance.controlFactory.addRow(); return false;" title="{tr}Inserts an additional row after currently selected row.{/tr}">{tr}Insert Row After{/tr}</a></li>
{CODE}

On Tiki 18 alpha during the DB installation I have errors related to Kaltura.

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

{CODE()}INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/AdminConsole/Service/ReportAdminService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'
INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/AdminConsole/Service/UiConfAdminService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'
INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/ContentDistribution/Service/ContentDistributionBatchService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'
INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/ContentDistribution/Service/TvComService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'{CODE}

The diagrams of site statistics cannot handle if in the translation diacritic characters like German umlauts are used, instead some random looking special characters are rendered. In German "FAQ" are "Häufige Fragen"...

TW really should not be sending spoofed e-mails.

Wiki content watches, Structure Watches, Tracker Notifications etc use the system wide sender e-mail address as set on Control Panel -> General in the Mail sub section of that page to send their notification e-mails.

However, it seems as though e-mail notifications generated by the Inter User Messaging system don't use this system wide sender e-mail address. Rather it sends messages with a spoofed e-mail address of the user who is to receive the e-mail.

As Mail Service Providers rightly tighten their spam filtering techniques, Message notification e-mails sent by TW are getting impacted.

Might TW avoid this issue by providing admins with an option to also use the system wide e-mail sender address for Message notification e-mails, please?