Category: Dogfood on a *.tiki.org site

There is an empty comment from Adrien at https://dev.tiki.org/tiki-view_tracker_item.php?itemId=7935&threadId=9839
It is displayed as "" in the plugin Since last visit...

{img fileId="1642" thumb="box"}
{img fileId="1643" thumb="box"}

Links to remove email notification messages come without hash (see below the live example from TikiFestNY)

http://tikiwiki.org/tiki-user_watches.php?hash=

{QUOTE()}
Edit article post: TikiFest NY by lindon at Tue 24 Nov. 2009 06:10 CET

View the article at:
http://tikiwiki.org/article179

If you don't want to receive these notifications follow this link:
http://tikiwiki.org/tiki-user_watches.php?hash=
__''Announcing the first ever TikiFest in New York City being held from January 14-18, 2010!''__

TikiFestNY is a big bug squash! The idea is to knock out as many bugs as possible and have as much fun as possible doing it. If a bug takes more than 30 minutes to fix, then we move on to the next one. Also, invites will be going out locally for an introduction to Tiki presentation on Saturday afternoon followed by refreshments. Hope lots of people can make it! Remote participation is also possible for those that can't. Find complete information at TikiFestNY.

%%%::__~~purple:{COUNTDOWN(enddate=>14-Jan-2010 locatetime=>off)} until TikiFestNY!{COUNTDOWN}~~__::

%%%::''__See you there!__''::
----------------------
{QUOTE}

[http://tikiwiki.org/tiki-searchresults.php?highlight=rss&where=forums&search=Search+in+content|Link to error]

On the main forum page of tw.o I enter the text "rss" then search button and get the following:



The following error message was returned:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

The query was:
SELECT `rssId`, `url`, `actions` FROM `tiki_rss_modules` WHERE (`lastUpdated` < ? - `refresh`) AND `rssId` IN( )

Values:

1. 1270869772

The built query was likely:
SELECT `rssId`, `url`, `actions` FROM `tiki_rss_modules` WHERE (`lastUpdated` < '1270869772' - `refresh`) AND `rssId` IN( )

When I try to access d.t.o. to make comments or file bugs, I get very many "Err_Tunnel_Connection_Failed" error messages instead of the the content requested. Looks like there is a hiccup in hosting d.t.o. ...

{syntax type="tiki" editor="plain"}
Hello,

This concerns the [http://dev.tikiwiki.org/Search+Bugs] and [http://dev.tikiwiki.org/tiki-index.php?page=Search+Bugs]

I have yet reported this bug, but because of three crossed bugs 3104 and the "not found ones" this had been yet reported but not reachable.

__The three bugs are (were for the first) :__

!! 1- Report with no author
The registering of a "report a bug" was not always getting the author name. So, the report was, till ten days ago (diagnostic by chat and it seems repaired), treated as a not registered user (or logged in user ) writing.

!!!The consequences are :
# No way to access them (no ticket displayed) and no access if found for the real author. Nota : if you have the ticket number (got from chat when submitted ) you can access it reacting the http query for this ticket.

# no way to manage them by the registered author

I have between ten and twenty report lost by this way.
And because of the second bug I can't find them back (just those submitted while I was chatting because the ticked is displayed on the chat.

!! 2- Filter crash :
the reason is the use of the "IN()" SQL clause which is not accepted by MYSQL
It is impossible to check the list in a right manner

!!3- Crash on sort list
(click on column headers) for the same reason : use of "IN() clause into the SQL request

!Problems and solutions

!!Repair the request generation - all

!!Getback the management of his ticket to the real author

It is a lot of job and not fair to rewrite all the reports lost (generates doubletons).

The lonely solution seems to be that the author could submit to the manager (webmaster...) the list of the concerned reports (ticket number or title).

This needs to get a successful search (filter), implies that the 2d and 3td bug should be solved (I could not display an available list to find mines - I have sometimes made a local copy, so I have some dates, but at this dates or around I can't find my report, the list is always just a part of the full one)

!!Display the ticket number even the author is not known should be usefull

!!The mean of "any" in properties of report and display
Even this data means "any not defined" when you say "any" you mean actually : "only the marked - any - reports". So it is impossible without clicking individually all the checks "anyone" of this criteria.
The solution can be either :
*on the filter a button : select all
*a data for filter names "anyone"
*both

- "select all" allow to unselect someones after
- "anyone" makes a more simple query allowing to forgot the criteria


__Without these solutions it is either awful or impossible to manage his "reports a bug"
__

Trebly - 04/28/2010 - 3h.07 Paris

Error 500 if a ' is in the text of a Wiki page description.
This video doesn’t show the ' because it took me a few tried to understand why it failed but it is there (doesn't) . ?
Once removed (rewriting the sentence without) I could save the page description.

https://share.vidyard.com/watch/uYuxbDN2r4qEzzivSmoecy?

They may be other "forbidden" characters.

{syntax type="tiki" editor="plain"}
Hello,

I just submit a new search, the SQL request crashes with "system error" as reported in item 3104.

This seems to be solved a few days ago, but it was not a full solution.
Here beyond the beginning of the request :

SELECT tti.*, ttif.`value`, ttf.`type`, sttif.`value` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) LEFT JOIN (`tiki_tracker_item_fields` sttif) ON (tti.`itemId` = sttif.`itemId` AND sttif.`fieldId` = 41) INNER JOIN `tiki_tracker_item_fields` ttif0 ON (ttif0.`itemId` = ttif.`itemId`) INNER JOIN `tiki_objects` tob43 ON (tob43.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco43 ON (tob43.`objectId` = tco43.`catObjectId`) INNER JOIN `tiki_tracker_item_fields` ttif1 ON (ttif1.`itemId` = ttif0.`itemId`) INNER JOIN `tiki_objects` tob47 ON (tob47.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco47 ON (tob47.`objectId` = tco47.`catObjectId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=?) AND ttif0.`fieldId`=? AND tob43.`type` = 'trackeritem' AND tco43.`categId` IN ( ) AND ttif1.`fieldId`=? AND tob47.`type` = 'trackeritem' AND tco47.`categId` IN ( ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc...

You can notice that the syntax uses in "IN ()" clause which is not accepted by MYSQL.

!!Solution, first steps
Check all SQL queries for "IN()" clause and find a bypass anywhere in tikiwiki.

Trebly

{syntax type="tiki" editor="plain"}
!The forum display on
[http://tikiwiki.org/tiki-forums.php?forumId=2]
forumId=2 and all others

has normally headers of columns.
These header are button to sort the message on.

!!!The concerned headers are :
#Type
#Title
#Hits
#Author

The activate generates a request to sort the list.

__These sort requests generates a SYSTEM ERROR SQL Request with the main error type :

#Column 'type' in order clause is ambiguous
#Column 'title' in order clause is ambiguous
#Column 'hits' in order clause is ambiguous
#Column 'userName' in order clause is ambiguous__

Thank's for action

{syntax type="tiki" editor="plain"}
at the pages in dev.tiki.org I often get an error in chrome.
Like page: http://doc.tiki.org/Wiki+Plugin
Error on the screen: Fatal error: Allowed memory size of 201326592 bytes exhausted (tried to allocate 350 bytes) in /home/two/doc/lib/init/initlib.php on line 187

New feature about duplicate alias;
[ENH] Display error in wiki pages with duplicates alias links

Page https://doc.tiki.org/Tracker+Synchronization show multiple errors.

×
Error
Alias Tracker Sync link already present in 트래커 동기화 page(s)
Alias TrackerSync link already present in 트래커 동기화 page(s)
Alias TrackerS15n link already present in 트래커 동기화 page(s)
Alias Tracker S15n link already present in 트래커 동기화 page(s)
Alias S15n link already present in 트래커 동기화 page(s)

Also on : https://doc.tiki.org/Dynamic%20items%20list

Also on : https://doc.tiki.org/Requirements#PHP
Alias Requirements and Setup link already present in Anforderungen, 요구 사항 page(s)
Alias Requirement link already present in Anforderungen, 요구 사항 page(s)

{syntax type="tiki" editor="plain"}
When you go to https://dev.tiki.org/Wishlist and first remove the "Open" status from the "Status:" field and then click to sort the results column by "Modified" you get an error 403 and feedback in a remarksbox:

{CODE()}Oops trackerId parameter must be present <!--//--><![CDATA[//><!-- // js 0 window.elementPlus = {"select":{"enabled":true,"clearable":true,"collapseTags":true,"maxCollapseTags":3,"filterable":true,"allowCreate":false,"ordering":true},"autocomplete":true}; //--><!]]>{CODE}

{img src="display3244" thumb="box"}

when attempting to see this url ( [https://doc.tiki.org/tiki-index_p.php?page=Tiki26]), either through the "whats new wizard" ([http://localhost/tiki26/tiki-wizard_admin.php?&stepNr=7&url=tiki-index.php%3Fpage%3DHomePage&use-changes-wizard=1]) or directly in a new browser tab, I got this message:

{CODE()}
Too late to modify headers. Headers already sent by output_headers() called at [/home/tiki-doc/public_html/temp/templates_c/en_social^ea0943f75a262d8be544059ae17e04e9602d1469_0.file.header.tpl.php:482])
{CODE}

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

A few minutes later, reloading the page, displayed the page properly.
Weird (I had never seen such a thing in all previous tiki versions).

When you save a page on Tiki.org it just reload the previous content.

After a few attempts (copy/paste edited content) it accept to save.

Update 2021-07-07:
Happened again editing was almost lost ! ?

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

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

I had an error trying to login at dev from my iphone as well as on Chrome desktop

{img fileId="1550" thumb="box"}
{img fileId="1551" thumb="box"}

I have errors trying to access a file in a subfolder on dev.t.o on the file galleries.

Using the main link to open the folder Bug Report Image => bsfez I have errors.
Using the Tiki Explorer for the file galleries it worked.

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

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

---

Not the same issue but may be related, I couldn't set a plugin img after uploading and setting the plugin following the process using the dialog modal from the Help plugin. I also tested on Safari and Chrome.

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

I tested on Tiki19 using nextdev.
nextdev is using elfinder and it worked better but still I had to retry several times to get over an error after the upload (may be due to nextdev setup ?):
^Potential cross-site request forgery (CSRF) detected. Operation blocked. Reloading the page may help.^

https://nextdev.tiki.org/item6831-test-file-gallery
Not sure I can add 19.x to this ticket... In doubt I didn't.

On doc.t.o (homepage) I tried to use the PDF item from the action menu.

{CODE()}PDF generation failed. The package mPDF is not installed. You can install it using packages. This is set by the administrator (search for "print" in the control panels to locate the setting).{CODE}

I was doing some changes in the tiki.org look and feel => custom css field on one save I got this:

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

The field was emptied, I turned totally green and was ready to jump out of the window ! By change (as I had many unsaved work while using "save as minor") I had the content pasted in a text editor by security and could restore. (lost time)

Seems we have some preg backtrack limitation (http://php.net/manual/en/function.preg-last-error.php)

I could get over it by shorting (shorthand?) a background style, but one day someone else...

dev.tiki.org is not very usable with unstable Elasticsearch :(

Export Spreadsheet as csv with code to produce svg chart includes the svg output tags in the csv cell instead of the tiki syntax to generate the chart

Reproduced when attempting to export sheet4 in doc.t.o, which is part of the sample charts generated from the tiki spreadsheet feature:
https://doc.tiki.org/tiki-export_sheet.php?sheetId=4

When exported (as csv with comma, and utf8) the content is like:
{CODE(colors="htmlmixed")}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13),<div class="jSheetChart"><svg height="172" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M80,139L58,139L58,127L80,127Z" stroke="none" fill="#1751a7"></path><path d="M108,139L86,139L86,1,4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13),<div class="jSheetChart"><svg height="148" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M53,27L53,20L95,20L95,27Z" stroke="none" fill="#1751a7"></path><path d="M53,36L53,29L116,29L116,,6,Feb,2002
Pie,"=LINECHART(D2:D8, F2:F6)",<div class="jSheetChart"><svg height="220" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><text fill="#000000" stroke="none" font="12px Arial, sans-serif" style="text-anchor: middle; font: 12px A,7.2,Mar,2003
Line,"=PIECHART(D2:D8, E2:E8)",<div class="jSheetChart"><svg height="144" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path stroke-linejoin="round" stroke-width="1" style="stroke-width: 1; stroke-linejoin: round;" d="M210.5,7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

And in my honest opinion, it should be something like:
{CODE()}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13)",=BARCHART(D2:D13),4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13)",=HBARCHART(D2:D13),6,Feb,2002
Line,"=LINECHART(D2:D8, F2:F6)",=LINECHART(D2:D8, F2:F6),7.2,Mar,2003
Pie,"=PIECHART(D2:D8, E2:E8)",=PIECHART(D2:D8, E2:E8),7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

When you have more than one calendar, and you have user watches enabled, the display of the icons to watch calendars is not shown. I tagged this as a dogfood a tiki.org site since this is an improvement needed for tiki users to get notified on Tiki fests, for instance. Currently, most powerusers don't know that they can monitor the tiki calendar.

In order to monitor calendars right now, you need to deselect all calendars, re-select just one, refresh, and then you will see the icon to watch / monitor /subscribe to the calendar. And you need to do that one by one.

Expected behavior: some way to see the list of all calendars with the icon to subscribe to each of them next to its name. Maybe through similar popup with the full list of calendars that you have the right to see and monitor, and then, you expose those icons/actions there?

Show.t.o instance:
http://xavi-9794-5877.show.tikiwiki.org
u: admin
p: 12345

There are 3+ calendars already, and when all are selected for display (default behavior), no icon to monitor them is shown:
http://xavi-9794-5877.show.tikiwiki.org/tiki-calendar.php

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

But when you select just one, you can see the icons to monitor it:
http://xavi-9794-5877.show.tikiwiki.org/tiki-calendar.php?calIds%5B%5D=3&todate=1459860043&refresh=Refresh

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

BigBlueButton 2.4 comes with a new feature called __Learning Analytics Dashboard__ (LAD from now on)
https://docs.bigbluebutton.org/2.4/new.html#learning-analytics-dashboard

{img src="https://docs.bigbluebutton.org/images/24-learning-dashboard-2.png"}

By default, the data behind this dashboard is deleted 2 minutes after the meeting finishes, but there is preference in bbb that can be changed to avoid deleting this meeting data.
https://higheredlab.com/how-to-check-bigbluebutton-learning-dashboard-after-the-session/

{CODE()}
By default data for the Learning Dashboard are kept for 2 minutes after a session ends and then are removed permanently.

In order to make the Learning dashboard persistent, you need to change the variable learningDashboardCleanupDelayInMinutes in /usr/share/bbb-web/WEB-INF/classes/bigbluebutton.properties.


To keep the learning dashboard data permanently, change the value to 0: LearningDashboardCleanupDelayInMinutes=0.

Once you make this please restart the bbb by running bbb-conf –restart.

In order to access the dashboard data you need to supply

1. The internal meeting id of the meeting, which is same as the directory name under /var/bigbluebutton/learning-dashboard/ on your server
2. The access token for the learning dashload, which is same as the subdirectory name under /var/bigbluebutton/learning-dashboard/<internal meeting Id>/

Then the learning dashboard can be accessed through https://your.bbb.com/learning-dashboard/?meeting=<internal meeting Id>&report=<access token>

If you wish to see the learning dashboard in your preferred language then you can an addition parameter to above url &lang=<language code>Then complete url would look like this : https://your.bbb.com/learning-dashboard/?meeting=<internal meeting Id>&report=<access token>&lang=<language code>
{CODE}

It would be nice to see a summary of attendance to a meeting, which would help to make meeting notes in use cases in which that document is needed and needs to be written: and recording needs to be played again to catch all attendants to a meeting, and eventually who where just listeners and which ones participated in any form (audio, chat, etc)

This extra information could be linked somehow from the report shown through ((doc:PluginBigBlueButton)) next to the recordings of a room, so that, besides the recording, you could access the log of that LAD.
Storing LAD data could be made optional (like the recording currently is) from within the PluginBigBlueButton in Tiki. If enabled, then the link to display the LAD would be shown next to the recording link, for those users in groups with the perm to see the recording.

Additionally, the bigbluebutton-api-php already has params to control LAD. Example:
https://github.com/bigbluebutton/bigbluebutton-api-php/blob/42e9455db8141176e7f349e64bdb53b1b7e5dfaa/src/Parameters/CreateMeetingParameters.php#L659


Does it make sense?

At the bottom of this page, the text "News" (and the others) is too close to the external link icon.

The title for External wiki links in not parsed, for instance
~pp~ ((wp:Link|Title)) ~/pp~
will display __Link__ instead of __Title__

We need this for *.tikiwiki.org as well
{img src=images/code.png}%%% {CODE()}
((dev:EditUIRevamp|Improve the content editing interface))
((dev:AdminUIRevamp|Improve the admin interface))
{CODE}

Say I need to make a link such as:
{img src=images/code.png}%%% {CODE()}
[http://en.wikipedia.org/wiki/Argument_map|Argument map]
{CODE}

I could use an ((doc:external wiki)) link which is like this:

{img src=images/code.png}%%% {CODE()}
((wp:Argument map))
{CODE}

Even nicer would be an image (instead of {img src=img/icons/external_link.gif}) so the visitor knows he'll be sent to Wikipedia.

Also, would need:
*optional title: to explain what this site is about. (ex.: this is a sister community)
*option to open new window
these would be set centrally and you could override.


Perhaps the direction to take is to build with ((doc:plugin alias))

This is a huge problem

Not easy to solve. Would need ((WikiParser)) work?