Category: Error

{maketoc}

Using 1.9.cvs

!! 1st trial
!!! Using a tracker plugin code within this page content:
{CODE()}
{MAKETOCBOX(float=>none)}{MAKETOCBOX}
!! Ofertes de recursos o serveis

!!! Oferiments de transports
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Transport, exactvalue=>Transport, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments de recursos (materials)
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Recurs, exactvalue=>Recurs, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments de serveis (immaterials)
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Servei, exactvalue=>Servei, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments d'altres coses
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Altres, exactvalue=>Altres, goIfOne=>n)}Com????{TRACKERLIST}

!! Insereix nous oferiments a la base de dades
{TRACKER(trackerId=>2, fields=>5:6:7:17:8:16:11, action=>Envia les dades del teu oferiment, showtitle=>n, showdesc=>n, showmandatory=>y, embedded=>y)}Oferiment enviat amb èxit! Pots continuar navegant per la web amb normalitat. {TRACKER}
{CODE}

!!!- Tracker 2 is this one:
{CODE()}
[TRACKER]
trackerId = 2
name = Ofertes
description = Ofertes de recursos i serveis de persones de la Vall del Corb i afins
useExplicitNames = n
showStatus = y
defaultStatus = o
showStatusAdminOnly = n
outboundEmail =
simpleEmail = n
newItemStatus = o
modItemStatus =
writerCanModify = y
writerGroupCanModify = n
showCreated = y
showLastModif = y
defaultOrderKey = -1
defaultOrderDir = asc
useComments = y
showComments = n
useAttachments = y
showAttachments = n
attachmentsconf = 0,1,3,0,2,0,0,0
useRatings = n
ratingOptions =
categories = 3
{CODE}

!!!- And its fields are these:
{CODE()}
[FIELD5]
fieldId = 5
name = Què ofereixes?
position = 10
type = t
options =
isMain = y
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = y
[FIELD6]
fieldId = 6
name = Tipus d'oferta
position = 20
type = d
options = Recurs,Servei,Transport,Altres
isMain = n
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = y
[FIELD7]
fieldId = 7
name = Descripció
position = 30
type = a
options = 1
isMain = n
isTblVisible = n
isSearchable = y
isPublic = y
isHidden = n
isMandatory = n
[FIELD17]
fieldId = 17
name = Foto
position = 35
type = i
options = 50,50,400,400,400
isMain = n
isTblVisible = n
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
[FIELD8]
fieldId = 8
name = Persones interessades
position = 40
type = l
options = 3,15,5,14,1
isMain = n
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = n
isMandatory = n
[FIELD16]
fieldId = 16
name = Demanda relacionada
position = 45
type = r
options = 3,9,1
isMain = n
isTblVisible = y
isSearchable = n
isPublic = y
isHidden = n
isMandatory = n
[FIELD11]
fieldId = 11
name = Persona que ho ofereix
position = 50
type = u
options = 1
isMain = y
isTblVisible = y
isSearchable = y
isPublic = y
isHidden = p
isMandatory = n
{CODE}

!!! I inserted this information:

||Què ofereixes? *: | Manual d'administració de Webs com aquesta
Tipus d'oferta *: |Recurs
Descripció: | En pdf..., i en català . tot i que la versió en anglès és més complerta.
Foto: |
Demanda relacionada: |
Persona que ho ofereix | admin
| submit button ||
''(At this page: [http://www.moviments.net/valldelcorb/Ofertes] )''

!!! I get this message after attempting to insert a new record:
^
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 '='Ofertes' where `itemId`='13'' at line 1
^

!! 2nd trial
I made another trial in another page just having the tracker plugin ([http://moviments.net/valldelcorb/prova]), with just this content in the page:
{CODE()}
{TRACKER(trackerId=>2, fields=>5:6:7:17:8:16:11, action=>Envia les dades del teu oferiment, showtitle=>n, showdesc=>n, showmandatory=>y, embedded=>y)}Oferiment enviat amb èxit! Pots continuar navegant per la web amb normalitat. {TRACKER}
{CODE}

I got this message:
^
Warning: mysql error: 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 '='prova' where `itemId`='14'' at line 1 in query:

update tiki_trk_2 set =? where `itemId`=?


in /home/httpd/tiki19/lib/tikidblib.php on line 134
^

Tracker plugin show logged user info and not actual tracker data for user preference fields.

I set the tracker plugin with transaction step.
So I split the initial plugin tracker into 5 plugin trackers setting the following parameters for each one: transactionName, transactionStep and transactionFinalStep.
Something that looked like:

{CODE()}{TRACKER(trackerId="4" fields="1:2:3" transactionName="new" transactionStep="0" transactionFinalStep="n")}{TRACKER}{CODE}

{CODE()}{TRACKER(trackerId="4" fields="4:5:6" transactionName="new" transactionStep="1" transactionFinalStep="n")}{TRACKER}{CODE}

…/… till the last step a bit different.

{CODE()}{TRACKER(trackerId="4" fields="10:11:12" action="Save" transactionName="new" transactionStep="4" transactionFinalStep="y")}Thanks{TRACKER}{CODE}

The page show an error : You need to define both transaction name and transaction step, or none of the two.

It has been confirmed that it is not working

When using the Tracker Plugin in a form to input data the Text and Text Area Field Types are not displaying the acutal input box, only the field description is showing. I have temporarily changed the field types to other types (checkbox, dropdown, etc) and then the actual input box does appear.

I have tested the same form on several different TikiWiki 2.0 sites and I have the same problem on each of the different sites.

On Tiki22 on a tracker list items view I want to see in the listing the date and the modifier. I enabled "Show item last modifier".

Nothings happen.

Is it a bad description for the option ? (only work for item view)
Or something we used to have and is now broken ?

They are cases It would very handy to be able to list items and see the last modifier.

You can see the issue on http://dev.tiki.org/tracker5

There is a column that says coms which is suppose to show the number of comments but also who was the last author who added a comment and when. Right now it seems to always show Today's date instead of the last date of the most recent comment.

{img fileId="611" thumb="y" rel="box[g]"}
{img fileId="610" thumb="y" rel="box[g]"}
{img fileId="612" thumb="y" rel="box[g]"}

tracker status not shown in php7 at tiki-view_tracker.php

To reproduce, use php 7.x, install a new tiki site, and apply the "Bug tracker" profile, for instance.
Then attempt to view status at tiki-view_tracker.php?trackerId=1

"showStatus" shows no column (not even the green question mark)
"showStatusAdminOnly" shows the green question mark in that column
column shown in tiki-view_tracker.php/tpl (the left most column of the table)

and looking at tiki-view_tracker.php, $smarty->assign('status_types', $status_types); get 0 number of status_types
in the count
line 160 onwards, in 15.x
therefore, $tracker_info["showStatus"] = 'n';
...
(and getting lost there)
Someone with better skills of the differences between php7 and earlier versions is needed.
---
~np~[~/np~Edit Torsten: ist that maybe related to [https://dev.tiki.org/item6254|Bug 6254] ? ~np~]~/np~
---

When using the maximum length field in a textfield tracker type, it provides a false negative when emoji are used.

To reproduce:

*Create a text field tracker type.
*Set "maximum length" option to 2
* Insert 2 emoji into the field.

Tiki complains and says only 2 characters may be used.

When creating or editing a tracker item, multi-line fields (text areas) can offer a toolbar, as wiki pages do. This works fine if the 'Use legacy tracker insertion screen' (tracker_legacy_insert) preference is enabled, but otherwise there are several bugs. Notably:
# The tooltips supposed to use Bootstrap popover are not processed, so they display as native titles, starting with a colon.
# The tools to insert internal and external links are sometimes unusable, at least in Firefox 53. The dialog appears, but clicking the text fields does not focus them. This does not happen in Google Chrome.
# Clicking the question mark quietly closes the edition dialog, losing the changes.

Yet, there are no JavaScript errors. I guess issue #1 occurs because the JavaScript for popovers runs on page initialization, so it does not catch popovers added to the DOM later. Other issues are probably similar, but I tried debugging issue #3 using Chrome developer tools unsuccessfuly. I fail to see an event listener on the question mark icon. I do not understand why the dialog would close when clicking if no JavaScript is run. There is no HTTP request when clicking.

The new edition screen was added notably in r50712 and r50714. This affects Tiki 15, 16, 17 and trunk (as of r63265). I set Importance to 8 because issue #3 can cause a certain data loss. I am surprised not to find an existing report of this bug since the field I am filling right now is affected by this problem.

On dev.t.o, on tracker view items it is not possible anymore to use the tracker filter option.

See: https://dev.tiki.org/tracker5

{file type="gallery" fileId="1634" showicon="y"}

When using the Tracker-plugin in an article-body like this (or however, just use it in a way, that it shows fields ;) ):

~np~
{TRACKER(trackerId=>3,fields=>7:8{TRACKER}
~/np~

then it breaks in a way, that it parses the tracker-field-name as a link.

~np~
<input type="text" name="track[7]" value=""size="30"/>
~/np~

becomes

~np~
<input type="text" name="track<a class="wiki" href="7">7</a>" value=""size="30"/>
~/np~

On a Tiki24 the tracker action menu is misplaced on RTL language.
This is because the class sm-right that is applied here.
A bootstrap class (start or end) should be use instead of hardcoded left or right.

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

((doc:PluginTrackerCalendar)) allows to display tracker items in calendar view, as well as resource view.
An extra option was suported by fullcalendar lib and ported to tiki a few years ago, which displays items in "list" view, which is like an "agenda" view of items from the tracker calendar info.
https://doc.tiki.org/PluginTrackerCalendar#List_views

In Tiki 24.x this list view is not shown, and some neverending spinner is displayed instead.
Reproduced in short in a show instance here:
---

When attempting to reproduce it I realized where the problem was: -+listYear+- as default view doesn't exist as such (even if the button in the UI says "List Year" for that param, but the param internally is "-+list+- (while all the others related to list are listMonth, listWeek, lkistDay

Solved. Closing report and removing show instance.

For a project with requirements that are too complex for Tiki-Calendar, I use the TrackerCalendar plugin. One of the problems I'm struggling with is the handling of timezones. I am running two Tiki installations on the same server. Both with Tiki version 18.3 and PHP version 7.1.28, but with different MySQL settings. For both systems Search engine Lucent was active and timevalues were displayed correctly. On both systems I changed to MySQL full text search; clear all Caches; rebuild search index; clear all Caches again.

Now system 1 still shows timevalues correctly in TrackerCalendar plugin. System 1 is running on MySql 5.5 with InnoDb.

But system 2 shows UTC values. System 2 is running on MySql 5.7 with MyISAM.

The comparison method in the TrackerFilter plugin is not comparing.

No matter which operator you choose

>, <, >=, <=

( for greater than, less than, greater than or equal, less than or equal)

it returns all the records.

This is if performed on a text or a numeric field so far.

Tested on three tikis.

Sample of code (produced by the the wiki's plugin help)

{TRACKERFILTER(filters="54/<=",action="find em",trackerId="13",fields="53:54")}
here ya go
{TRACKERFILTER}

{syntax type="tiki" editor="plain"}
The comparison method in the TrackerFilter plugin is not comparing.

No matter which operator you choose

>, <, >=, <=

( for greater than, less than, greater than or equal, less than or equal)

it returns all the records.

This is if performed on a text or a numeric field so far.

Tested on three tikis.

Sample of code (produced by the the wiki's plugin help)

{CODE(caption="trackerFilter code used")}{TRACKERFILTER(filters="54/<=",action="find em",trackerId="13",fields="53:54")}
here ya go
{TRACKERFILTER}{CODE}


!!Update
I have reproduced this on a completely separate system, http://www.softaculous.com/

Brand new Tiki 6.1
Only Trackers turned on (over a default installation)
One tracker with one field

Using the filter value 1/>

It returns all records.

r46077

At [http://dev.tiki.org/Bug Tracker List|Bug Tracker List] the first filter is "Area" (item link field) only "any" is displayed, area are missing.

The second field is "Sub-category" It show catId instead on name of the categories.

{syntax type="tiki" editor="plain"}
I originally stated the popup did not display correctly. Now it does not display at all.

In the show.tiki instance there are 5 fields in the tracker.
Only the first is listed using PluginTrackerFilter. The remainder are set to be displayed in a popup. But the popup does not appear.

I added the show.tiki instance before discovering a similar item. I've set that item in the "related to" field. It states that if the fields to be popped up are already listed, then the popup works. I tested this by adding the fields in the tracker filter. It did not help, so I rolled back the change.

It was mentioned that there is no point in displaying something in a popup that is already listed. So I tested including all the fields in the listing and using a pretty tracker to only display one. It did work this way either. This is the page that uses a pretty tracker:
http://hrsms-11204-3728.show.tikiwiki.org/tiki-ndex.php?page=ListWithPrettyTracker

Admins and other groups can see all tracker items if status="opc" is set, while an anonymous user can only see the open items.
TW5.0Beta1

Example:
~np~{trackerlist trackerId="1" fields="23:11" sort="y" showtitle="n" showlinks="y" showdesc="n" showinitials="n" showstatus="y" showcreated="y" showlastmodif="y" showfieldname="y" showitemrank="n" status="opc" sort_mode="lastModif_desc" max="10" showpagination="n" filterfield="43" filtervalue="C" ignoreRequestItemId="y" silent="n"}~/np~

The open and closed issues are fine.

On Tiki (tested on tiki21.4), in a tracker you can set a dropdown tracker field with a default value by setting twice the same value and you can set the label for the values: https://doc.tiki.org/Drop-Down---Radio-Tracker-Field

IE in the "Option" for the field (3 in our exemple):
NO=Nouveau,NO=Nouveau,PE=En Attente,CL=Ferme

This is working fine.

On a wiki page you can use then a tracker list plugin to list the item like:
{CODE(caption="Work")}
{trackerlist trackerId="1" fields="1:2:3" filterfield="3" exactvalue="PE"}
{CODE}
This will work.

However if you try to filter using the default dropdown value it won't work anymore (was working on Tiki18)
{CODE(caption="Doesn't work")}
{trackerlist trackerId="1" fields="1:2:3" filterfield="3" exactvalue="NO"}
{CODE}

This is a regression on Tiki21.4
Work on Tiki23

Create a group and put that group as tracker admin of a particular tracker (through individual tracker perms). This group should not have global tiki_p_admin_trackers.

Even though a user in that group can edit the field set as isHidden, i.e. only admin can view, through tiki_view_tracker_item.php (correct behaviour), the tracker list plugin won't show the field for him (wrong behavior).

{syntax type="tiki" editor="plain"}
TW5.0beta1
Fields=X:Y
Filterfield=Z
shows a table with X:Y:Z
with Z having obviously all the same values

See http://dev.tikiwiki.org/TestTrackerlist

You will see that links do not how on the first trackerlist plugin. They work on the second and third one though.

Removing description from the fields shown in the popup seems to fix it. But not all descriptions seem to break it though - see the second plugin filtered differently which works.

{syntax type="tiki" editor="plain"}
Using Popup inside plugin trackerlist sends a very big & faulty html to the browser. The file for a tracker of less than 20 rows has 80 MB.
FF, IE and Chrome have big problems with it.
Sometimes a crippled table is shown, sometimes nothing.
Heavy load on cpu.
To let it be not too easy:
The same setup worked for a while. But now it produces always the same problem on 3 browsers on 2 computers.

I could upload the html-file if someone wants to see it. It contains kind of valid start but somewhere has tons of ////. Seems to be some recursive content.

trackerlist trackerId="1" fields="1:12:6:9" popup="7" showlinks="y" showstatus="y" status="opc"

Version 6.2 german

{syntax type="tiki" editor="plain"}
Seen problem on ! and ^

Ex.:
http://dev.tikiwiki.org/tiki-index.php?page=WYSIWYG