Category: 19.x

jQuery tablesorter allows to control the maximum number of rows to display in a table. When the number of data records exceeds that maximum, the pager widget or the pager plugin paginates the data on multiple pages. tablesorter, for example on tiki-listpages.php, therefore displays a pager area which at the top of each table. This area provides controls to change the maximum number of rows in a page and to select the page to display, as can be seen in the attached screenshot.

This area can not only display at the top of tables, but also at the bottom, so that when one scrolls through a dataset from start to finish, there is no need to go back to the top to continue to the next page. There is however an optimization so that the pager does not display twice at the same time in the viewport. lib/core/Table/Code/Bind.php line 33-39 (in Tiki 18) either show or hide the bottom pager:
{CODE(colors="php" theme="default")}
if (this.config.pager.endRow - this.config.pager.startRow > 15) {
$('div#listpages1-pager.ts-pager-bottom').css('display', 'block');
} else {
$('div#listpages1-pager.ts-pager-bottom').css('display', 'none');
}
{CODE}

This is based on a rule of thumb which estimates that a viewport fits 15 rows. When browsing 70 records and viewing records 1 to 25, endRow has the value 25 and startRow has the value 0, so the difference between the 2 is 25, which is more than 15. Therefore, the bottom pager's div is displayed.

This code is run whenever the pager is used, plus at page load. The code works fine once the page has finished loading, but on page load, it is unfortunately fragile. When this code is first run, endRow has the value 0, so the difference is always 0 and display is always set to none. The initial display is fine in Tiki 15 up to 17 because this code (which runs when the tablesorter-ready event occurs) runs several times during page load, and endRow has the correct value the last time the code runs. In Tiki 18 the code only runs once per page load. This would be a good thing for performance, except that this one run is unfortunately too early, so the difference is always 0.

As I verified Tiki's related code seems unchanged between Tiki 17 and 18, I imagine this regression comes from the upgrade of jQuery tablesorter from 2.28.5 to 2.31.1. This persists in Tiki 19, and in trunk as of r70207.

Keep color highlighting from PluginCode at the mpdf printed version

When you print a page with plugin code and color highlighting enabled (through codemirror), the mpdf produced page doesn't keep the colors.

Some code to easy copy & paste to any tiki 18.x install with mpdf:
https://dev.tiki.org/CodeMirror+Testing+v3

When the page param is used it shows current date and time instead of the last modification of the specified page.
See https://doc.tiki.org/PluginLastMod#Examples

With 19.1, the LDAP and LDAP external items in the Admin->Log In 'option' is a bit (for lack of a better word) confusing and two check boxes are in the wrong place.

1) As mentioned in ticket 7035, the LDAP user field settings is in both the LDAP section and the LDAP external group section. If the LDAP user field settings do the same thing, I would believe the LDAP user field should be in the "external group section".

2) Relatedly, the "LDAP External group" I believe it really should be renamed "LDAP external source". (Though I would hazard a guess that even this isn't right... just putting it out here as a suggestion).

3) Under LDAP external group, in the "LDAP user" settings, the checkbox is wrong "Synchronize Tiki groups with a directory". This really moved to the "LDAP group" part.

4) Under LDAP external group, in the "LDAP group" settings, the checkbox for "Synchronize Tiki users with a directory" should be in the "LDAP user" part.

With the switch from Pear Net_LDAP2 to Zend\Ldap, the LDAP authentication to the AD is broken in Tiki 19.1.
With exactly the same configuration as with Tiki 18.3, I get this error message in the Action Log:
{CODE(theme="default")}Error: 0x31 (Invalid credentials; 80090308: LdapErr: DSID-0C090400, comment: AcceptSecurityContext error, data 52e, v1db1): sAMAccountName=wiebe.oudshoorn,cn=users,dc=moba-bv,dc=local at line 262 in D{CODE}

I have done some research with WireShark to inspect the packages from and to the LDAP server, when someone logs in to the wiki:

Tiki 18.3:{img fileId="1287" thumb="box"}

Tiki 19.1:{img fileId="1288" thumb="box"}

It's very clear where this is going wrong. It's trying to do a bind request with only the username instead of username@domain.url (row 355 in 18.3 screenshot vs row 239 in 19.1 screenshot ).
Although LDAP bind type is set to 'AD', so according to lib\auth\ldap.php row 184 it should add the correct information to the bind request instead of performing a 'plain' bind.


My LDAP settings:
{img fileId="1289" thumb="box"}

let "Dynamic items list" feed on a dynamic drop down (items link) to have several dynamic lists.

See this scenario with a form including Region > City > Suburb:
You chose Region
Cities get populated according to region. You choose region.
Suburbs get populated according to city.

According to the documentation for dynamic items list, cities are inserted in another tracker, as a text field linked to a hardcoded dropdown with REgion names.

In order to have suburbs populated dynamically from that tracker, sylvieg said that there is some code missing to allow dynamic items list feed on an item list, and not just a static drop down.

I noticed in our -+vendor_bundled/composer.lock+- that some packages slipped in which are GPL or Apache licensed only (not compatible with LGPL), which might be a release blocker for us, namely:
* https://github.com/h5p/h5p-php-library
* https://github.com/h5p/h5p-editor-php-library (Although it claims MIT the https://github.com/h5p/h5p-editor-php-library/blob/master/composer.json says GPL only)
* https://github.com/BafS/Testify.php (license mentioned in https://github.com/BafS/Testify.php/blob/master/composer.json)
* https://github.com/farbelous/bootstrap-colorpicker (Apache 2.0)
* https://github.com/apereo/phpCAS (Apache 2.0)
* https://github.com/zetacomponents/Webdav (Apache 2.0)
* https://github.com/zetacomponents/Base (Apache 2.0)
* https://github.com/ahand/mobileesp (Apache 2.0)
+ {QUOTE(source_url=https://opensource.stackexchange.com/questions/5664/linking-from-lgpl-2-1-software-to-apache-2-0-library)}The incompatibility of Apache-2 and GPL-2 is well documented. If your software is a combined/derivate work with/of Apache-2 software, you cannot license that software under the GPL-2 and therefore cannot license it under the LGPL-2.1 either.{QUOTE}
* https://github.com/conversejs/converse.js (MPL 2.0) (not quite sure about this one but [https://dwheeler.com/essays/floss-license-slide.html|the diagram] does not indicate it is compatible with LGPL 2.1)
* https://github.com/kaltura/KalturaGeneratedAPIClientsPHP53 (AGPL 3.0)
* https://github.com/PHPCompatibility/PHPCompatibility (LGPL 3.0+ - not sure it can be included in LGPL 2.1)


{DIV(class=lead)}For more details see https://tiki.org/License{DIV}

See:
{img src="https://dev.tiki.org/tiki-download_item_attachment.php?attId=496&display" thumb="y"}

I tested Trunk on my Ipad (IOS11 Safari).
The login popup for a default install is outside the screen (landscape and portrait).

On the Tiki Webmail (tiki-webmail.php) there is a selector to choose what mailbox folder to display:
__Inbox__
Draft
Queue
Sent
Trash

Seems only Inbox shows something.
Sent and Trash are not working (email sent or trashed are not displayed).

About the others, I’m not sure what should be done;
* Do a user need to see the queue ?
* Tiki Webmail can't create/save draft yet

(asking in the dev list)

This is mainly a test bug report so we can try to make show instances on the two show servers for testing, and not get any existing bugs muddled up

__Unified Index:__

Works both in Elasticsearch and MariaDB
This works: https://dev.tiki.org/Wishlist-Search-Page

But:
https://dev.tiki.org/Tiki19#Open_or_Pending_blockers_and_regression works with Elasticsearch but not MariaDB

Code copied below:

{CODE()}
{LIST()}
{filter content="5" field="tracker_id"}
{filter field="tracker_status" content="o OR p"}
{filter field="tracker_field_version" content="331"}
{filter field="tracker_field_category" content="265 OR 172"}
{filter field="tracker_field_resolution_status" content="New OR Accepted OR Confirmed"}
{* sort mode="modification_date_ndesc" *}
{sort mode="tracker_field_priority_ndesc"}
{OUTPUT(template="table")}
{column field="mod_date" label="LastModif" mode="raw"}
{column field="tracker_status" label="" mode="raw"}
{column sort="tracker_field_resolution_status" field="tracker_field_resolution_status" label="Resolution Status" mode="raw"}
{column sort="tracker_field_submitted_by" field="tracker_field_submitted_by" label="Submitted By"}
{column field="tracker_field_assigned_to" label="Volunteered" mode="raw"}
{column field="tracker_field_subject" label="Title" mode="raw"}
{column label="Category" field="category" mode="raw"}
{column sort="tracker_field_version" field="tracker_field_version" label="Version" mode="raw"}
{column field="tracker_field_feature" label="Feature" mode="raw"}
{column sort="tracker_field_priority" field="tracker_field_priority" label="Priority" mode="raw"}
{tablesorter server="n" sortable="y"}
{OUTPUT}
{FORMAT(name="mod_date")}{display name="modification_date" format="date"}{FORMAT}
{FORMAT(name="tracker_status")}{display name="tracker_status" format="trackerrender"}{FORMAT}
{FORMAT(name="tracker_field_resolution_status")}{display name="tracker_field_resolution_status" default="" format="trackerrender" editable=inline}{FORMAT}
{FORMAT(name="tracker_field_submitted_by")}{display name="tracker_field_submitted_by" format="trackerrender"}{FORMAT}
{FORMAT(name="tracker_field_assigned_to")}{display name="tracker_field_assigned_to" format="trackerrender" editable=inline default=""}{FORMAT}
{FORMAT(name="tracker_field_subject")}{display name="tracker_field_subject" format="trackerrender"}{FORMAT}
{FORMAT(name="category")}{display name="tracker_field_category" format="trackerrender"}{FORMAT}
{FORMAT(name="tracker_field_version")}{display name="tracker_field_version" format="trackerrender"}{FORMAT}
{FORMAT(name="tracker_field_feature")}{display name="tracker_field_feature" format="trackerrender"}{FORMAT}
{FORMAT(name="tracker_field_priority")}{display name="tracker_field_priority" format="trackerrender" default="" }{FORMAT}
{LIST}
{CODE}

{syntax type="tiki" editor="plain"}
Rendering of mixed un-numbered and numbered lists has issues in tiki wiki pages, e.g.,

```markdown
* unnumbered level 1
* unnumbered level 2
1. numbered level 3
* unnumbered level 4
2. numbered level 3
```

should be rendered like

```markdown
* unnumbered level 1
* unnumbered level 2
1. numbered level 3
* unnumbered level 4
2. numbered level 3
```

but tiki actually renders it to

```markdown
* unnumbered level 1
* unnumbered level 2
1. numbered level 3
2. unnumbered level 4
3. numbered level 3
```

Apart from "unnumbered level 4" item getting numbered (I get unintended numberings of list items quite a lot in tiki),
the actual spaces before each bullet point/number seems to not follow any common convention but appears to be basically random.

To best of my knowledge, two blanks before the first numbered item below an unnumbered item should be used
to make it align properly under the text of the unnumbered item above.
But tiki renders the above with an unintended huge indention for the "unnumbered level 4" item.

commonmark renders this just fine, see

https://spec.commonmark.org/dingus/?text=*%20unnumbered%20level%201%0A%09*%20unnumbered%20level%202%0A%20%20%20%20%20%201.%20numbered%20level%203%20%0A%20%20%20%20%20%20%20%20%20%20*%20unnumbered%20level%204%20%0A%20%20%20%20%20%202.%20numbered%20level%203%20%0A%60

There seems to be no way to properly include code blocks here. I will try show2.tiki.org...
...does not work either "Lost Tiki database connection".

Please check the source of this post to better understand the issue.
Thanks.

One of the key features of Smartmenus is to enable more menu levels than the two that Bootstrap supports out of the box. But this isn't happening yet with Tiki's menus in branch 19.

Also, the down arrows in parent items display briefly but then slide into/behind the item text so they no longer display.

I categorized this "Dogfooding" because people have been requesting it and also I want to check out its full functionality at themes.tiki.org.

More info: Section level 3 items (and their child items) are ignored in the menu implementation when the menu type is "Bootstrap", so Smartmenus has nothing to work with where level 3 should be (just a detail).

I wanted to edit the CSS for themes/fivealive-lite/css/blueberry but there is nothing in that dir?

Allow to override global setting to create toc in a specific page through PluginPdfPage
Otherwise, you get 2 table of contents in a wiki page ifyou have that parameter set globally in print control panel, and you also have toc in a long wiki page in production.

Example (where you can't override that setting):
http://seeds4c.org/Ubuntu+16.04+LTS+for+Human+Beans

mpdf doesn't seem to include content displayed through plugin map.
Tested using latest 19.x with mpdf (7.1) installed through control panel to install packages

See it reproduced here:
https://adup.cat/Inici#contentpestanyes_trobades-4

At https://tiki.org/forumthread70022-mpdf-Generates-Black-PDF-docs

Logged, I tried to check the PDF feature by going to the "Thread actions", click on the item "PDF".

It downloaded a blank document onto my computer.

Tested on Tiki24 still here.

mpdf (tested in latest 19.x svn and latest mpdf from composer - through packages control panel) doesn't seem to include content from plugin REMARKSBOX.

See it reproduced here:
https://adup.cat/181218

Some accents are mangled from wiki page headings when printed in the pdf produced by mpdf 7.x

{CODE()}
! {{page}}
!! Full de Càlcul Oficial (Mònica)
text
!! Previsió inicial GID
(...)
some convene plugin, ...
{CODE}

Produces:
{CODE()}
Table of Contents
GID -Â Vacances ..........................................................................................................................
2
Full de Cà lcul Oficial (MÃ2nica) ......................................................................................
2
PrevisiÃ3 inicial GID ...........................................................................................................
2


GID -Â Vacances
Full de Cà lcul Oficial (MÃ2nica)
text
PrevisiÃ3 inicial GID
(...)
some convene plugin, ...
{CODE}

when trackers set to show comments below tracker items, and section headings are shown as tabs: comments are shown below each one of the tabs of the tracker item printed (therefore, duplicated info many times)

doesn't include graphics from privottable plugin. Example: pivottable in bugtracker16 summary tab

internal wiki links are not clickable nor converted to the absolute url counterparts in the pdf when the option to show links at the bottom is selected in the tiki admin panel.

Reproduced here:
http://xavi-9794-6688.show2.tikiwiki.org/tiki-index.php?page=Tiki-Wiki-CMS-Groupware
u: admin
p: 12345

Current code used in the show instance:
--SVN (24.0vcs): Tuesday August 3, 2021 17:34:21 CEST - REV 78798 (InnoDB) --

Upgraded today (server side) to latest 24.x branch: r79594 (Last Changed Date: 2022-01-22 14:46:09 +0100 - Sat, 22 Jan 2022)

In that page, there is an internal wiki link to HomePage:
{CODE()}
((HomePage))
{CODE}

The user would expect to have that link converted in the pdf as a link to:
http://xavi-9794-6688.show2.tikiwiki.org/tiki-index.php?page=HomePage

but it's not converted to any link, it's just shown as simple standard text (with no indication that it refers to another page in that tiki site)

See the pdf produced by mpdf for instance here:
{file type="gallery" fileId="1563" showicon="y"} (using trunk from august 2021, r78798)
{file type="gallery" fileId="1706" showicon="y"} (using branch 24.x Jan 2022, r79594)

When you use a wiki page as template (pretty tracker, pluginlist+semantic alias, etc) we have several component that refer to the template page name and not the item (title) it is displaying.

Things like Multilike, Forum for discussion, Wiki argument variables { {page} }, etc

They will refer/link to the page itself and not to the item title.

IE: I have a template page named __record tpl__ to display a tracker item contact (title:bernard) and on the page I have set Forum for discussion option to create automatically a topic in the forum to discuss about this contact: bernard.

Normally I would expect the title of the discussion to be bernard but it will be "record tpl" and also there will be only one discussion for ALL my items (as the reference is the wiki page object and not the itemId displayed).

Same goes for { {page} } it will show "record tpl" and not "bernard"

Going to Admin Categories > Bug on dev.tiki.org returns alerts on top of the page:
{CODE()}
ErrorErrorError
Tracker list_items ran out of memory after 0 items.Malformed search query: Parsing search query failed: "org.elasticsearch.common.ParsingException: [_na] query malformed, must start with start_object"Notice: invalid variable value: $_GET["maxRecords"] = undefined
{CODE}